Highlights
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. Complex Transformation HandlingProvide deep technical analysis for complex Informatica transformations| including Java transformations| XML transformations| expression/router/lookup/aggregator patterns| and reusable transformation logic.
Numbers & Facts
| Location | Aurora, IL |
| Industry | Computer/IT Services |
| Company Size | 500 to 999 employees |
| Year Founded | 1990 |
| Website | http://q1tech.com/ |
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_9999999_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 |
|---|
About Company
Q1 consists of experienced and recognized experts providing the capability to respond to market demand in order to provide professional services for our clients including Enterprise software implementations, application integration and technical / functional support.
Q1 has steadily grown into a Quality IT services and solutions organization with the average experience of our team being over 10 years. We have continuously met or exceeded client expectations by delivering professional services and project implementations on time and under budget to help clients truly recognize return on investment.
