Key Responsibilities

- Design, develop, and maintain ETL workflows using Informatica PowerCenter.

- Analyze business requirements and translate them into technical data integration solutions.

- Develop mappings, sessions, workflows, and reusable transformations.

- Perform data extraction, transformation, and loading (ETL) from multiple source systems.

- Optimize ETL jobs and database queries to improve performance and scalability.

- Troubleshoot production issues and provide timely resolution.

- Collaborate with business analysts, data architects, and database teams.

- Ensure data quality, integrity, and compliance with organizational standards.

- Participate in release management, code reviews, and deployment activities.

Required Skills

- Strong experience with Informatica PowerCenter.

- Hands-on expertise in ETL/Data Integration Development.

- Advanced SQL skills on Oracle,



SQL Server, Teradata, or similar databases.

- Valuable understanding of Data Warehousing, Dimensional Modeling, and ETL concepts.

- Experience with workflow scheduling tools such as Control-M or Autosys.

- Knowledge of performance tuning and optimization techniques.

- Experience with Unix/Linux shell scripting.

- Strong problem-solving and analytical skills.

Preferred Skills

- Experience with Informatica Cloud (IICS/IDMC).

- Knowledge of Azure, AWS, or GCP data platforms.

- Exposure to Data Lake, Big Data, or Snowflake environments.

- Familiarity with Agile/Scrum methodologies.

- Banking, Financial Services, or Capital Markets domain experience is a plus.

📌 Informatica Developer Opening with CAPCO (Bengaluru)
🏢 CAPCO
📍 Bengaluru