Pan Asia Group• CX - Data Migration Technical Consultant
Skills & Certifications:
• None
Additional Information:
• Job Descrption
• Key Responsibilities
• Plan and execute end-to-end data migration activities for Oracle Fusion Cloud ERP and Procurement.
• Work with business and functional teams to identify source data, transformation rules, dependencies, and target-system requirements.
• Prepare and maintain data-migration strategies, object lists, mapping documents, conversion specifications, and reconciliation reports.
• Perform data profiling, cleansing, transformation, validation, and duplicate analysis.
• Develop and validate Oracle data-load files using tools and methods such as FBDI, ADFdi, spreadsheet loaders, REST APIs, SOAP services, and scheduled processes.
• Support the migration of relevant data objects, including:
• Chart of Accounts and other financial reference data
• Suppliers, supplier sites, contacts, addresses, and bank details
• Procurement business units, agents, categories, and approved supplier information
• Purchase agreements, purchase orders, requisitions, and related open transactions
• Customers, customer accounts, sites, contacts, and profiles
• Payables and Receivables open transactions
• General Ledger balances and journals
• Fixed Assets and Cash Management data, where applicable
• Analyse and resolve load errors, rejected records, reference-data issues, and data-quality exceptions.
• Ensure that parent-child relationships and cross-file references remain consistent across migration files.
• Perform pre-load and post-load validations and reconcile migrated data against source-system totals.
• Support mock conversions, conference-room pilots, system integration testing, user acceptance testing, cutover rehearsals, and production deployment.
• Maintain migration logs, issue trackers, control totals, exception reports, and sign-off documentation.
• Coordinate with Oracle functional and technical teams to address configuration and integration dependencies.
• Support production cutover and post-go-live data-migration activities.
• Required Qualifications and Experience
• Strong hands-on experience with Oracle Fusion Cloud ERP and Procurement data migration.
• Experience in at least one full-cycle Oracle Fusion Cloud implementation involving data conversion.
• Practical knowledge of Oracle Fusion FBDI templates, interface tables, import processes, and error-resolution procedures.
• Good understanding of Oracle Fusion Financials and Procurement data structures and business processes.
• Experience with data extraction, mapping, transformation, validation, loading, and reconciliation.
• Ability to analyse large data files and identify missing, duplicate, inconsistent, or invalid records.
• Working knowledge of SQL and experience preparing data extracts and reconciliation queries.
• Experience working with CSV files, Microsoft Excel, and data-transformation utilities.
• Strong understanding of data dependencies, reference keys, sequencing, and parent-child relationships.
• Ability to prepare technical design documents, mapping documents, load instructions, and reconciliation reports.
• Strong communication skills and the ability to work with business users, functional consultants, developers, and project management teams.
• Ability to work independently, manage multiple migration objects, and meet project deadlines.
• Preferred Qualifications
• Oracle Fusion Cloud certification in Financials, Procurement, or related areas.
• Experience migrating data from Oracle E-Business Suite or other legacy ERP applications.
• Knowledge of BI Publisher, OTBI, Oracle Integration Cloud, REST APIs, and SOAP web services.
• Experience with high-volume data migration and performance optimization.
• Experience supporting multiple mock conversions and production cutovers.
• Familiarity with data governance, audit, security, and handling sensitive financial and supplier information.
• Expected Deliverables
• Approved data-migration strategy and object inventory
• Source-to-target mapping and transformation documents
• Validated data-load files
• Load execution and error-resolution reports
• Source-to-target reconciliation results
• Cutover plans and execution checklists
• Migration completion and business sign-off documentation