Informatica IDMC Tech Lead

• Job Title: Informatica IDMC Tech Lead
• Requisition ID: 11021966
• MSP Owner: William Bristol
• Location: Pleasanton, CA
• Work Assignment: Onsite
• Duration: 6 months
• Experience Required: 10+ years
• Minimum Relevant Experience: 8+ years in Informatica delivery
• Essential Skills: Informatica IDMC (IICS), Informatica PowerCenter, CDI-PC
• Desirable Skills: Azure Data Factory, Databricks, Azure Synapse Analytics, Python, SQL, PySpark
• Skill Category: Informatica PowerCenter
• Parent: IS-LSHC-2-Healthcare-Parent
• Child: IS-LSHC-Healthcare 2.4
• Business Vertical: CL-LSHC
• Work Location CDF: Pleasanton, CA
• Type of Asset: None
• Assets: None

Role Overview

• Lead technical analysis, design, development, conversion, validation, and testing for Informatica CDI-PC/PowerCenter to IDMC/IICS migration.
• Analyze legacy ETL assets, assess complexity, estimate effort, allocate tasks, and guide technical teams.
• Improve migration processes through automation, reusable components, and standardized practices.

Must-Have Technical Skills

• Informatica PowerCenter
• Mappings, sessions, workflows, mapplets, worklets, and reusable transformations.
• Parameter files, dependencies, and runtime behavior.
• Informatica CDI-PC
• Workflow and mapping analysis.
• Session analysis, parameterization, and conversion considerations.
• Behavioral comparison between CDI-PC and IDMC.
• Informatica IDMC / IICS
• Mapping tasks, taskflows, connections, and runtime environments.
• Schedules, parameters, validation, and deployment readiness.
• Asset creation, migration, troubleshooting, and optimization.
• Oracle SQL
• Complex joins, source-to-target analysis, and reconciliation queries.
• Data validation, performance checks, and defect investigation.
• Unix/Linux
• File handling, shell navigation, log analysis, and permissions.
• Commands such as grep, sed, and awk.
• Job support and parameter/script analysis.
• Python
• Automation scripts, metadata extraction, validation utilities, and comparison reports.
• B2B/EDI
• B2B service dependencies and healthcare EDI formats, especially 835 and 837.
• Data Validation
• Informatica Data Validation Option (DVO) or similar reconciliation tools.

Roles and Responsibilities

• Analyze Informatica CDI-PC/PowerCenter workflows, mappings, sessions, mapplets, worklets, parameter files, and dependencies.
• Assess conversion readiness, identify complexity drivers, and document technical assumptions, gaps, and risks.
• Review runtime behavior, parameterization, file handling, source/target connectivity, and transformation dependencies.
• Design and develop IDMC/IICS assets corresponding to legacy mappings, sessions, workflows, and runtime configurations.
• Create and validate mapping tasks, taskflows, connections, schedules, parameters, and deployment configurations.
• Maintain consistency in naming standards, reusable patterns, and environment migration practices.
• Analyze complex Java, XML, Expression, Router, Lookup, and Aggregator transformations.
• Identify platform differences, conversion constraints, and required redesign patterns.
• Develop IDMC-compatible alternatives and guide developers through remediation.
• Lead technical validation, unit testing, system integration testing, data reconciliation, and defect triage.
• Create and review Oracle SQL validation queries to compare source and target results.
• Use DVO or similar tools to support automated data validation and reconciliation.
• Troubleshoot failures across CDI-PC, IDMC, databases, Unix, and file-processing layers.
• Estimate conversion and testing effort based on asset complexity, dependencies, custom logic, and testing scope.
• Break down technical work, allocate tasks, track progress, and resolve delivery blockers.
• Coordinate with functional teams and support status reporting, risk communication, and delivery governance.
• Identify process improvements, automation opportunities, reusable accelerators, templates, and checklists.
• Prepare technical design notes, conversion playbooks, validation evidence, runbooks, and implementation standards.
• Conduct technical walkthroughs and mentor team members on conversion patterns, taskflow design, troubleshooting, and documentation.

Data Engineering and Cloud Responsibilities

• Design, develop, and maintain data integration workflows using Informatica IDMC.
• Build and optimize ETL/ELT pipelines for data ingestion, transformation, and loading into Databricks Lakehouse.
• Configure secure connections and data movement between Informatica IDMC and Databricks.
• Apply best practices for data governance, metadata management, and data quality.
• Monitor and troubleshoot pipelines for performance, reliability, and scalability.
• Automate data workflows using Informatica scheduling and event-driven capabilities.
• Document technical specifications, data flow diagrams, and operational procedures.
• Support petabyte-scale data ingestion and migration across different data formats and volumes.
• Collaborate with data architects, analysts, developers, and business stakeholders.

Technical Leadership and Delivery Outputs

• Discovery and Analysis: Asset inventory, complexity ratings, dependency mapping, effort estimates, assumptions, and risk logs.
• IDMC Build: Mappings, mapping tasks, taskflows, connections, parameters, build checklists, and configuration standards.
• Transformation Remediation: Remediation designs, conversion rules, and transformation decision logs.
• Validation and Testing: Test evidence, reconciliation reports, root-cause analysis, defect closure, and sign-off inputs.
• Delivery Governance: Task plans, allocation trackers, status reports, lessons learned, and process improvements.
• Knowledge Documentation: Knowledge-transfer documents, conversion playbooks, runbooks, and best-practice guides.

Minimum Qualifications

• 8+ years of Informatica delivery experience with strong hands-on PowerCenter and/or CDI-PC expertise.
• Practical experience creating, validating, and troubleshooting IICS/IDMC assets.
• Strong Oracle SQL skills for data analysis, reconciliation, and defect investigation.
• Working knowledge of Unix/Linux commands and shell scripting.
• Experience leading technical teams, assigning work, reviewing deliverables, and resolving complex technical issues.
• Ability to analyze legacy ETL logic and translate it into IDMC assets.
• 10+ years of overall relevant experience preferred/required as specified in the requisition.

Preferred Qualifications

• Informatica CDI-PC to IDMC/IICS migration or modernization experience.
• B2B services and healthcare EDI experience, particularly 835/837 formats.
• Informatica DVO or other automated data validation tools.
• Python scripting for automation and validation.
• Azure Data Factory, Databricks, Azure Synapse Analytics, SQL, and PySpark.
• Large-scale data ingestion, cloud data integration, and data migration experience.

Key Resume Search Keywords

• Informatica IDMC Tech Lead
• Informatica IDMC Developer
• IICS Developer
• Informatica PowerCenter
• CDI-PC to IDMC Migration
• Informatica Cloud Data Integration
• ETL/ELT Pipelines
• Mapping Tasks and Taskflows
• Oracle SQL / PL/SQL
• Unix / Linux
• Python Scripting
• Informatica DVO
• Data Validation and Reconciliation
• Azure Data Factory
• Databricks
• Azure Synapse Analytics
• PySpark
• B2B / Healthcare EDI
• Data Governance
• Metadata Management
• Petabyte-Scale Data Migration
• Technical Leadership

Resume Submission Naming Convention

• Use ALL CAPS.
• Do not include spaces.
• Follow this format: PTN_US_GBAMSREQID_CANDIDATEBEELINEID
• Example: PTN_US_9999999_SKIPJOHNSON0413
• Use requisition ID 11021966 when constructing the filename, following the required naming format.