Lead - Informatica IDMC Developer

Birlasoft; Pune District, Pimpri-Chinchwad; In loco; INR 1.400.000 - 2.300.000; Tempo pieno

Descrizione del lavoro

Birlasoft is seeking an Informatica IDMC Lead to join our cloud and data integration team. The role requires 6–8 years of experience and hands-on expertise with IDMC, CDI, ETL/ELT, and data quality/MDM processes across cloud and on-prem sources.

The position involves developing mappings, workflows, and API integrations, migrating legacy assets, and ensuring robust testing and delivery. Based in Bengaluru, Pune, Noida, Hyderabad, Chennai, Mumbai, with a daytime IST shift.

Competenze

• Hands-on experience with mappings, taskflows, parameter files, scheduling, monitoring, error handling, and Secure Agents.
• Strong 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; Kafka exposure is a plus.

Mansioni

• IDMC Development and Integration: build and maintain data integration pipelines in CDI, configure environments, and create reusable components.
• Data Quality and MDM Support: implement data quality rules, standardization, and MDM data loads and rules.
• Migration and Modernization: assess and migrate PowerCenter or IICS assets to IDMC and refactor artifacts.
• Testing, Support, and Delivery: develop unit tests, support SI/QA/UAT, and troubleshoot issues.
• Collaboration and Documentation: work with architects, analysts, DBAs, and QA; maintain design docs and runbooks.

Conoscenze

Informatica CDI

ETL/ELT concepts

REST APIs

Secure Agents

Integration design patterns

Kafka / event streaming

Strumenti

Oracle

SQL Server

PostgreSQL

Snowflake

Databricks

Azure

AWS

GCP

Descrizione del lavoro

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.

Job Title / Position: 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.