Subcontractor

Birlasoft Limited

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
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service