Informatica PowerCenter IDMC Migration Lead

Role description

Informatica PowerCenter  IDMC Migration Lead 

cincinnati ohio Onsite 

Onshore Lead Informatica PowerCenter Rationalization

Experience

12-18 years in Informatica ETL delivery with strong clientfacing 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 clientfacing technical authority responsible for driving solution clarity guiding offshore teams managing risks and ensuring highconfidence 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 executivelevel 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 zerodisruption principles for production systems

Ensure that all recommendations are evidencebased 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

SQLintensive transformations and overrides

Solid understanding of data warehouse environments and largescale ETL ecosystems

Leadership Communication

Strong clientfacing communication and facilitation skills

Ability to explain complex technical findings in clear businessfriendly language

Proven experience leading distributed onshoreoffshore teams

Strong decisionmaking and conflictresolution 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

Other details

Benefits/perks listed below may vary depending on the nature of your employment with LTIMindtree (“LTIM”):

Benefits and Perks:

• Comprehensive Medical Plan Covering Medical, Dental, Vision


• Short Term and Long-Term Disability Coverage


• 401(k) Plan with Company match


• Life Insurance


• Vacation Time, Sick Leave, Paid Holidays


• Paid Paternity and Maternity Leave

The range displayed on each job posting reflects the minimum and maximum salary target for the position across all US locations. Within the range, individual pay is determined by work location and job level and additional factors including job-related skills, experience, and relevant education or training. Depending on the position offered, other forms of compensation may be provided as part of overall compensation like an annual performance-based bonus, sales incentive pay and other forms of bonus or variable compensation.

Disclaimer: The compensation and benefits information provided herein is accurate as of the date of
this posting.

LTIMindtree is an equal opportunity employer that is committed to diversity in the workplace. Our
employment decisions are made without regard to race, color, creed, religion, sex (including
pregnancy, childbirth or related medical conditions), gender identity or expression, national origin,
ancestry, age, family-care status, veteran status, marital status, civil union status, domestic
partnership status, military service, handicap or disability or history of handicap or disability, genetic
information, atypical hereditary cellular or blood trait, union affiliation, affectional or sexual orientation
or preference, or any other characteristic protected by applicable federal, state, or local law, except
where such considerations are bona fide occupational qualifications permitted by law.