Lead Informatica PowerCenter & IDMC (IICS) Developer c2c jobs

Tech Mirrors; Pleasanton (CA); On-site; USD 90,000 - 96,000; Full time

Job summary

Tech Mirrors seeks an experienced Informatica PowerCenter (PC) and IDMC (IICS) Developer to lead migration of enterprise ETL workflows from PC to IDMC. The role requires hands-on design, development, testing, and deployment of IDMC assets, with a strong focus on ensuring data integrity and performance across environments.

The ideal candidate has deep ETL expertise in both PowerCenter and IDMC, strong Oracle SQL and Unix skills, and proven ability to guide teams through complex migration

Qualifications

• Must have migration experience from PowerCenter to IDMC
• Strong ETL development background in both PC and IDMC
• Ability to lead a team through migration challenges and risk mitigation

Responsibilities

• Analyze existing PowerCenter mappings, workflows, and assets for migration to IDMC
• Design, develop, test, and deploy IDMC assets required for end-to-end migration
• Perform end-to-end migration activities including validation, performance optimization, and environment comparisons

Skills

PowerCenter

IDMC/IDICS

ETL development

Oracle SQL

Unix

Team leadership

Tools

Informatica PowerCenter

IDMC/CDI-PC

Oracle SQL

Job description

Informatica PowerCenter & IDMC (IICS) Developer – Migration Specialist

Job Location: PLEASANTON, CA Onsite (5days/week)
Job Type: Contract
Pay Range: $65 –$70 /hour

Role Descriptions:

Must have skills :
Associate must have hands on in migrating informatica of workflows to IDMC
Associate must have strong understanding of ETL ,sql and Unix
Associate should be able to lead a team who is working on the migration of informatica pc workflows to IDMC format
Associate must be able to identify possible issues/ in compatibilities and provide solutions in this migration process

Job Title: Informatica PowerCenter & IDMC (IICS) Developer – Migration Specialist

Role Summary:

We are seeking an experienced Informatica PowerCenter (PC) and Informatica Intelligent Data Management Cloud (IDMC/IICS) Developer to support the migration of enterprise data integration solutions from Informatica PowerCenter to IDMC. The ideal candidate will have strong ETL development experience, hands-on expertise in both PowerCenter and IDMC services, and a proven track record of assessing, migrating, and optimizing ETL workloads in cloud environments.

Key Responsibilities:

• Analyze existing Informatica PowerCenter mappings, workflows, sessions, and reusable objects for migration to IDMC.
• Design, develop, test, and deploy ETL/ELT solutions using Informatica Cloud Data Integration (CDI) and other IDMC services.

Perform end-to-end migration activities from PowerCenter to IDMC, including:

• Mapping and workflow assessment
• Conversion and redevelopment of ETL logic
• Parameter and configuration migration
• Validation and reconciliation
• Performance optimization
• Review and compare DEV, QA, and PROD environments to identify configuration, parameter, and code differences.
• Validate production configurations and dependencies to ensure accurate migration.
• Migrate and optimize complex transformations, workflows, task flows, and reusable components.
• Work with source and target systems including Oracle, SQL Server and flat-file integrations.
• Troubleshoot migration issues and resolve data quality, performance, and connectivity challenges.
• Create migration documentation, technical specifications, and deployment procedures.
• Collaborate with architects, business analysts, and support teams throughout the migration lifecycle.
• Perform unit testing, system integration testing, and production validation.

Role Descriptions:

1. 1. CDI-PC / PowerCenter Asset AnalysisAnalyze 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. 2. IDMC / IICS Design and BuildDesign 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. 3. Complex Transformation HandlingProvide 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. 4. Validation| Testing| and DVO UsageOwn 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. 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|

Essential Skills:

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.

Keyword:

~Azure data factory| Databricks| Azure Synapse Analytics|Python| Sql |Pyspark Databricks~

Skills:

Informatica Powercentre

Experience Required:

10 & Above