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

PowerCenterImplement

performance tuning

strategies for ETL processesDesign and develop ETLs for

fact and dimension tables

using

SCD Type-IIWrite and optimize

SQL queries

for Oracle, DB2, TeradataPrepare

ETL specification documents

and collaborate with testers and PMOWork with

scheduling tools

like ESP, Control-M,



AutosysParticipate in discussions with business users and IT stakeholdersProvide support for

ODS/EDW environments

and troubleshoot issues

Essential Technical Skills:

Solid

ETL background , preferably with

IICS experienceProficient in

SQL

and database conceptsKnowledge of

Informatica transformations

and

performance tuningExperience with

Oracle ,

DB2 ,

TeradataFamiliarity with

UNIX shell scripting

and utilitiesExposure to

Business Objects ,

Tableau

(preferred)Understanding of

data warehousing concepts

and SDLC

📌 Informatica Developer (Mumbai)
🏢 Capgemini
📍 Mumbai