Work in Iowa Energy Jobs

Job Information

Randstad Senior Informatica Cloud Developer in west des moines, Iowa

Senior Informatica Cloud Developer

job details:

  • location:West Des Moines, IA (remote)

  • salary:$55 - $70 per hour

  • date posted:Friday, June 11, 2021

  • job type:Contract

  • industry:Professional, Scientific, and Technical Services

  • reference:847008

job description

Senior Informatica Cloud Developer

job summary:

Our client is looking for a Senior Informatica Cloud Developer to provide expertise for a 6 month project! The Senior ETL (Extract, Test and Load) Designer/Developer designs, develops, tests, implements, troubleshoots, optimizes and maintains enterprise level ETL jobs that implement complex ETL processes which reference a targeted centralized data warehouse. The incumbent analyzes data transformation requirements leveraged to build, refine, deploy and/or configure ETL architectural design patterns that maximize reuse and minimize change impact. The senior developer utilizes SQL, tools, and/or technology to implement robust, maintainable solutions that meet business and technical requirements.

location: WEST DES MOINES, Iowa

job type: Contract

salary: $55 - 70 per hour

work hours: 8am to 4pm

education: Bachelors


·Serves as subject matter expert in Informatica ETL tool, mapping design, architectural design, coding, implementation, performance tuning and debugging.

·Develops complex data extracts, applications and ad-hoc queries using Informatica Cloud.

·Maintains a strong understanding of ETL design principles required in building an enterprise data warehouse environment, including an understanding of the relationship between different data warehouse architectural layers, constructs and data design concepts.

·Creates complex SQL queries required to access tabular structures in Relational Database Management Systems (RDBMS).

·Experience in cloud technologies will be a plus.

·Experience in integrating with other SaaS applications like Salesforce will be a plus.

·Experience working with semi-structured data like JSON and XML will be a plus

·Provides technical guidance in the ongoing development of technical best practices for data movement, data quality, data cleansing and other ETL-related activities.

·Transforms functional specifications into ETL technical specifications and source to target mappings.

·Communicates effectively with Business Analysts, Data Modelers and Solution Architects to convert the ETL design into specific development activities.

·Constructs/refines ETL processes related to loading data into warehouse and provides ETL development guidance to junior level ETL developers.

·Documents ETL process thoroughly, including steps needed to migrate ETL/database objects between various environments including Development, UAT, Staging, and Production.

·Leads Unit and Integration Testing activities and assists in User Acceptance Testing as needed.

·Coaches, mentors and provides work direction to other junior level ETL designer/developers.

·Performs other related work as assigned.


  • Experience level: Experienced

  • Minimum 5 years of experience

  • Education: Bachelors


  • Informatica

  • ETL

  • mapping

  • Powercenter


  • cloud

Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.