Loading, Please wait..!!
Sr Idmc Technical Consultant
-
Posted on: Oct 26, 2026
-
Pleasanton, California
-
Onsite
-
CTC
Curious about compensation?
Explore the historical salary trends, average pay, and estimated compensation for Sr Idmc Technical Consultant roles in California.
View Salary Guide →Find your match !
Job Title :
Sr Idmc Technical Consultant
Job Type :
Contract
Job Location :
Pleasanton California United States
Remote :
No
Job Description :
Position: Sr. IDMC Technical Consultant || Onsite in PLEASANTON, CA (Relocation yes)
Location: Onsite in PLEASANTON, CA (Relocation yes)
Duration : 6 Month
Note: Linkedin is a must
Job Description:-
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, IICS/IDMC, 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 sessions/workflows/mappings, validation, and deployment readiness Advanced
- Oracle SQL Source/target analysis, complex joins, data validation queries, reconciliation scripts, performance checks, and defect analysis Strong
- Unix Commands File handling, shell navigation, logs, permissions, grep/sed/awk basics, job support, and parameter/script 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, source/target connectivity, and transformation-level dependencies.
Analyze B2B service dependencies and EDI-related integration patterns, including awareness of 835/837 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, expression/router/lookup/aggregator 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 source/target 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, source/target count, B2B/EDI 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.
Position Details
Posted:
Oct 26, 2026
Reference Number:
3189-35330
Employment:
CTC
City:
Pleasanton
Job Origin:
CIEPAL_ORGANIC_FEED
Share this job:
Please wait..!!

