PowerCenter Lead — Rationalization & Modernization (Onsite)

Informatica PowerCenter Lead Client Insurance Domain Location Cincinnati OH onsite 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 rationalization 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 deprecation 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 Lead client discussions on Rationalization findings Risk areas and assumptions 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 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 Complexity scoring Migration effort estimation Modernization roadmap planning Ensure that rationalization outputs are usable for downstream IDMC migration planning Conversion feasibility assessment Required Skills Expertise Technical Expertise Deep Handson 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 largescale ETL ecosystems LeadershipCommunication Strong client facing communication and facilitation skills Ability to explain complex technical findings in clear business friendly language Proven experience leading distributed onshore 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 Readiness for modernization Success is measured by Quality and accuracy of rationalization outcomes Timely client signoffs Absence of production impact #J-18808-Ljbffr Tech Mirrors