IDMC Technical Lead PLEASANTON - CA - California

Please strictly adhere to the following resume naming convention:

Role Overview

We are looking for an IDMC Tech Lead to drive the technical analysis, design, build, validation, and testing activities for an Informatica CDI-PC to IDMC conversion initiative. The role requires strong hands-on experience across Informatica PowerCenter, CDI-PC, IICSIDMC, Oracle SQL, and Unix, with the ability to understand asset complexity, estimate effort, allocate work, guide team members, and improve conversion processes.

Required Skillset

Skill Area Required Capabilities Expected Depth

Informatica PowerCenter Mappings, sessions, workflows, mapplets, worklets, reusable transformations, parameter files, dependencies, and runtime behavior Advanced

Informatica CDI-PC CDI-PC workflow, mapping, session analysis, parameterization, conversion considerations, and behavioral comparison with IDMC Advanced

IICS IDMC Mapping tasks, taskflows, connections, runtime environments, schedules, assets corresponding to sessionsworkflowsmappings, validation, and deployment readiness Advanced

Oracle SQL Sourcetarget analysis, complex joins, data validation queries, reconciliation scripts, performance checks, and defect analysis Strong

Unix Commands File handling, shell navigation, logs, permissions, grepsedawk basics, job support, and parameterscript analysis Strong

Python Helpful for automation, validation utilities, metadata extraction, comparison reports, and repeatable migration accelerators Good to have

B2B EDI Awareness Familiarity with B2B services and healthcare EDI formats such as 835 and 837, including file structure awareness and integration considerations Preferred

Skill Area Required Capabilities Expected Depth

DVO Familiarity with Informatica Data Validation Option for automated data reconciliation and validation Preferred

Key Responsibilities

1. CDI-PC PowerCenter Asset Analysis

Analyze Informatica CDI-PC PowerCenter workflows, mappings, sessions, mapplets, worklets, parameter files, reusable components, and dependency structures.

Assess current-state conversion readiness, identify complexity drivers, and document technical assumptions, gaps, and risks.

Review runtime behaviors, parameterization patterns, file handling logic, sourcetarget connectivity, and transformation-level dependencies.

Analyze B2B service dependencies and EDI-related integration patterns, including awareness of 835837 file format handling where applicable.

2. IDMC IICS Design and Build

Design and create IDMC IICS assets corresponding to legacy sessions, mappings, workflows, and runtime configurations.

Create and validate mapping tasks, taskflows, connections, schedules, parameters, and other IDMC assets required for end-to-end migration.

Ensure IDMC implementation aligns with functional intent, source-to-target rules, transformation behavior, scheduling needs, and operational controls.

Drive configuration consistency, naming standards, reusable patterns, and environment migration practices across the conversion workstream.

3. Complex Transformation Handling

Provide deep technical analysis for complex Informatica transformations, including Java transformations, XML transformations, expressionrouterlookupaggregator patterns, and reusable transformation logic.

Understand and explain how transformations behave in IDMC compared with CDI-PC PowerCenter, including capability differences, conversion constraints, and required redesign patterns.

Identify transformation-specific risks, build IDMC-compatible alternatives, and guide developers on remediation approaches.

4. Validation, Testing, and DVO Usage

Own technical validation for converted assets, including unit testing, system integration testing support, data reconciliation, defect triage, and production-readiness checks.

Create or review Oracle SQL-based validation queries and compare sourcetarget results to confirm conversion accuracy.

Leverage familiarity with Informatica Data Validation Option (DVO) to support repeatable reconciliation and automated validation where applicable.

Review logs, runtime statistics, and failure patterns to troubleshoot issues across CDI-PC, IDMC, database, Unix, and file-handling layers.

5. Estimation, Planning, and Delivery Leadership

Estimate conversion and testing effort based on asset complexity, including number of transformations, workflow dependencies, parameterization, sourcetarget count, B2BEDI interactions, custom logic, and testing scope.

Break down technical work into actionable tasks and allocate work to team members based on skill, complexity, and delivery priorities.

Track progress, identify blockers early, coordinate with functional teams, and support delivery governance through status inputs and risk communication.

Suggest process improvements, reusable accelerators, automation opportunities, templates, and checklists to improve speed, quality, and consistency.

6. Knowledge Management and Team Enablement

Prepare and maintain knowledge documentation, technical design notes, conversion playbooks, validation evidence, defect learnings, and implementation standards.

Conduct walkthroughs with developers, QA, business analysts, and stakeholders to explain conversion approach, technical decisions, assumptions, and validation outcomes.

Mentor team members on CDI-PC to IDMC conversion patterns, transformation differences, IDMC taskflow design, troubleshooting, and documentation practices.

Technical Expectations by Workstream

Workstream Tech Lead Ownership Key Outputs

Discovery and Analysis Lead asset inventory review, complexity assessment, dependency mapping, parameter file review, and gap identification. Analysis notes, complexity ratings, effort estimates, migration assumptions, risk log

IDMC Build Guide and review creation of mappings, mapping tasks, taskflows, connections, parameters, and other migrated assets. IDMC assets, build checklist, peer review findings, configuration standards

Transformation Remediation Evaluate Java, XML, and complex transformation behavior and define IDMC-compatible design patterns. Remediation design, conversion rules, transformation decision log

Validation and Testing Define validation approach, review SQLDVO reconciliation, support test execution, and drive defect closure. Test evidence, reconciliation reports, defect RCA, sign-off inputs

Delivery Governance Estimate, plan, allocate tasks, monitor progress, escalate risks, and improve repeatable delivery process. Task plan, allocation tracker, status inputs, lessons learned, process improvements

Knowledge Documentation Document conversion patterns, standards, limitations, and operational knowledge for future support. KT documents, playbooks, runbooks, best-practice guides

Minimum Qualifications

8+ years of experience in Informatica delivery, with strong hands-on experience in PowerCenter andor CDI-PC.

Practical experience with IICS IDMC asset creation, validation, and troubleshooting.

Strong Oracle SQL skills for data analysis, reconciliation, and defect investigation.

Working knowledge of Unix commands for file processing, log review, and operational support.

Experience leading technical teams, assigning work, reviewing deliverables, and guiding remediation of complex issues.

Ability to understand existing ETL logic, compare behavior across platforms, and translate legacy designs into IDMC assets.

Preferred Qualifications

Experience in Informatica CDI-PC to IDMC IICS conversion or modernization programs.

Familiarity with B2B services and EDI files, especially healthcare-related 835837 formats.

Experience with Informatica Data Validation Option (DVO) or similar automated data validation tools.

Python scripting experience for automation, metadata parsing, comparison reporting, or validation utilities.

Role Descriptions: 5 years of Experience in Design, Develop, and maintain data integration workflows using Informatica IDMC (Cloud Data Integration (Azure), Cloud Application Integration, etc.).2. Build and optimize ETLELT pipelines that ingest, transform, and load data into Databricks Lakehouse.3. Proficiency in LinuxPython scripting4. Collaborate with data architects, analysts, and business stakeholders to understand data requirements and deliver robust solutions.5. Implement best practices for data governance, metadata management, and data quality using Informatica tools.6. Configure and manage connections between Informatica IDMC and Databricks, including secure authentication and data movement strategies.7. Monitor and troubleshoot data pipelines for performance, reliability, and scalability.8. Automate data workflows and orchestrate jobs using Informaticas scheduling and event-driven capabilities.9. Document technical specifications, data flow diagrams, and operational procedures.10. Experience with Peta byte scale data ingestion, data migration.11. Ability to adopt various type of data formats and data sizes.

Essential Skills: Informatica IDMC (IICS) Developer

Desirable Skills: Azure data factory, Databricks, Azure Synapse Analytics,Python, Sql ,Pyspark Databricks

Keyword: Azure data factory, Databricks, Azure Synapse Analytics,Python, Sql ,Pyspark Databricks

Skills: Informatica Powercentre

Experience Required: 10 & Above