Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

IDMC Tech Lead

Q1 Technologies, Inc

Job Description

Job Description

IDMC Tech Lead
PLEASANTON, CA

Location: PLEASANTON, CA
Duration: 6 months

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, 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.

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 SQL/DVO 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 and/or 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 835/837 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 ETL/ELT pipelines that ingest| transform| and load data into Databricks Lakehouse.3. Proficiency in Linux/Python 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

Vacancy posted 19 days ago
Similar jobs that could be interesting for youBased on the IDMC Tech Lead in Aurora, CO vacancy
  • Job Description Job Description Job Title: Developer Platform/Product Location: WFH USA Colorado Denver Years of Experience: 7 10 Years Job Summary: We are seeking a highly skilled Developer Platform/Product with a strong emphasis on Java 11 to join our...
    Suggested
    Remote work
    Work from home

    Yantran LLC

    Aurora, CO
    21 days ago
  • $24.11 - $36.17 per hour

     ...Sterile Processing Lead Location: UCHealth Anschutz Inpatient Pavilion, Aurora, CO. Department: Sterile Processing AIP Work Schedule: Full Time, 80.00 hours per pay period (2 weeks) Shift: Days Pay: $24.11 - $36.17 / hour. Pay is dependent on applicant's... 
    Suggested
    Full time
    Local area
    Remote work
    Flexible hours
    Shift work

    UCHealth

    Aurora, CO
    4 days ago
  •  ...architectures and best practices, contributing to the successful execution of complex development projects. Key Responsibilities 1. Lead solution development using GenAI, LLMs, and prompt engineering to architect and implement scalable AI applications, ensuring... 
    Suggested

    HCL Technologies

    Aurora, CO
    3 days ago
  •  ...by conducting comprehensive code reviews and enforcing best practices in Python, RESTful API development, and prompt engineering. 5. Lead technical feasibility studies and solution breakdowns, evaluating architecture alternatives and technical risks for GenAI project... 
    Suggested

    HCL Technologies

    Aurora, CO
    4 days ago
  • $24.88 - $38.56 per hour

     ...Sterile Equipment Tech LeadInspired by faith. Driven by innovation. Powered by humankindness. CommonSpirit Health is building a healthier...  ....Job Summary and ResponsibilitiesAs our Sterile Equipment Tech Lead, you will perform routine tasks relating to the decontamination,... 
    Suggested
    Full time
    Immediate start

    CommonSpirit Health

    Denver, CO
    2 days ago
  •  ...methodologies. Familiarity with cloud services (e.g., AWS, Azure) and CI/CD pipelines. Experience in mentoring junior developers and leading small teams. Qualifications: Bachelor's degree in Computer Science, Information Technology, or a related field. 7 10 years... 
    Remote work
    Work from home

    Yantran LLC

    Denver, CO
    21 days ago
  • How It Works This is not an active job listing. By submitting your interest, you’ll be among the first to know when internship opportunities open at Danaher. While the roles described here reflect the types of positions we typically recruit for, we want to be transparent...
    Remote job
    Internship

    Danaher

    Aurora, CO
    4 days ago
  • Southwest Airlines Co. is seeking a Tech Lead Software Engineer in Denver for driving a team of designers and collaborating with business partners to deliver robust software solutions. The role blends architecture, leadership, and hands-on development in a remote-friendly... 
    Remote job

    Southwest Airlines Co.

    Denver, CO
    5 days ago
  • Job Description Job Description Job Title : Sr Data Engnieer Location : Denver , CO (Onsite) Year of EXP 8 + Years Description Design and build ETL processes, data ingestion, and streaming application using AWS services, SQL, Python, Snowflake, and AWS Redshift...

    Yantran LLC

    Denver, CO
    21 days ago
  • Job Description Job Description Senior Data Analyst Role: Senior Data Analytics (Onsite) Location : Denver , CO Develop Data Solutions: Analyze, Design and build applications and data pipelines using AWS, Databricks, Redshift, and Snowflake. ETL/ELT...

    Yantran LLC

    Denver, CO
    21 days ago
  • $103.71k - $138.28k

     ...drives corrective actions, and ensures the accuracy of project documentation. The Main Responsibilities Key Responsibilities Lead logistics projects from planning through delivery, acceptance, and closeout. Develop and manage project scope, schedules,... 
    Full time
    Temporary work
    For contractors

    Lumen

    Aurora, CO
    1 day ago
  •  ...Job Summary and Responsibilities As our Radiology Tech Lead you will oversee daily workflow develop schedules and act as a subject matter expert for your unit developing and leading staff to be personally accountable for the organizational mission and success.... 
    Full time
    Work from home
    Weekend work

    Working at CommonSpirit Health

    Lakewood, CO
    17 days ago
  • $25 - $40 per hour

     ...If you take pride in performing critical services that keep clients safe and their properties secure, this full-time Security Tech Team Lead position with Fire Team Security could be a great fit for you! We're looking for an enthusiastic and detail-oriented problem... 
    Full time
    Monday to Friday
    Weekend work

    Fire Team Security

    Denver, CO
    17 days ago
  • $128.19k - $184.01k

     ...building Poe, an innovative platform that brings together the world’s leading AI models in one place. You will work at the cutting edge of...  ..., including marginalized or underrepresented groups in tech, to apply for our job openings. We encourage all candidates who... 
    Remote job
    Full time

    Quora

    Aurora, CO
    1 day ago
  • $22.04 - $33.04 per hour

     ...unique and intrinsic worth of each individual is recognized. Submit your application for the opportunity below: Sterile Processing Tech Lead Job Summary and Qualifications As a Certified Lead Sterile Processing Technician , you will be an invaluable safety... 
    Hourly pay
    Temporary work
    Local area
    Flexible hours

    HCA Mission Hospital - Memorial Campus

    Englewood, CO
    4 days ago
  •  ...SKIPJOHNSON0413 MSP Owner: William Bristol Location: See Below Duration: 6 months Salesforce Developer / Salesforce Technical Lead – JD (Point-wise) Experience: · 10 years of overall IT/software development experience. · 8 years of hands-on Salesforce... 

    Q1 Technologies, Inc

    Aurora, CO
    19 days ago
  • $86.9k - $198k

     ...Sensing Software Engineer, you will architect advanced SDA and remote sensing exploitation pipelines, guide technical direction, and lead multi-disciplinary teams building high-fidelity space observation analytics. You will shape next-generation tools that integrate... 
    Full time
    Contract work
    Part time
    Local area
    Remote work

    Booz Allen Hamilton

    Aurora, CO
    3 days ago
  •  ...Job Description Job Description Position : SAP Basis Consultant / Technical Lead - SAP S/4HANA Location : Remote Duration : Fulltime Job Description: Must Have Technical/Functional Skills: • SAP S/4HANA system administration, landscape design, installation... 
    Permanent employment
    Full time
    Remote work

    Q1 Technologies, Inc

    Aurora, CO
    5 days ago
  • $69.4k - $158k

    Job Number: R0249027 Software Engineer The Opportunity: Booz Allen is looking for a Sof t war e Engineer who is driven by purpose and ready to build sof t war e that directly supports mission-critical operations across the space domain. In this role, you'll design...
    Full time
    Contract work
    Part time
    Work at office
    Local area
    Remote work

    Booz Allen Hamilton

    Aurora, CO
    1 hour ago
  • $69.1k - $141.5k

    Job Title: Software Engineer Job Category: Engineering Time Type: Full time Minimum Clearance Required to Start: None Employee Type: Regular Percentage of Travel Required: Up to 10% Type of Travel: Continental US Anticipated Posting End: 1/1/2099 The...
    Full time
    Contract work
    Work experience placement
    Flexible hours

    CACI International, Inc.

    Aurora, CO
    3 days ago
  • $86.8k - $165.2k

     ...great minds are united by purpose and inspired to make a difference solving the world's most complex problems. With our three market leading businesses, world-class operations and investments in research and development, we offer capabilities and opportunity no one else... 
    Temporary work
    Work experience placement
    Work at office
    Remote work
    Relocation package
    Flexible hours

    Raytheon

    Aurora, CO
    2 days ago
  • $37k - $82k

     ...op session. Candidate must be currently enrolled at Virginia Tech pursing a Bachelor’s or Master's degree in Computer Science....  ...and government customers worldwide. It comprises three industry-leading businesses – Collins Aerospace, Pratt & Whitney, and Raytheon. Its... 
    Full time
    Temporary work
    Summer work
    Internship
    Worldwide
    Relocation
    Relocation package
    Flexible hours

    RTX

    Aurora, CO
    4 days ago
  • $125k - $155k

     ...on improving the overall work/life experience they have supporting the mission. Our Team is pushed every day to use their industry leading knowledge to provide end-to-end solutions to combat our nation's toughest and most secure problems. If you are looking for a place... 

    Cornerstone Defense

    Aurora, CO
    1 day ago
  • Company DescriptionAbout Client:They help in transforming the leading organizations and communities around the world. Organizations infrastructure and culture is amazing. Best place!!Job DescriptionJob Description:As a Peoplesoft expertise, you will be involved in developing... 

    Roljobs Technology Services

    Denver, CO
    2 days ago
  • Job Summary The Senior Technical Lead - Embedded Firmware Design plays a pivotal role in managing technology for complex projects within the organization. This position is responsible for providing strategic technical direction, enhancing team capabilities, and ensuring... 

    HCL Technologies

    Aurora, CO
    3 days ago
  • $80.51k - $107.34k

    Lumen is the trusted network for the AI‑powered world, connecting people, data, and applications through our expansive fiber network and connected ecosystem. We enable secure, high‑performance connectivity across cloud, edge, and AI workloads for enterprises, governments...
    Full time

    Lumen

    Aurora, CO
    2 days ago
  • $75 per hour

    Job DescriptionJob Description Job Description:ALL CAPS, NO SPACES B/T UNDERSCORES PTN_US_GBAMSREQID_ Candidate BeelineID i.e. PTN_US_9999999_SKIPJOHNSON0413 MSP Owner: Thomas Hodges Targeted Bill Rate- $75hr REQUIREMENT_CITY -Malvern, PA REQUIREMENT_ID-10974729 Role Name...

    Q1 Technologies

    Aurora, CO
    3 days ago
  • DevOps EngineerWe are looking for a motivated and innovative DevOps Engineer to join our team and help bridge the gap between development and operations. In this role, you will design, implement, and manage automated workflows and pipelines to enhance software delivery...
    Temporary work
    For contractors
    Immediate start

    Cymertek

    Aurora, CO
    5 days ago
  • $100k - $160k

    Job Description Job Description   What Impact You'll Have We are seeking an enthusiastic Junior Software Engineer with 2+ years of experience to join our multi-team agile engineering program. In this role, you will work alongside senior engineers to develop, ...
    Contract work
    Immediate start

    GRVTY

    Aurora, CO
    8 days ago
  • $77.6k - $176k

    DevOps Engineer, Senior The Opportunity: Everyone is trying to “harness the cloud”, but not everyone knows how. As a DevOps engineer, you’re eager to develop, manage, and secure a container platform that meets your client’s needs and takes advantage of cloud capabilities...
    Full time
    Contract work
    Part time
    Local area
    Remote work

    Booz Allen Hamilton

    Aurora, CO
    2 days ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to IDMC Tech Lead. Be the first to apply!