Lead Informatica Developer

Job Title: Senior Informatica Developer (Lead)

Experience: 8+ years

Work Mode: Remote

Shift: 11:00 AM – 8:00 PM IST

Budget: 1.3 LPM

🔎 Role Overview

We are seeking a seasoned Sr. Informatica Developer (Lead) with strong hands-on experience in Informatica PowerExchange CDC, PowerCenter, and IDMC (CMI-DB & CDI). This role is key in supporting the migration initiative from PowerExchange CDC to Informatica Intelligent Data Management Cloud (IDMC), ensuring secure, seamless, and high-performance data ingestion pipelines.

The ideal candidate should possess strong ETL migration experience, deep Oracle CDC knowledge, and the ability to lead technical delivery in collaboration with cross-functional data, QA, and infrastructure teams.

🛠 Key Responsibilities

1. Analysis & Migration

• Analyze PowerExchange CDC configurations against Oracle sources.
• Understand redo/archive logs and translate into equivalent IDMC CMI-DB configurations.
• Collaborate with architects to design end-to-end CDC workflows.
• Identify data flow dependencies and migration impacts.

2. Development & Implementation

• Develop incremental ingestion & CDC pipelines in IDMC CMI-DB.
• Build transformation pipelines via IDMC CDI mappings & tasks.
• Configure runtime environments, agents, and secure connectivity.
• Perform end-to-end validation, tuning, and troubleshooting.
• Support testing and cutover during migration from PowerExchange to IDMC.

3. Administration & Collaboration

• Partner with Informatica Admin & DBA teams for connectivity enablement.
• Ensure operational continuity and error handling post-migration.
• Work with QA, Data Engineering & Business teams for data validation.

4. Documentation & Knowledge Sharing

• Document pipelines, configurations & migration playbooks.
• Publish reference guides for CDC setup, performance tuning, and troubleshooting.
• Participate in internal knowledge-transfer workshops.

✔ Required Skills & Experience

• 10+ years of ETL development using Informatica PowerExchange, PowerCenter, and IDMC
• Strong experience with:
• ✓ PowerExchange CDC for Oracle
• ✓ Oracle redo/archive log extraction & interpretation
• ✓ IDMC (CMI-DB & CDI) pipeline creation
• Strong SQL & PL/SQL experience
• Experience with Oracle & MS SQL Server source/targets
• Familiarity with Parquet, CSV, JSON formats in ingestion pipelines
• Understanding of replication, CDC, real-time ingestion & error handling
• Strong analytical & problem-solving capability

⭐ Preferred Qualifications

• Informatica IDMC or PowerCenter certifications
• Exposure to AWS / Azure / GCP for cloud deployments
• Experience with Informatica Data Quality (IDQ) or Data Governance
• Hands-on experience in ETL modernization/migration initiatives

🎯 Mandatory Skills (8)

Here are the top 8 mandatory skills extracted from the JD:

• Informatica PowerExchange CDC (Oracle)
• Informatica PowerCenter
• Informatica IDMC (CMI-DB & CDI)
• Oracle Redo/Archive Log Processing & Interpretation
• Strong SQL & PL/SQL Development
• ETL Migration & CDC Pipeline Implementation
• Oracle & MS SQL Server as Source/Target Systems
• Data Pipeline Troubleshooting, Performance Tuning & Real-time Ingestion