Oracle Fusion Data Migration Lead
Ampcus Inc
New York, NY, United States
3 days ago
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Apply on diversityjobs.com
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
7 years minimum
Working hours
Regular working hours
Job source
Tech stack
Cloud Computing
Cloud Database
Information Systems
Data Validation
Data Cleansing
Data Integration
Extract Transform Load (ETL)
Data Mapping
Data Migration
Data Mining
Data Profiling
Data Structures
+11 more
Software Design Documents
Oracle (Applications)
Reference Data
PL-SQL
SQL Databases
Oracle Fusion Middleware
Systems Integration
Test Data
Build Management
Information Technology
Oracle Cloud Infrastructure
Job description
- Lead the end-to-end data migration strategy, planning, and execution for Oracle Fusion Cloud across Finance, Procurement, PPM, and FAH modules.
- Define and manage the data migration framework, including scope, methodology, data quality rules, reconciliation approach, environments, and migration cycles.
- Lead data object discovery, data profiling, and data mapping workshops with business, functional, and technical teams.
- Oversee the design and build of data extraction, transformation, and load (ETL) components using FBDI/ADFDI, ODI, FDI, and ADW pipelines where applicable.
- Collaborate with functional teams to validate mapping rules, transformation logic, cross[1]module dependencies, and reference data alignment.
- Define and manage mock cycles, including Cycle 1/2/3 execution, defect resolution, and reconciliation processes.
- Direct the development of data validation scripts, SQL-based reconciliation queries, and reporting checks across subledgers and the general ledger.
- Partner with Integration and Technical teams to support migration-related integrations, pre-load checks, post-load validations, and workflow triggers.
- Manage data readiness for SIT, UAT, Parallel Testing, and Cutover, ensuring availability of high-quality data for all testing cycles.
- Lead cutover data migration planning and execution, including coordinated runbooks, load sequencing, freezing windows, and approval gates.
- Establish governance for mastering data quality, tracking data issues, data cleansing progress, and business ownership alignment.
- Provide direction and oversight to offshore data migration resources and ensure consistent delivery quality.
- Prepare and maintain documentation including data mapping sheets, conversion design documents, reconciliation logs, KPIs, and migration dashboards.
Requirements
- Bachelor’s degree in information systems, Computer Science, Engineering, Finance, or related field.
- 12-15+ years of experience in data migration, with 7+ years delivering Oracle Fusion Cloud data migrations.
- Expertise in FBDI/ADFDI, ODI, FDI, ADW, SQL/PLSQL, and ETL methodologies.
- Strong understanding of data structures and conversion requirements for GL, AP, AR, FA, CM, PO, SSP, Suppliers, and FAH.
- Experience executing multi-cycle migration for large-scale ERP programs across multiple geographies (NA, EMEA, APAC).
- Prior experience with data cleansing, data profiling, validation rules, mapping logic, and migration error handling.
- Strong knowledge of financial and procurement data models, including subledger-to ledger posting logic.
- Experience supporting SIT/UAT cycles with test data preparation and reconciliation.
- Ability to manage offshore teams and coordinate with multiple workstreams.
- Excellent analytical, documentation, communication, and stakeholder engagement skills.
Preferred Certifications:
- Oracle Fusion Financials or
- Procurement Cloud Implementation Specialist.
- OCI Data Integration Associate.
- Oracle Autonomous Database Cloud 2023 Certified Specialist.
About the company
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.
Apply for this position
This job is hosted externally. Click below to view the full posting and apply.
Apply on diversityjobs.com
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this role…