Description

You will design, build, and optimize enterprise data integration and data warehouse solutions.

This role is hybrid.

Responsibilities

• Design, develop, and maintain ETL workflows using Informatica PowerCenter or Cloud.
• Implement data loading strategies for large-scale structured and semi-structured data.
• Develop efficient SQL queries, stored procedures, and tune performance for optimal data processing.
• Design and implement data comparison and reconciliation mechanisms to ensure data quality.
• Optimize ETL pipelines for scalability and participate in code reviews and production support.

Required Skills

• 8+ years of experience as an Informatica Developer in enterprise data warehouse environments.
• Strong expertise in SQL (Oracle, SQL Server, PostgreSQL) including performance tuning.
• Deep understanding of data warehouse concepts (ETL/ELT, OLAP/OLTP, dimensional modeling).
• Hands-on experience in data loading techniques (incremental loads, CDC, batch, streaming).
• Strong knowledge of data comparison and reconciliation mechanisms for large data sets.
• Experience with ETL performance optimization and error handling.
• Familiarity with cloud data platforms like BigQuery or Google Cloud Platform.
• Ability to work in Agile teams and collaborate with technical stakeholders.

Key Skills

Education

Any Gradute