Informatica PowerCenter & IDMC (IICS) Developer - Migration Specialist

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.