d understanding of data warehousing concepts, performance tuning, and SQL, along with experience in scheduling tools and agile methodologies.

Key Responsibilities:

Develop ETL workflows using Informatica IICS and PowerCenter
Implement performance tuning strategies for ETL processes
Design and develop ETLs for fact and dimension tables using SCD Type-II
Write and optimize SQL queries for Oracle, DB2, Teradata
Prepare ETL specification documents and collaborate with testers and PMO
Work with scheduling tools like ESP, Control-M, Autosys
Participate in discussions with business users and IT stakeholders
Provide support for ODS/EDW environments and troubleshoot issues

Essential Technical Skills:

Strong ETL background, preferably with IICS experience
Proficient in SQL and database concepts
Knowledge of Informatica transformations and performance tuning
Experience with Oracle, DB2, Teradata
Familiarity with UNIX shell scripting and utilities
Exposure to Business Objects, Tableau (preferred)
Understanding of data warehousing concepts and SDLC

1a:T456,

We need an experienced Informatica PowerCenter Developer who can analyze Informatica mappings, workflows, and session XMLs, and validate SQL logic for functional correctness. The role focuses heavily on reading/understanding Informatica transformation logic and ensuring that equivalent SQL reflects the same behavior.

Key Responsibilities

Analyze Informa

Informatica Developer

Informatica Developer