Senior Informatica ETL Developer

Role : Senior Informatica ETL Developer

Locations : 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.

Type : Contract

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 PowerCenter / Informatica Intelligent Cloud Services, along with deep understanding of data models, CDC, SCD, and performance tuning.

Key Responsibilities:

• 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