Randstad Sr. Data Engineer in Saint Louis, Missouri

Sr. Data Engineer

job details:

  • location:Saint Louis, MO

  • salary:$58 - $66 per hour

  • date posted:Monday, April 16, 2018

  • job type:Contract

  • industry:Information Technology

  • reference:614690

job description

Sr. Data Engineer

  • St. Louis, MO (Downtown)

  • 12 mo Contract

  • US Citizens or Green Cards REQUIRED

  • Non-Exempt

  • Market Rate

The individual resource will perform the following activities:

  1. Design, develop and implement ETL transformations using Informatica power center and related products. Develop ETL related scripts, database procedures and other services as needed for implementing the best practices of ETL implementation. Provide SME (subject matter expert) in ETL technology implementation.

  2. Design coded database objects, including stored procedures, Oracle packages, functions, views, and PL/SQL scripts used for data migration, fixes, transformations, and test data generation.

  3. Create, review, and deliver release documentation, reports, procedures, configuration documents and other required artifacts for updates to extraction, transformation, and load packages in order to: populate databases from different sources; integrate, consolidate and cleanse data; and, structure data for use in analytics applications.

  4. Promptly provide written status reports as requested by company on activities to achieve successful updates to company's databases, data engineering platforms, and data integration platforms according to the applicable schedule.

  5. As requested, perform problem diagnosis, identification and resolution for complex databases, data engineering platforms, and data integration platforms developed in Oracle, Informatica, and scripting language. Provide reports to company on activities to address problems.

  6. Develop, test, deploy and document code based on the company's design specifications. Implement schema changes and maintain data architecture standards across databases.

  7. Prepare, test and maintain database release code to ensure optimized performance of databases, data engineering platforms, and data integration platforms throughout the software development life cycle.

  8. Participate in peer code reviews.

  9. Provide training in a timely manner to company staff on data engineering activities and technical and business requirements associated with updates to company's applications.

Qualifications:

  • Bachelor's degree with major or specialized courses in Information Technology or commensurate experience.

  • 3+ years' related experience in performing listed activities.

  • Experience with Informatica PowerCenter.

  • Experience designing and delivering cross functional custom reporting solutions.

  • Experience with relational SQL and NoSQL databases, and Oracle.

  • Demonstrated ability to perform self-directed work while supporting multiple teams, systems and products.

  • Demonstrated ability to communicate effectively.

  • Availability to travel in connection with providing services.

  • Position requires US Citizen or lawful permanent resident with three or more years of US residency