Description

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

Responsibilities

• Design, develop, and maintain ETL workflows using Informatica PowerCenter/Cloud for enterprise data integration.
• 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, performance, and reliability, participating 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, or similar), including performance tuning.
• Deep understanding of data warehouse concepts (ETL/ELT, OLAP/OLTP, dimensional modeling, star/snowflake schemas).
• 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, collaborating with technical stakeholders.

Key Skills

Education

Any Gradute