Oracle Fusion Data Migration Lead

\n

Note: Need Active SC Clearence Candidates

\n

\n

Key Responsibilities

\n

1. Data Migration Planning and Cycle Leadership

\n

\n
• Own and drive the data migration workstream across mock migrations, testing cycles, cutover rehearsals and production migration.
\n
• Create and maintain detailed data migration plans covering extraction, mapping, transformation, file preparation, load, validation, reconciliation, defect resolution and rework.
\n
• Define migration milestones, dependencies, entry/exit criteria, ownership and delivery checkpoints for each data object.
\n
• Track migration progress, risks, data defects, decisions and actions, escalating issues that could impact the wider implementation plan.
\n
• Coordinate with programme, customer, functional, technical, testing and business teams while retaining direct ownership of migration delivery.
\n

\n

2. Customer Extraction Requirements and Legacy Data Analysis

\n

\n
• Work closely with customer data/extraction teams to define the exact data required from the legacy system for each Oracle Fusion object.
\n
• Translate Oracle Fusion functional and technical requirements into clear legacy extraction specifications, including required fields, selection criteria, effective dating, historical data rules, filters, defaults and valid values.
\n
• Review customer-generated extracts for completeness, structure, data quality and fitness for migration before transformation and load activities begin.
\n
• Analyse source data to identify duplicates, missing mandatory values, invalid dates, broken relationships, inconsistent codes, referential integrity issues and other migration risks.
\n
• Provide actionable feedback to the customer on extraction issues and support iterative correction of source extracts.
\n

\n

3. Legacy-to-Fusion Mapping and Migration Design

\n

\n
• Create, maintain and mature mapping documents that establish field-level and value-level mappings between legacy systems and Oracle Fusion.
\n
• Document source fields, Fusion target attributes, transformation rules, defaulting logic, lookup/value mappings, effective-date handling, derivation logic and business rules.
\n
• Work with HCM and Payroll functional consultants to confirm target configuration, mandatory attributes, business rules, reference data and downstream dependencies.
\n
• Ensure changes agreed during migration cycles, defect resolution or functional design discussions are reflected in migration mapping and transformation documentation.
\n
• Identify gaps where legacy data cannot directly support Fusion requirements and define pragmatic transformation, cleansing or defaulting approaches with the relevant stakeholders.
\n

\n

4. Hands-on Data Preparation, Transformation and Oracle Fusion Loading

\n

\n
• Prepare Oracle Fusion migration templates and load-ready files from customer-provided legacy extracts.
\n
• Perform data manipulation, transformation, enrichment, formatting and validation using SQL, Excel and other suitable analytical or data-processing tools.
\n
• Create and execute HCM Data Loader (HDL) files and, where appropriate, HCM Spreadsheet Data Loader (HSDL) or other Oracle-supported loading mechanisms.
\n
• Manage load sequencing and dependencies between related HCM and Payroll objects to ensure data is loaded in the correct order.
\n
• Execute loads in Oracle Fusion, review load status and logs, identify failed records, investigate root causes, correct data or file structures and perform re-loads until agreed acceptance criteria are achieved.
\n
• Differentiate between source-data, mapping, transformation, configuration, environment and load-mechanism issues and route or resolve them appropriately.
\n
• Provide clear technical and business justification for rejected or failed records and recommend the required corrective action.
\n

\n

5. Reconciliation, Validation and Data Quality Assurance

\n

\n
• Develop, modify and execute reconciliation reports comparing source data, prepared migration files and successfully loaded Oracle Fusion data.
\n
• Use SQL and Oracle Fusion reporting tools such as BI Publisher and OTBI to validate migrated data and identify variances.
\n
• Create object-level validation reports covering record counts, key totals, critical attributes, balances, relationships and other business-significant measures.
\n
• Perform detailed analytical review of migration results rather than relying only on load success percentages.
\n
• Investigate reconciliation differences, identify root causes and drive corrective action through source correction, transformation changes, configuration updates or reload.
\n
• Support business validation by supplying clear reports, exception lists, evidence and explanations that enable customer sign-off.
\n

\n

6. Functional, Business and Technical Collaboration

\n

\n
• Partner with Oracle Fusion HCM and Payroll functional consultants to understand configuration, statutory/legislative requirements, functional dependencies and object-specific migration requirements.
\n
• Translate functional requirements into data requirements that customer extraction teams can understand and implement.
\n
• Work directly with business users to clarify legacy data meaning, validate transformation assumptions and resolve data exceptions.
\n
• Collaborate with reporting, integration, security and technical teams where migrated data affects downstream processes or reconciliation.
\n
• Act as the primary data migration point of contact for assigned HCM/Payroll areas and provide confident, evidence-based updates to stakeholders.
\n

\n

7. Migration Governance and Continuous Improvement

\n

\n
• Maintain clear auditability of migration rules, mapping decisions, file versions, load results, reconciliation evidence and outstanding exceptions.
\n
• Establish repeatable migration processes, templates, checklists and quality controls across migration cycles.
\n
• Perform root-cause analysis on recurring migration issues and introduce preventative controls for subsequent cycles.
\n
• Support cutover planning by defining final extraction windows, load sequence, estimated processing activities, reconciliation steps and business sign-off requirements.
\n
• Contribute to migration closure reporting, lessons learned and transition of migration knowledge into support or BAU teams where required.
\n

\n

Key Deliverables

\n

Deliverable

\n

Expected Outcome

\n

\n

Data Migration Plan

\n

Object-level plan covering extraction, transformation, load, validation, reconciliation, defects, rework and sign-off.

\n

Mapping Documents

\n

Field/value mapping and business-rule documentation between legacy source data and Oracle Fusion.

\n

Extraction Requirements

\n

Clear customer-facing specifications defining the shape, content, criteria and history required from source systems.

\n

Fusion Load Files

\n

Validated HDL/HSDL or other Oracle-supported migration files prepared in the required load sequence.

\n

Load & Error Analysis

\n

Load logs, exception tracking, root-cause analysis, corrections and evidence of successful reload.

\n

Reconciliation Reports

\n

Source-to-file-to-Fusion reconciliation including counts, key attributes, totals and exception analysis.

\n

Validation Evidence

\n

Business-readable validation outputs and supporting evidence for migration acceptance/sign-off.

\n

Cycle Status & Closure

\n

Progress reporting, risks/issues, migration metrics, outstanding exceptions and closure/lessons-learned outputs.

\n

Required Technical Skills and Knowledge

\n

\n
• Strong hands-on experience delivering Oracle Fusion HCM and/or Payroll data migration activities.
\n
• Strong understanding of Oracle Fusion HCM data structures, effective-dated data and dependencies between key migration objects.
\n
• Practical experience preparing and loading data using Oracle HCM Data Loader (HDL); HSDL experience is beneficial.
\n
• Ability to interpret HDL load errors, diagnose root causes and independently resolve or coordinate fixes.
\n
• Strong SQL skills for data analysis, transformation, validation and reconciliation; PL/SQL experience is advantageous.
\n
• Working knowledge of Oracle Fusion reporting capabilities, particularly BI Publisher and OTBI, for post-load validation and reconciliation.
\n
• Advanced Microsoft Excel capability, including complex formulas, lookups, pivots, data cleansing, comparison and large-volume analysis; Power Query or similar analytical tooling is advantageous.
\n
• Strong understanding of data mapping, transformation, cleansing, validation, reconciliation and migration quality controls.
\n
• Experience working with HCM and Payroll functional teams and translating functional design/configuration into actionable migration requirements.
\n
• Ability to analyse large and complex datasets, identify anomalies and explain data issues clearly to technical and non-technical stakeholders.
\n

\n

HCM / Payroll Domain Knowledge

\n

The candidate should be comfortable working across a broad range of HCM and Payroll data domains. Depending on project scope, this may include:

\n

\n
• Enterprise structures and reference data (e.g., legal employers, business units, departments, jobs, grades, locations and positions).
\n
• Worker, person, work relationship, assignment and employment history data.
\n
• Manager and organisational relationships.
\n
• Payroll relationships, payroll assignments, elements, element entries, payment methods, bank information and payroll balances.
\n
• Other HCM/Payroll objects and historical data required by the implementation.
\n

\n

\n

Required Experience

\n

\n
• Proven experience leading data migration workstreams within Oracle Fusion HCM and/or Payroll implementation programmes.
\n
• Demonstrable experience working directly with customer source-data teams where the customer owns legacy extraction activities.
\n
• Experience completing multiple migration cycles from initial mapping through mock loads, validation, reconciliation, defect resolution, cutover and final production load.
\n
• Track record of personally performing data preparation, file creation, load execution and troubleshooting in addition to migration coordination.
\n
• Experience presenting migration findings, data defects and resolution options to business users, functional consultants and programme leadership.
\n

\n

\n

\n

For more info, please share me updated CV at [email protected]