Experience: 10+ Years
Role: Informatica IDMC / IICS Tech Lead
Essential Skills: Informatica IDMC (IICS), PowerCenter, CDI-PC, Oracle SQL, Unix
We are looking for an experienced Senior Informatica IDMC Tech Lead to lead the modernization and migration of existing Informatica PowerCenter/CDI-PC assets to Informatica Intelligent Data Management Cloud (IDMC/IICS). The role involves technical analysis, solution design, development, conversion, validation, and testing of ETL/ELT workflows, along with technical leadership, effort estimation, task allocation, and delivery governance.
The ideal candidate should have strong hands-on experience with Informatica PowerCenter, CDI-PC, IDMC/IICS, Oracle SQL, and Unix, along with expertise in cloud data integration and migration. Experience with Databricks, Azure Data Factory, Python, and large-scale data ingestion is highly desirable.
Analyze existing Informatica PowerCenter/CDI-PC mappings, sessions, workflows, mapplets, worklets, parameter files, and dependencies.
Design, develop, and maintain data integration workflows using Informatica IDMC/IICS.
Convert legacy ETL assets into IDMC-compatible mappings, mapping tasks, taskflows, connections, and schedules.
Identify conversion challenges, assess asset complexity, and recommend appropriate redesign or remediation approaches.
Ensure migrated workflows preserve existing business logic, transformation behavior, and source-to-target mappings.
Build, optimize, and maintain ETL/ELT pipelines for enterprise data integration and cloud data platforms.
Integrate Informatica IDMC with Databricks Lakehouse, Azure Data Factory, Azure Synapse Analytics, and other data platforms as required.
Develop scalable data ingestion and transformation solutions supporting diverse data formats and large data volumes, including petabyte-scale workloads.
Configure secure connections, authentication mechanisms, and data movement strategies between source and target systems.
Analyze and implement complex Informatica transformations, including expression, router, lookup, aggregator, Java, and XML transformations.
Evaluate transformation compatibility between PowerCenter/CDI-PC and IDMC/IICS.
Develop reusable design patterns and remediation approaches for unsupported or behaviorally different transformations.
Establish development standards, naming conventions, reusable components, and environment deployment practices.
Develop and execute Oracle SQL queries for source-to-target validation, data reconciliation, performance analysis, and defect investigation.
Validate converted workflows through unit testing, integration testing, regression testing, and production-readiness checks.
Troubleshoot pipeline failures, data discrepancies, runtime issues, and performance bottlenecks.
Use Informatica Data Validation Option (DVO) or similar automated validation tools where applicable.
Implement data quality, metadata management, governance, and monitoring best practices.
Develop and optimize cloud-based data integration solutions using Informatica IDMC/IICS.
Use Python and Unix/Linux shell scripting to automate data processing, validation, metadata extraction, and operational activities.
Implement workflow scheduling, task orchestration, and event-driven processing using Informatica capabilities.
Support CI/CD practices, deployment automation, monitoring, and operational reliability.
Apply secure data handling and access control practices across cloud data environments.
Lead technical analysis, solution design, development, testing, and migration activities.
Estimate effort based on asset complexity, dependencies, transformation logic, source/target systems, and testing requirements.
Break down deliverables into actionable tasks and allocate work based on team capabilities and priorities.
Review technical designs, code, mappings, test evidence, and conversion deliverables.
Track progress, resolve technical blockers, manage risks, and communicate delivery status to stakeholders.
Mentor developers and guide the team on Informatica best practices, troubleshooting, and migration patterns.
Prepare technical design documents, data flow diagrams, conversion playbooks, validation reports, and operational runbooks.
Collaborate with data architects, business analysts, QA teams, infrastructure teams, and business stakeholders.
Conduct technical walkthroughs, knowledge-transfer sessions, and peer reviews.
Identify opportunities for reusable accelerators, automation, and continuous improvement.
10+ years of experience in Informatica ETL development, data integration, or data engineering.
Strong hands-on experience with Informatica PowerCenter and/or CDI-PC.
Practical experience developing, configuring, validating, and troubleshooting Informatica IDMC/IICS assets.
Strong Oracle SQL skills, including complex joins, data validation, reconciliation, and performance troubleshooting.
Working knowledge of Unix/Linux commands, shell scripting, file handling, and log analysis.
Experience with ETL/ELT pipeline design, data integration, migration, and source-to-target mapping.
Experience leading technical teams, estimating effort, allocating tasks, reviewing deliverables, and resolving complex technical issues.
Strong analytical, problem-solving, communication, and documentation skills.
Experience with Informatica CDI-PC to IDMC/IICS migration or modernization initiatives.
Experience integrating Informatica IDMC with Databricks Lakehouse.
Knowledge of Azure Data Factory, Azure Synapse Analytics, and PySpark.
Python scripting experience for automation, validation, metadata extraction, and comparison reporting.
Familiarity with petabyte-scale data ingestion, cloud data migration, and diverse data formats.
Exposure to Informatica B2B services and healthcare EDI formats, particularly 835 and 837.
Familiarity with Informatica Data Validation Option (DVO) or equivalent reconciliation tools.
Experience with Agile delivery methodologies and sprint planning.
