Oracle Fusion Data Migration Consultant (SC Cleared/Eligible)

Role: Oracle Fusion Data Migration Consultant (SC Cleared/NPPV3 Cleared/SC Eligible)

Location: Staffordshire, UK

Contract Type

Required Technical Skills and Knowledge

· Strong hands-on experience delivering Oracle Fusion HCM and/or Payroll data migration activities.

· Strong understanding of Oracle Fusion HCM data structures, effective-dated data and dependencies between key migration objects.

· Practical experience preparing and loading data using Oracle HCM Data Loader (HDL); HSDL experience is beneficial.

· Ability to interpret HDL load errors, diagnose root causes and independently resolve or coordinate fixes.

· Strong SQL skills for data analysis, transformation, validation and reconciliation; PL/SQL experience is advantageous.

· Working knowledge of Oracle Fusion reporting capabilities, particularly BI Publisher and OTBI, for post-load validation and reconciliation.

· Advanced Microsoft Excel capability, including complex formulas, lookups, pivots, data cleansing, comparison and large-volume analysis; Power Query or similar analytical tooling is advantageous.

· Strong understanding of data mapping, transformation, cleansing, validation, reconciliation and migration quality controls.

· Experience working with HCM and Payroll functional teams and translating functional design/configuration into actionable migration requirements.

· Ability to analyse large and complex datasets, identify anomalies and explain data issues clearly to technical and non-technical stakeholders.

Required Experience

· Proven experience leading data migration workstreams within Oracle Fusion HCM and/or Payroll implementation programmes.

· Demonstrable experience working directly with customer source-data teams where the customer owns legacy extraction activities.

· Experience completing multiple migration cycles from initial mapping through mock loads, validation, reconciliation, defect resolution, cutover and final production load.

· Track record of personally performing data preparation, file creation, load execution and troubleshooting in addition to migration coordination.

· Experience presenting migration findings, data defects and resolution options to business users, functional consultants and programme leadership.

Desirable / Advantageous Skills

· Experience with UK Oracle Fusion Payroll implementations and payroll migration/reconciliation.

· Experience migrating from ResourceLink or other enterprise HR/payroll legacy platforms.

· Knowledge of FBDI, REST/SOAP interfaces, Oracle Integration Cloud or broader Fusion integration patterns.

· Experience with data migration accelerators, ETL tools, scripting languages or automation used to transform and validate high-volume migration data.

· Understanding of Oracle Fusion security and scheduled processes that can affect post-load data visibility or downstream processing.

· Experience with defect-management and delivery tools such as Jira, SpiraTest or similar platforms.