Senior Informatica Developer

Senior Informatica ETL Developer With Strong Data Warehouse ExperienceHybrid role, 3 days in a week onsite Domain: P&C Insurance. Job 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.Notes: 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.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/ Experience Required:Design and develop ETL pipelines to load data into Data WarehouseWork with multiple source systems (RDBMS, flat files, APIs) and integrate data into staging and DWH layersBuild and maintain Fact and Dimension tables based on business requirementsImplement Slowly Changing Dimensions (SCD Type 1, 2, 3) in ETL processesHandle Late Arriving Dimensions using industry best practicesImplement Change Data Capture (CDC) mechanisms, including scenarios without timestamp columnsOptimize long-running ETL sessions and improve performance using partitioning and tuning techniquesDebug and optimize complex SQL queries and ETL workflowsWork with clustered and non-clustered indexes, and understand row store vs column storeCollaborate with business and analytics teams for data validation and reporting needs