We are seeking an experienced

ETL Developer

with strong expertise in

Informatica IICS (Intelligent Cloud Services)

and

PowerCenter

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

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:

Robust

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 (Mumbai)
🏢 Capgemini
📍 Mumbai