Senior Informatica ETL Developer strong Data Warehouse

Senior Informatica ETL Developer With Strong Data Warehouse Experience

Hybrid role, 3 days in a week onsite Domain: P&C Insurance. Job Location s:
Alpharetta, GA;
Charlotte, NC;
Chicago, IL;
Conshohocken, PA;
Dallas, TX;
Denver, CO;
Fargo, ND;
Garden City, NY;
Houston, TX;
Lenexa, KS;
Lubbock, TX;
Morristown, NJ;
Mt Juliet, TN;
New York, NY;
Purchase, NY;
Topeka, KS.

Notes:
We are preferring ETL - Source to target mapping, incremental push (or incremental load), Informatica Power Center. We are not looking for Snowflake Technology; we are looking for data modelling concept snowflake/star schema. Snowflake data experience is ok but not mandatory.

Job Summary:

We are looking for a Senior Informatica ETL Developer with strong experience in Data Warehousing concepts and ETL development. The candidate should have hands-on expertise in designing, developing, and optimizing ETL pipelines using Informatica Power Center / Informatica Intelligent Cloud Services, along with deep understanding of data models, CDC, SCD, and performance tuning.

Key Responsibilities / Experience

Required:

• Design and develop ETL pipelines to load data into Data Warehouse
• Work with multiple source systems (RDBMS, flat files, APIs) and integrate data into staging and DWH layers
• Build and maintain Fact and Dimension tables based on business requirements
• Implement Slowly Changing Dimensions (SCD Type 1, 2,
  3) in ETL processes
• Handle Late Arriving Dimensions using industry best practices
• Implement Change Data Capture (CDC) mechanisms, including scenarios without timestamp columns
• Optimize long-running ETL sessions and improve performance using partitioning and tuning techniques
• Debug and optimize complex SQL queries and ETL workflows
• Work with clustered and non-clustered indexes, and understand row store vs column store
• Collaborate with business and analytics teams for data validation and reporting needs