5. Reconciliation, Validation and Data Quality Assurance

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

6. Functional, Business and Technical Collaboration

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

7. Migration Governance and Continuous Improvement

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

Key Deliverables

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.

HCM / Payroll Domain Knowledge

• The candidate should be comfortable working across a broad range of HCM and Payroll data domains. Depending on project scope, this may include:
  • Enterprise structures and reference data (e.g., legal employers, business units, departments, jobs, grades, locations and positions).
  • Worker, person, work relationship, assignment and employment history data.
  • Manager and organisational relationships.
  • Payroll relationships, payroll assignments, elements, element entries, payment methods, bank information and payroll balances.
  • Other HCM/Payroll objects and historical data required by the implementation.

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.

For more info, please share me updated CV at shameena@Lsarecruit.co.uk