Position: Informatica PowerCenter IDMC Migration Lead
Location: Cincinnati, OH (Onsite)
Duration: Long Term
Job description:
Experience
12-18 years in Informatica ETL delivery with strong client-facing leadership experience
Role Summary
The Onshore Lead will be responsible for technical and delivery leadership of the PowerCenter Rationalization and Assessment program from an onshore position. The role acts as the primary client-facing technical authority responsible for driving solution clarity, guiding offshore teams, managing risks and ensuring high-confidence rationalisation outputs that support future modernization or IDMC migration.
This role bridges client stakeholders, project management and offshore delivery teams with a strong focus on governance validation and decision support.
Key Responsibilities
- Technical Functional Leadership
- Provide overall technical leadership for PowerCenter rationalization and assessment activities
- Guide teams on
- Inventory analysis of PowerCenter mappings, workflows, sessions, and jobs
- Rationalization and depreciation approach
- Complexity classification and modernization readiness assessment
- Review and validate key deliverables, including
- Rationalized inventory
- Deprecation candidate lists
- Environment reconciliation results
- Testing and validation summaries
- Client Stakeholder Management - Act as the primary onshore interface for client technical and business stakeholders
o Lead client discussions on Rationalization findings, Risk areas and assumptions
o Deprecation recommendations and approvals
- Coordinate with client SMEs for
- Functional clarifications
- Batch cycle understanding
- Dependency confirmations
- Support executive-level walkthroughs and readouts
- Offshore Coordination Delivery Oversight
- Provide direction and clarity to offshore ETL engineers, data analysts and testers
- Review offshore outputs for
- Accuracy
- Consistency
- Adherence to the agreed methodology
- Ensure common understanding of standards, templates, and validation criteria
- Resolve technical and functional ambiguities raised by offshore teams
- Risk Quality Governance
- Identify and manage technical and execution risks, especially related to
- Production stability
- Incorrect deprecation decisions
- Environment inconsistencies
- Enforce zero disruption principles for production systems
- Ensure that all recommendations are evidence-based and defensible
- Align with the Project Manager on RAID dependencies and decision tracking
- Planning Estimation Support
- Provide inputs to the complexity scoring, Migration effort estimation and Modernization roadmap planning
- Ensure that rationalization outputs are usable for downstream
- IDMC migration planning
- Conversion feasibility assessment
Required Skills Expertise
Technical Expertise
- Deep hands-on experience with Informatica PowerCenter
- Strong knowledge of ETL design patterns
- Batch scheduling and dependencies
- SQL-intensive transformations and overrides
- Solid understanding of data warehouse environments and large-scale ETL ecosystems
- Leadership Communication
- Strong client-facing communication and facilitation skills
- Ability to explain complex technical findings in clear business-friendly language
- Proven experience leading distributed onshore and offshore teams
- Strong decision-making and conflict resolution skills
Nice to Have
- Experience with PowerCenter rationalization or modernization programs
- Exposure to IDMC Cloud Data Integration
- Background in insurance or financial services data platforms
- Scope Clarification Important
- This is not a development or migration execution role
- Primary focus is on Assessment, Rationalization, Validation, and Readiness for modernization
- The quality and accuracy of rationalization outcomes measure success
- Timely client sign-offs
- Absence of production impact
Skills
Mandatory Skills: Informatica PowerCenter
Never miss an opportunity! Create an alert based on the job you applied for.
