Informatica PowerCenter & IDMC (IICS) Developer - Migration Specialist

Job Description

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

Location: New Jersey – Princeton Local candidate - In-person interview

Duration: 6+ months

Role Descriptions:

• 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.
• 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| task flows| 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.
• 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.
• 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.
• 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.