We are seeking an experienced ETL Developer with robust expertise in Informatica IICS (Intelligent Cloud Services) and Power Center to design, develop, and optimize data integration solutions. The ideal candidate will have a solid 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 Power Center

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

📌 Informatica Developer (Bengaluru)
🏢 Capgemini
📍 Bengaluru