Senior Informatica ETL Engineer – Data Warehouse & CDC

Talentola; Dallas (TX); On-site; USD 110,000 - 150,000; Full time

Job summary

Talentola is seeking a Senior Informatica ETL Developer to lead design, development, and optimization of ETL pipelines. You will work with Informatica PowerCenter and Informatica Intelligent Cloud Services to implement data warehousing solutions, including CDC and SCD handling, optimization of long-running ETL processes, and collaboration with analytics teams for accurate data validation and reporting.

The ideal candidate has strong SQL skills, experience with data modeling, and hands-on

Qualifications

• Hands-on experience designing, developing, and optimizing ETL pipelines.
• Strong understanding of data warehousing concepts and data modeling.
• Experience with CDC, SCD, and performance tuning in ETL jobs.

Responsibilities

• Design and develop ETL pipelines to load data into Data Warehouse.
• Work with multiple source systems and integrate data into staging and DWH layers.
• Build and maintain Fact and Dimension tables based on business requirements.
• Implement SCD Type 1, 2, 3 in ETL processes.
• Handle Late Arriving Dimensions using best practices.
• Implement CDC mechanisms, including scenarios without timestamp columns.
• Optimize long-running ETL sessions with partitioning and tuning techniques.
• Debug and optimize complex SQL queries and ETL workflows.
• Work with indexes and understand row store vs column store.
• Collaborate with business and analytics teams for data validation and reporting needs.

Skills

ETL pipelines

Data warehousing concepts

Performance tuning

SQL queries

CDC

SCD (Type 1/2/3)

Data validation

Tools

Informatica PowerCenter

Informatica Intelligent Cloud Services

Job description

Talentola is seeking a Senior Informatica ETL Developer to lead design, development, and optimization of ETL pipelines. You will work with Informatica PowerCenter and Informatica Intelligent Cloud Services to implement data warehousing solutions, including CDC and SCD handling, optimization of long-running ETL processes, and collaboration with analytics teams for accurate data validation and reporting.

The ideal candidate has strong SQL skills, experience with data modeling, and hands-on