Job Description Job Description Job Description Job Description:

Please strictly adhere to the following resume naming convention:

ALL CAPS, NO SPACES B/T UNDERSCORES PTN

_US_GBAMSREQID_CandidateBeelineID i.e. PTN_US

SKIPJOHNSON0413 MSP

Owner:

William Bristol Location:

See Below Duration:

6 months 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:

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.

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. 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. 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. Estimation Planning and Delivery LeadershipEstimate 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.

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 Salary Not Specified Location Aurora Illinois United States Job Overview Job Posted:

4 days ago

Job Expires:

4w 2d Job Type Full Time Education Any Experience N/A Vacancies 1 Job Title Architect Job Function Design & Engineering Copy Link