Description

Key Responsibilities

Lead the design, development, and support of ETL solutions using Informatica PowerCenter.

Analyze business requirements and translate them into scalable ETL and data integration solutions.

Design and implement complex mappings, workflows, sessions, and reusable components.

Lead ETL development teams and perform code reviews to ensure adherence to best practices.

Optimize ETL processes for performance, scalability, and reliability.

Work closely with business analysts, data architects, and stakeholders to define data integration strategies.

Troubleshoot and resolve ETL production issues while ensuring minimal business impact.

Support data migration, data quality, data governance, and modernization initiatives.

Collaborate with offshore/onshore teams and provide technical leadership throughout the project lifecycle.

Prepare technical design documents, deployment plans, and operational runbooks.

Required Skills

10+ years of IT experience with strong expertise in ETL and Data Warehousing.

8+ years of hands-on experience with Informatica PowerCenter.

Strong experience in ETL design, development, and performance tuning.

Extensive experience with SQL, query optimization, and database performance tuning.

Experience with relational databases such as:

Oracle

SQL Server

Teradata

Snowflake (preferred)

Strong understanding of Data Warehousing concepts, including:

Star Schema

Snowflake Schema

Fact and Dimension Modeling

Slowly Changing Dimensions (SCD)

Experience with scheduling tools such as Control-M or equivalent.

Excellent troubleshooting and root-cause analysis skills.

Strong communication and stakeholder management skills

Key Skills

Education

Any Gradute