Lead - Informatica IDMC Developer

Birlasoft; Pune District; On-site; INR 1,800,000 - 2,800,000; Full time

Job summary

Birlasoft is seeking an Informatica IDMC Lead responsible for designing and delivering IDMC based data integration solutions across cloud and on‑prem sources. You will develop mappings, pipelines, and REST/SOAP API integrations, while ensuring data quality and MDM support.

You will collaborate with architects, analysts, DBAs, and QA teams to translate requirements into robust implementations and reusable components, contributing to migration efforts and performance improvements.

Qualifications

• 6–8 years of experience in Informatica IDMC and data integration.
• Strong ETL/ELT design skills and data warehousing understanding.
• Experience with REST/SOAP APIs, JSON, XML, CSV formats.

Responsibilities

• IDMC development: mappings, taskflows, pipelines and schedules.
• Data quality rules, CDQ, and MDM support for 360 views.
• Migrate PowerCenter/IICS assets to IDMC; build scalable solutions.
• Test, support, and deliver integration projects; document designs.

Skills

Informatica IDMC

ETL/ELT design

Cloud data integration

REST/SOAP APIs

SQL and databases

Data quality and MDM

Tools

Informatica Cloud Data Integration (CDI)

Secure Agent

IICS/IDMC

Job description

Area(s) of responsibility

Empowered By Innovation

Birlasoft, a global leader at the forefront of Cloud, AI, and Digital technologies, seamlessly blends domain expertise with enterprise solutions. The company’s consultative and design-thinking approach empowers societies worldwide, enhancing the efficiency and productivity of businesses. As part of the multibillion-dollar diversified CKA Birla Group, Birlasoft with its 12,000+ professionals, is committed to continuing the Group’s 170-year heritage of building sustainable communities.

Informatica IDMC Lead

Experience: 6-8 years

Location: Bengaluru / Pune / Noida / Hyderabad / Chennai / Mumbai

Shift: 12:00 PM to 9:00 PM IST

Key Responsibilities

IDMC Development and Integration

• Develop, configure, and maintain data integration mappings, mapping tasks, taskflows, and schedules using Informatica Cloud Data Integration (CDI).
• Build ETL and ELT pipelines to ingest, transform, and load data across cloud and on-premises sources and targets.
• Configure and support Secure Agents, runtime environments, connections, parameterization, and deployment activities under architectural guidance.
• Develop reusable objects, templates, error-handling routines, logging, and restart mechanisms to improve solution maintainability.
• Create and consume REST and SOAP APIs, and support file-based, database, application, and event-driven integration patterns.

Data Quality and MDM Support

• Develop data quality rules, profiles, scorecards, standardization, cleansing, and validation logic using Cloud Data Quality (CDQ).
• Implement data matching, duplicate identification, reference data checks, and exception-handling workflows.
• Support MDM SaaS implementations such as Customer 360, Supplier 360, or Product 360 by configuring data loads, business rules, and integrations.

Migration and Modernization

• Assist in assessing and migrating Informatica PowerCenter or IICS assets to IDMC.
• Rebuild or refactor mappings, workflows, data quality assets, and interfaces based on approved migration designs.

Testing, Support, and Delivery

• Prepare unit test cases and test evidence; support system integration testing, user acceptance testing, regression testing, and performance testing.
• Troubleshoot mapping failures, connectivity issues, data quality defects, and performance bottlenecks.

Collaboration and Documentation

• Work with solution architects, business analysts, source-system teams, database administrators, and QA teams to translate requirements into technical deliverables.
• Create and maintain technical design documents, mapping specifications, runbooks, deployment checklists, and support documentation.
• Participate in design reviews and recommend practical improvements to performance, reliability, and maintainability.

Required Skills

Informatica and Integration

• Hands-on experience with mappings, taskflows, parameter files, scheduling, monitoring, error handling, and Secure Agents.
• Good understanding of ETL/ELT concepts, data warehousing, dimensional modeling, and integration design patterns.
• Experience with REST APIs, SOAP, JSON, XML, CSV, and secure file-transfer mechanisms. Exposure to Kafka or event streaming is a plus.

Databases, Cloud, and Engineering Tools

• Strong SQL skills and experience with at least two platforms such as Oracle, SQL Server, PostgreSQL, Snowflake, or Databricks.
• Exposure to one or more cloud platforms: Microsoft Azure, Amazon Web Services, or Google Cloud Platform.