Senior Informatica ETL Developer

About the role

Senior Informatica ETL Developer with strong Data Warehouse experience consultant in multiple US locations

Tasks

• 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

Requirements

• Candidate must currently live within reasonable commuting distance of the office.
• We are preferring ETL - Source to target mapping, incremental push (or incremental load), informatica PowerCenter.
• 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.
• 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.
• Visa: Genuine H4 EAD,USC & GC Only

Schedule

• it’s a hybrid role, 3 days in a week work from office is must in this role.

How to apply

• Send your updated resume.

Location

• 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