Oracle Data Migration Lead i

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

Job summary

Ampcus Inc in New York City seeks an Oracle Data Migration Lead to define and execute the data migration strategy for Oracle Cloud implementations. The role necessitates 8-15 years of experience with Oracle ERP and strong SQL skills. The successful candidate will manage migration teams, ensure data integrity, and communicate effectively with stakeholders. Health benefits, flexible working hours, and professional development opportunities are includes in the offer.

Qualifications

• 8-15 years of experience in Oracle ERP implementations.
• Strong experience in Oracle Fusion Cloud data migration.
• Excellent communication skills and detail-oriented.

Responsibilities

• Define and own the data migration strategy for Oracle Cloud.
• Lead data profiling, cleansing, and mapping.
• Validate data during various migration cycles.

Skills

Oracle ERP Implementation Experience

Oracle Fusion Cloud Data Migration

SQL and Data Analysis Skills

Stakeholder Management

Leadership and Communication

Tools

FBDI/ADFDI

ETL Tools

REST APIs

Excel

Job description

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: 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, multi‑ledger, multi‑currency 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, third‑party 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 / PL‑SQL 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.
    • Pre‑Production migration.
    • Go‑Live migration.
  • Validate:
    • Record counts.
    • Financial balances.
    • Asset values.
    • Subledger GL reconciliation.
  • Ensure successful resolution of data defects and reconciliation issues.
• Cutover & Go‑Live Support
  • Lead final cutover planning and execution.
  • Coordinate with:
    • Implementation team.
    • Technical team.
    • Business users.
    • Client PMO.
  • Ensure zero‑defect critical data load.
  • Provide hyper‑care 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 sign‑offs.

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.
    • Multi‑currency 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 problem-solving 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.