Informatica PowerCenter IDMC Migration Lead - Cincinnati, OH (Onsite) - Need 15+ Years Experience

Dice is the leading career destination for tech experts at every stage of their careers. Our client, Saksoft, is seeking the following. Apply via Dice today!Position: Informatica PowerCenter IDMC Migration LeadLocation: Cincinnati, OH (Onsite)Duration: Long Term Job description: Experience12-18 years in Informatica ETL delivery with strong client-facing leadership experienceRole SummaryThe 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 ResponsibilitiesTechnical Functional LeadershipProvide overall technical leadership for PowerCenter rationalization and assessment activitiesGuide teams onInventory analysis of PowerCenter mappings, workflows, sessions, and jobsRationalization and depreciation approachComplexity classification and modernization readiness assessmentReview and validate key deliverables, includingRationalized inventoryDeprecation candidate listsEnvironment reconciliation resultsTesting and validation summariesClient 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 approvalsCoordinate with client SMEs forFunctional clarificationsBatch cycle understandingDependency confirmationsSupport executive-level walkthroughs and readoutsOffshore Coordination Delivery OversightProvide direction and clarity to offshore ETL engineers, data analysts and testersReview offshore outputs forAccuracyConsistencyAdherence to the agreed methodologyEnsure common understanding of standards, templates, and validation criteriaResolve technical and functional ambiguities raised by offshore teamsRisk Quality GovernanceIdentify and manage technical and execution risks, especially related toProduction stabilityIncorrect deprecation decisionsEnvironment inconsistenciesEnforce zero disruption principles for production systemsEnsure that all recommendations are evidence-based and defensibleAlign with the Project Manager on RAID dependencies and decision trackingPlanning Estimation SupportProvide inputs to the complexity scoring, Migration effort estimation and Modernization roadmap planningEnsure that rationalization outputs are usable for downstreamIDMC migration planningConversion feasibility assessmentRequired Skills ExpertiseTechnical ExpertiseDeep hands-on experience with Informatica PowerCenterStrong knowledge of ETL design patternsBatch scheduling and dependenciesSQL-intensive transformations and overridesSolid understanding of data warehouse environments and large-scale ETL ecosystemsLeadership CommunicationStrong client-facing communication and facilitation skillsAbility to explain complex technical findings in clear business-friendly languageProven experience leading distributed onshore and offshore teamsStrong decision-making and conflict resolution skillsNice to HaveExperience with PowerCenter rationalization or modernization programsExposure to IDMC Cloud Data IntegrationBackground in insurance or financial services data platformsScope Clarification ImportantThis is not a development or migration execution rolePrimary focus is on Assessment, Rationalization, Validation, and Readiness for modernizationThe quality and accuracy of rationalization outcomes measure successTimely client sign-offsAbsence of production impactSkillsMandatory Skills: Informatica PowerCenter