Informatica PowerCenter Lead in Cincinnati OH

Informatica Power Center Lead

Client Insurance Domain

Location Cincinnati OH onsite

The Onshore Lead will be responsible for technical and delivery leadership of the Power Center 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.

• Provide overall technical leadership for Power Center rationalization and assessment activities.
• Guide teams on Inventory analysis of Power Center mappings, workflows, sessions and jobs.
• Guide teams on Rationalization and deprecation approach.
• Guide teams on Complexity classification and modernization readiness assessment.
• Review and validate key deliverables including Rationalized inventory, Deprecation candidate lists, Environment reconciliation results, Testing and validation summaries.

• 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.

• 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.

• 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.

• 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.

• Deep Handson experience with Informatica Power Center.
• 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.

• 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.

• Experience with Power Center 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.