IDMC Developer & Lead

LTM

Hyderabad, Chennai, Bengaluru

Hybrid

INR 600,000 - 900,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

LTM is seeking a senior data integration specialist to define and implement Informatica IDMC architectures for client ingestion, transformation, and data quality. You will design reusable ingestion frameworks across Oracle, non-Oracle sources, and APIs, and migrate existing PowerCenter assets to IDMC while ensuring data quality and performance.

Key responsibilities include establishing deployment standards, configuring IDMC pipelines, and enabling batch, CDC, and near real-time data movement

Qualifications

  • Experience in migrating ETL processes to cloud-based data integration platforms.
  • Strong knowledge of Oracle/ETL, data pipelines, and data quality checks.
  • Familiarity with Informatica IDMC and Oracle databases is a plus.

Responsibilities

  • Define IDMC architecture for ingestion, transformation, data quality, orchestration, and metadata management.
  • Design reusable ingestion frameworks for Oracle, non-Oracle, file-based, API-based, and database sources.
  • Establish IDMC standards for mappings, tasks, taskflows, parameterization, and deployment structure.
  • Assess Informatica PowerCenter repositories and determine migration readiness to IDMC.
  • Analyze migration impacts and recommend remediation for IDMC compatibility.
  • Migrate and convert PowerCenter ETL processes, mappings, and schedules to IDMC.
  • Develop and configure IDMC Mapping Tasks, Taskflows, and Data Integration Pipelines and Secure Agent environments.
  • Re-engineer legacy ETL logic using IDMC capabilities and best practices.
  • Configure source/target connections from IDMC to Oracle, ADW, OCI Object Storage.
  • Perform source-to-target validation, reconciliation testing, and data quality checks.
  • Troubleshoot migration issues related to transformations, connectivity, performance, and workflow.
  • Establish integration architecture for batch, CDC, and near real-time movement using GoldenGate and IDMC.
  • Define ADW warehouse design patterns for analytical workloads and reporting performance.

Job description

Role & responsibilities

Define IDMC architecture for Client ingestion, transformation, data quality, orchestration and metadata management.
Design reusable ingestion frameworks for Oracle, non-Oracle, file-based, API-based and database sources.
Establish IDMC standards for mappings, mapping tasks, taskflows, parameterization and deployment structure.
Assess existing Informatica PowerCenter repositories, mappings, workflows, sessions, and reusable components to determine migration readiness to IDMC.
Analyze migration impacts, identify unsupported objects, and recommend remediation or redesign strategies for IDMC compatibility.
Migrate and convert PowerCenter ETL processes, mappings, workflows, parameter files, and schedules to Informatica IDMC.
Develop and configure IDMC Mapping Tasks, Taskflows, Data Integration Pipelines, and Secure Agent environments.
Re-engineer legacy ETL logic using cloud-native Informatica IDMC capabilities, reusable frameworks, and best practices.
Configure and manage source and target connections from IDMC to Oracle databases, ADW, OCI Object Storage, flat files, APIs,
Perform source-to-target validation, reconciliation testing, and data quality checks to ensure successful migration.
Troubleshoot Informatica to IDMC migration issues related to transformations, connectivity, performance, and workflow execution
Establish integration architecture for batch, CDC and near real-time data movement using oldenGate and IDMC.
Define ADW warehouse design patterns for analytical workloads, semantic consumption and reporting performance.

Build ingestion pipelines from source systems into OCI Object Storage and ADW.
Develop transformation workflows for Bronze, Silver and Gold layer processing.
Implement incremental load, full load, CDC-based load and historical data migration patterns.
Build data quality checks, validation rules, audit columns and reconciliation routines.
Develop SQL, IDMC and data engineering components for scalable data processing.
Troubleshoot data pipeline failures, performance issues and data mismatches.
Support operational monitoring, deployment and production support of ETL jobs.
Prior hands-on experience in Data Lake, Data Warehouse, ETL modernization or Analytics transformation projects.


Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

IDMC Developer
IDMC Developer

Infosys • Dadri, Ahmedabad District, Mumbai

Hybrid
INR 1,200,000 - 2,400,000
Senior Informatica IICS / IDMC Developer
Senior Informatica IICS / IDMC Developer

Tata Consultancy Services Limited • Hyderabad, Chennai, Bengaluru

On-site
INR 1,500,000 - 2,100,000
IDMC Developer
IDMC Developer

LTM • Maharashtra

On-site
INR 1,500,000 - 2,500,000
IDMC MDM developer
IDMC MDM developer

Zorba AI • Pune District

On-site
INR 700,000 - 1,000,000
IDMC MDM developer
IDMC MDM developer

Zorba AI • Bengaluru

On-site
INR 800,000 - 1,000,000
Tcs hiring For Senior Informatica IICS / IDMC Developer
Tcs hiring For Senior Informatica IICS / IDMC Developer

Tata Consultancy Services Limited • India

On-site
INR 1,800,000 - 2,800,000
Informatica IDMC
Informatica IDMC

LTM • Hyderabad, Chennai, Bengaluru

Hybrid
INR 900,000 - 1,300,000
IDMC MDM DEVELOPER
IDMC MDM DEVELOPER

Vrinda International • Hyderabad

On-site
INR 1,500,000 - 2,300,000
Associate Principal - Data Engineering
Associate Principal - Data Engineering

LTM • Kolkata District

On-site
INR 1,800,000 - 2,500,000
Informatica IDMC ( Kolkata )
Informatica IDMC ( Kolkata )

Price Waterhouse Cooper LLP • Kolkata District

Hybrid
INR 700,000 - 1,200,000