Job Description :
Senior ETL / Informatica Developer

Location: Detroit, MI

Duration: 10-11 months


The Senior ETL / Informatica Developer must have prior hands-on experience delivering/leading successful data warehousing projects using ETL Tools PowerCenter, Informatica Cloud and ICRT. This individual is responsible for working with other teams with minimal or no supervision and should have strong professional consulting skills and the ability to communicate well at all levels within the division.

Required expertise in tools & technologies:

Must Have

- Informatica 9.x and above

- Informatica cloud and Realtime cloud services

- Oracle 10g and above

- Unix Shell Scripting - AIX or Linux

- Any one of the scheduling Tools (like CA-7, Tivoli, Auto-sys and Ctrl-M)

Strongly preferred

- Informatica Power center

- Informatica Cloud and Realtime


- Production support experience

Other skills/experience required:

- More than 5 years’ experience as ETL Developer using Informatica, Oracle 10g/11g

- More than 5 years of experience in designing using Informatica, Oracle 10g/11g

- More than 2 years of experience working in Informatica cloud and Realtime cloud services

- Experience in production support is strongly preferred

- Excellent understanding of data warehousing concepts.

- Candidate should be able to clearly communicate fundamental concepts during the interview and demonstrate previous experience in all aspects.

- Experience in Business Intelligence reporting tools like Cognos and Business Objects

- Experience in Oracle database programming using Partitioning, Materialized View and OLAP

- Experience in tuning Oracle queries/processes and performance management tools

- Experience in scheduling tools like Tivoli, Auto-sys

- Strong business and communication skills

- Knowledge of Health Care Insurance Payer Data Warehousing Preferred


- The Senior Developer should be able to perform the following with minimal supervision:

- Understand Business Requirements and Conceptual Solution

- Convert Business Requirements into Technical Requirements and Design

- Create High Level Design

- Attending daily calls with business teams

- Understand the source systems and conduct the data profiling

- Assist and resolve production issues

- Participate in Gap analysis meetings

- Create Informatica Mappings, Workflows and Sessions

- Understand the source systems and conduct the data profiling

- Create Source to Target Mapping Specifications

- Conduct Unit Testing and create Unit Testing Results Documents

- Provide Support for QA/UA Testing

- Migrate the code to Production

- Follow the standards and processes defined

- Contribute for process and performance improvements