| Location | Pleasanton, CA |
| Salary | $49.24–$51.51 Per Hour |
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
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.
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.
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.
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.
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.
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.
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.
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
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.