Oracle Data Migration Lead i

Ampcus, Inc; New York (NY); On-site; USD 110,000 - 150,000; Full time

Job summary

A global consulting firm in New York City seeks an Oracle Data Migration Lead responsible for end-to-end data migration strategy, design, and execution for Oracle implementations. The ideal candidate will manage data integrity while collaborating with various teams. Required qualifications include extensive experience in Oracle ERP and data migration, with a strong background in SQL and effective communication skills. The role offers a chance to lead critical projects in dynamic environments.

Qualifications

• Strong experience in Oracle Fusion Cloud data migration.
• Good understanding of GL, AP, AR, FA, SCM, HCM modules.
• Experience in global implementation programs.

Responsibilities

• Define and own the data migration strategy for Oracle Cloud.
• Lead data profiling, cleansing, enrichment, and gap analysis.
• Design and execute migration using FBDI / ADFDI, REST APIs.

Skills

Oracle Fusion Cloud data migration

SQL and data analysis

Stakeholder management

Communication skills

Leadership

Education

8-15 years of experience in Oracle ERP implementations

Oracle Fusion Cloud certifications

Tools

FBDI / ADFDI

REST APIs

ETL tools

Excel

Job description

Overview

Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team.

Job Title and Location

Job Title: Oracle Data Migration Lead

Job Location: New York City, NY

Job Description

The Oracle Data Migration Lead is responsible for end-to-end data migration strategy, design, execution, validation, and cutover for Oracle implementations and transformations. The role ensures data accuracy, completeness, integrity, and reconciliation while managing stakeholders across business, functional, and technical teams.

This role typically supports Oracle Fusion Financials, SCM, HCM, and EPM implementations, especially in global, multiledger, multicurrency environments.

Key Responsibilities

• Data Migration Strategy & Governance
  • Define and own the data migration strategy, approach, and methodology for Oracle Cloud implementations.
  • Establish data scope, migration waves, sequencing, and cutover plans.
  • Define data ownership, RACI, and governance framework.
  • Align data migration approach with business process design and implementation timelines.
• Data Assessment & Design
  • Perform source system analysis (EBS, legacy ERPs, thirdparty systems, spreadsheets).
  • Lead data profiling, cleansing, enrichment, and gap analysis.
  • Define data mapping documents (source Oracle target).
  • Collaborate with Functional Leads (GL, AP, AR, FA, SCM, HCM) to ensure correct data design.
• Oracle Data Migration Execution
  • Design and execute migration using:
    • FBDI / ADFDI.
    • REST APIs.
    • OTBI / BI Publisher extracts.
    • SQL / PLSQL scripts.
  • Manage migration for:
    • Chart of Accounts.
    • Suppliers / Customers.
    • Opening Balances.
    • Assets (A2R).
    • Inventory.
    • Employees.
    • Historical and transactional data (as required).
• Test Cycles & Validation
  • Own execution for:
    • Mock / SIT migration.
    • UAT migration.
    • PreProduction migration.
    • GoLive migration.
  • Validate:
    • Record counts.
    • Financial balances.
    • Asset values.
    • Subledger GL reconciliation.
  • Ensure successful resolution of data defects and reconciliation issues.
• Cutover & GoLive Support
  • Lead final cutover planning and execution.
  • Coordinate with:
    • Implementation team.
    • Technical team.
    • Business users.
    • Client PMO.
  • Ensure zero-defect critical data load.
  • Provide hypercare support post go-live.
• Stakeholder & Team Management
  • Act as the single point of contact for data migration.
  • Manage onshore/offshore data teams.
  • Communicate risks, issues, and status to leadership.
  • Work closely with:
    • Program Managers.
    • Functional Leads.
    • Technical Architects.
    • Client SMEs.
• Risk & Quality Management
  • Identify data risks early and define mitigation strategies.
  • Establish audit trails and version control.
  • Ensure compliance with data security, privacy, and regulatory requirements.
  • Maintain migration documentation and signoffs.

Required Skills & Experience

• Functional & Oracle Expertise
  • 8-15 years of experience in Oracle ERP implementations.
  • Strong experience in Oracle Fusion Cloud data migration.
  • Good understanding of:
    • GL, AP, AR, FA, SCM, HCM modules.
    • Chart of Accounts and ledgers.
    • Multicurrency and global rollouts.
• Technical Skills:
  • FBDI / ADFDI framework expertise.
  • Strong SQL and data analysis skills.
  • Knowledge of REST APIs (preferred).
  • Experience with ETL tools (preferred).
  • Excel power user (large datasets).
• Project & Leadership Skills
  • Experience in global implementation programs.
  • Strong stakeholder management and communication.
  • Ability to manage tight timelines and multiple migration cycles.
  • Experience working with SIs, vendors, and offshore teams.

Preferred Qualifications

• Oracle Fusion Cloud certifications.
• Experience migrating from Oracle EBS Fusion.
• Financial Services / Manufacturing / Retail domain experience.
• Prior experience as Data Migration Lead or Data Architect.

Soft Skills

• Excellent communication skills.
• Strong analytical and problemsolving abilities.
• Detail-oriented with strong quality focus.
• Leadership and decision-making capability.

Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veterans or individuals with disabilities.