Senior Oracle Fusion Data Migration Consultant
Prefer a full account with a password? Sign Up to Apply
Job Description
As a Senior Oracle Fusion Data Migration Consultant, you will be responsible for the design, development and delivery of data migration solutions for Oracle Fusion Cloud implementations across ERP, HCM and SCM.
The primary focus of the role is Data Migration, requiring strong hands-on experience with FBDI, HDL/HSDL, SQL, data transformation, validation and reconciliation across the full migration lifecycle, from data profiling and mapping through mock migrations, cutover and post-load reconciliation.
The role may also contribute to Oracle Fusion reporting and data extraction, using technologies such as BI Publisher, OTBI and BICC. Experience with Oracle Integration Cloud (OIC) and Oracle Fusion APIs is also advantageous but is not required for the role.
Key Responsibilities
Data Migration
• Design and deliver end-to-end data migration solutions for Oracle Fusion ERP, HCM and SCM.
• Develop and execute FBDI loads for Oracle Fusion ERP and SCM.
• Develop and execute HDL and HSDL loads for Oracle Fusion HCM.
• Analyse and profile source-system data, identifying data-quality issues early in the migration lifecycle.
• Develop SQL-based extraction, transformation, cleansing and validation routines.
• Translate functional requirements and source-to-target mappings into repeatable migration processes.
• Understand and manage dependencies between configuration, reference, master and transactional data.
• Diagnose and resolve FBDI, HDL and HSDL load errors and rejected records.
• Develop reconciliation processes covering record counts, control totals, financial balances and other appropriate business measures.
• Maintain traceability and auditability between source data, transformed data and data loaded into Oracle Fusion.
• Plan and execute multiple mock migrations and dress rehearsals in preparation for production cutover.
• Establish migration timings, dependencies and sequencing to support detailed cutover planning.
• Produce migration runbooks covering extraction, transformation, load, validation and reconciliation activities.
• Execute and support production migration activities during cutover.
• Support post-go-live data validation and resolution of migration-related issues.
Data Quality, Validation & Governance
• Work closely with functional consultants and business data owners to understand data requirements and resolve data-quality issues.
• Ensure migration processes are repeatable, controlled and auditable across environments.
• Maintain migration specifications, mapping documents, transformation rules and reconciliation evidence.
• Apply agreed development, naming, version-control and documentation standards to migration artefacts.
• Support business validation and sign-off of migrated data.
• Participate in peer reviews and technical assurance of data migration solutions.
• Mentor junior consultants and provide guidance on Oracle Fusion data migration techniques and good practice.
Requirements
Department: Enterprise Applications
Function: Information Technology
Experience Level: Mid-Senior Level