Informatica Developer Opening with CAPCO

Capco; Pune District, Chennai, Bengaluru; Hybrid; INR 1,200,000 - 1,800,000; Full time

Job summary

Capco is seeking an experienced ETL/Data Integration Developer to design, implement, and optimize Informatica PowerCenter workflows in Pune. You will translate business requirements into robust data integration solutions and develop mappings, sessions, and reusable transformations across multiple source systems.

The role requires strong SQL across Oracle/SQL Server/Teradata, plus expertise in Data Warehousing concepts, dimensional modeling, and ETL best practices.

Qualifications

• Experience designing and maintaining ETL workloads using Informatica PowerCenter.
• Translate business requirements into data integration solutions.
• Strong SQL skills across Oracle/SQL Server/Teradata or similar databases.
• Knowledge of Data Warehousing concepts, Dimensional Modeling and ETL principles.
• 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.

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.

Skills

Informatica PowerCenter

ETL/Data Integration Development

Advanced SQL

Data Warehousing

Dimensional Modeling

ETL concepts

Control-M

Autosys

Unix/Linux shell scripting

Problem solving

Tools

Control-M

Autosys

Job description

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