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