Informatica IDMC ( Kolkata )

Price Waterhouse Cooper LLP; Kolkata District; Hybrid; INR 700,000 - 1,200,000; Full time

Job summary

Price Waterhouse Cooper LLP is seeking an experienced Informatica IDMC Developer in Kolkata, West Bengal, with 4–7 years of hands-on data integration, ETL development, and cloud data management experience. Proficiency in IDMC and CDI is required to design and deploy robust data pipelines.

The role involves building mappings, taskflows, and ETL pipelines, integrating cloud and on‑prem sources, and ensuring data quality and governance. Strong SQL and problem‑solving skills are essential.

Qualifications

• 4–7 years of experience in Informatica ETL and data integration.
• Hands‑on experience with Informatica IDMC (IICS).
• Strong knowledge of Cloud Data Integration (CDI).
• Experience in mappings, transformations, mapping tasks, and taskflows.

Responsibilities

• Design, develop, and maintain data integration workflows using Informatica IDMC.
• Build and optimize mappings, mapping tasks, taskflows, and synchronization tasks.
• Develop ETL/ELT pipelines to extract, transform, and load data from multiple sources.
• Work with cloud and on‑premises data sources, databases, flat files, APIs, and other data systems.
• Perform data transformations, data cleansing, validation, and quality checks.
• Monitor job execution, troubleshoot failures, and optimize performance.
• Implement error handling, logging, scheduling, and workflow dependency management.
• Collaborate with business analysts, data architects, QA teams, and other developers.
• Support production deployments, incident resolution, and ongoing maintenance.
• Follow data governance, security, and development standards.

Skills

Informatica IDMC (IICS)

Cloud Data Integration (CDI)

SQL

Data warehousing concepts

ETL/ELT processes

Performance tuning

Communication

Tools

Informatica IDMC (IICS)

Job description

Job Description: Informatica IDMC

Job Title: Informatica IDMC
Location: Kolkata, West Bengal
Experience: 47 Years
Employment Type: Full-time

Job Summary

We are looking for an experienced Informatica IDMC Developer with 4–7 years of experience in data integration, ETL development, and cloud-based data management. The candidate should have hands‑on experience with Informatica Intelligent Data Management Cloud (IDMC), designing and developing data integration workflows, and supporting data pipelines.

Key Responsibilities

• Design, develop, and maintain data integration workflows using Informatica IDMC.
• Build and optimize mappings, mapping tasks, taskflows, and synchronization tasks.
• Develop ETL/ELT pipelines to extract, transform, and load data from multiple sources.
• Work with cloud and on‑premises data sources, databases, flat files, APIs, and other data systems.
• Perform data transformations, data cleansing, validation, and quality checks.
• Monitor job execution, troubleshoot failures, and optimize performance.
• Implement error handling, logging, scheduling, and workflow dependency management.
• Collaborate with business analysts, data architects, QA teams, and other developers.
• Support production deployments, incident resolution, and ongoing maintenance.
• Follow data governance, security, and development standards.

Required Skills

• 4–7 years of experience in Informatica ETL and data integration.
• Hands‑on experience with Informatica IDMC (IICS).
• Strong knowledge of Cloud Data Integration (CDI).
• Experience in mappings, transformations, mapping tasks, and taskflows.
• Good knowledge of SQL, including complex queries, joins, and performance tuning.
• Experience working with relational databases such as Oracle, SQL Server, or similar platforms.
• Understanding of data warehousing concepts, ETL/ELT processes, and data modelling.
• Experience in debugging, performance optimization, and production support.
• Good analytical, problem‑solving, and communication skills.

Preferred Skills

• Experience with Informatica Cloud Data Quality (CDQ).
• Knowledge of REST APIs, web services, and file‑based integrations.
• Exposure to cloud platforms such as AWS, Azure, or Google Cloud.
• Experience with Git, CI/CD, deployment, and version control.
• Knowledge of Informatica Cloud Application Integration or metadata management is an advantage.