Informatica Developer

Capgemini; Bengaluru; On-site; INR 700,000 - 1,200,000; Full time

Job summary

A leading IT service company seeks an experienced ETL Developer in Bengaluru. Candidates should have a strong background in ETL with expertise in Informatica IICS and PowerCenter. Responsibilities include developing ETL workflows, performance tuning, and working with databases like Oracle, DB2, and Teradata. This is a full-time position targeting mid-senior level professionals seeking to work in a dynamic environment.

Qualifications

• 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.

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.

Skills

ETL background

SQL

Informatica transformations

Performance tuning

Oracle

DB2

Teradata

UNIX shell scripting

Business Objects

Tableau

Job description

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

• 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

Seniority Level

Mid‑Senior level

Employment Type

Full‑time

Job Function

Information Technology

Industries

IT Services and IT Consulting