Subcontractor

Birlasoft Limited

21h

About The Position

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.

Requirements

Strong experience in Data Warehousing concepts
ETL development expertise
Hands-on expertise in designing, developing, and optimizing ETL pipelines using Informatica PowerCenter / Informatica Intelligent Cloud Services
Deep understanding of data models
Experience with CDC
Experience with SCD
Experience with performance tuning
Experience with RDBMS, flat files, and APIs as source systems
Experience implementing Slowly Changing Dimensions (SCD Type 1, 2, 3)
Experience handling Late Arriving Dimensions
Experience implementing Change Data Capture (CDC) mechanisms, including scenarios without timestamp columns
Experience optimizing ETL sessions using partitioning and tuning techniques
Experience debugging and optimizing complex SQL queries and ETL workflows
Understanding of clustered and non-clustered indexes
Understanding of row store vs column store

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