Informatica PowerCenter & IDMC (IICS) Developer - Migration Specialist (Princeton)

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

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.