? Oracle EBS 11i to Oracle Fusion Data Migration Specialist

Experience

4+ years

Role

Oracle Data Migration & Data Cleansing Specialist ? EBS 11i to Oracle Fusion

Job Summary

We are looking for an experienced Oracle Data Migration Specialist with 4+ years of experience in Oracle EBS 11i/R12 and Oracle Fusion Cloud ERP , with strong hands - on expertise in data cleansing, data validation, extraction, transformation, and migration .

The role will be responsible for supporting end - to - end data migration activities from legacy

Oracle EBS 11i to Oracle Fusion , ensuring data quality, completeness, accuracy,

reconciliation, and business readiness throughout the migration lifecycle.

Key Responsibilities

? Perform data assessment and profiling of Oracle EBS 11i data to identify duplicates, obsolete records, invalid values, incomplete attributes, and data quality issues.

? Develop and execute data cleansing strategies for customers, suppliers, sites,

invoices, purchase orders, GL accounts, COA, payments, assets, and other

Finance/SCM master and transactional data.

? Extract data from Oracle EBS 11i using SQL queries, standard reports, interfaces,

and approved extraction mechanisms.

? Analyze legacy data and map EBS 11i structures to corresponding Oracle Fusion

Cloud data structures.

? Prepare source - to - target mapping documents and transformation rules.

? Perform data transformation and enrichment based on Fusion business

? Support migration using Oracle Fusion tools such as:

o FBDI (File - Based Data Import)

o ADFdi , where applicable o Oracle Integration/interfaces o REST/SOAP APIs, where applicable o Other approved Oracle Fusion data - loading mechanisms

? Prepare migration templates and validate data before loading into Fusion.

? Perform mock migrations, SIT, UAT, cutover and production migration activities.

? Validate migrated data in Fusion against EBS 11i source data.

? Perform record - count, amount, balance, and control - total reconciliation between source and target systems.

? Identify and resolve migration errors, rejected records, missing mandatory attributes, and transformation issues.

? Work closely with Finance, SCM, Business, Functional, Technical, Integration,

and Oracle teams to resolve data - related issues.





? Support migration of historical and open transactional data based on the agreed migration strategy.

? Maintain data migration trackers, reconciliation reports, issue logs, mapping documents, and migration runbooks.

? Support data freeze, final extraction, cutover, validation, and post - go - live reconciliation .

? Participate in migration dress rehearsals and contribute to the cutover plan and execution .

? Ensure appropriate controls are established for migrated financial and operational

Key Data Areas The candidate should have exposure to one or more of the following:

Finance

? General Ledger

? Chart of Accounts

? Legal Entities

? Ledgers

? Operating Units

? Suppliers and Supplier Sites

? Customers and Customer Accounts

? AP Invoices

? AP Payments

? AR Invoices

? AR Receipts

? Fixed Assets

? Tax - related data

? Open balances and transactions

Procurement / SCM

? Purchase Orders

? Requisitions

? Suppliers

? Items

? Item Categories

? Inventory Organizations

Technical Skills

? Strong SQL skills for Oracle EBS data extraction and validation.

? Good understanding of Oracle EBS 11i/R12 database tables and relationships .

? Experience with Oracle EBS modules such as AP, AR, GL, FA, PO and Inventory .

? Working knowledge of Oracle Fusion Cloud ERP data structures.

? Hands - on experience with FBDI templates and data loading .

? Knowledge of Excel for data cleansing, transformation, reconciliation and analysis.

? Understanding of ETL concepts and data transformation.

? Exposure to Oracle Integration Cloud ( OIC ) is desirable.

? Knowledge of REST/SOAP APIs is an advantage.

? Ability to develop complex SQL queries for data validation and reconciliation.

Data Migration Responsibilities The candidate should be able to independently execute the following migration lifecycle:

EBS 11i Data ? Data Profiling ? Data Cleansing ? Mapping ? Transformation ?





Validation ? FBDI/API Preparation ? Fusion Load ? Reconciliation ? Business

Validation

Data Quality & Reconciliation

? Identify duplicate and inconsistent master data.

? Validate mandatory fields and reference data.

? Check invalid, obsolete and end - dated records.

? Validate organizational mappings.

? Reconcile source and target record counts.

? Reconcile financial balances and transaction amounts.

? Investigate migration variances and prepare root - cause analysis.

Documentation

Prepare and maintain

? Data Migration Strategy

? Data Cleansing Plan

? Source - to - Target Mapping

? Data Transformation Rules

? Data Validation Rules

? Migration Templates

? Reconciliation Reports

? Migration Issue Tracker

? Mock Migration Results

? Cutover Plan

? Migration Runbook

? Post - Migration Validation Checklist

Required Functional Knowledge

? Good understanding of Oracle EBS 11i business processes .

? Basic to intermediate understanding of Oracle Fusion ERP .

? Understanding of Finance processes such as P2P, O2C and R2R .

? Understanding of master data and transactional data relationships.

? Ability to translate functional requirements into data mapping and validation rules.

? Solid analytical and problem - solving skills.

Preferred Qualifications

? Bachelor?s degree in computer science, Information Technology, Finance,

Engineering, or related field.

? Oracle EBS/Fusion certification is an advantage.

? Experience supporting at least one complete EBS - to - Fusion migration cycle is

Key Competencies

? Robust SQL and data analysis skills

? Oracle EBS 11i knowledge

? Oracle Fusion Cloud knowledge

? Data cleansing and quality management

? Data migration and reconciliation

? Problem - solving and analytical ability

? Strong Excel skills

? Stakeholder management

? Documentation and reporting

? Ability to work independently and manage migration activities within deadlines

Experience Profile

4+ years of relevant experience , preferably including:

? 2+ years of Oracle EBS 11i/R12 experience

? Hands - on data extraction and SQL experience

? Experience in data cleansing and reconciliation

? Experience with Oracle Fusion data migration

? Exposure to FBDI/API - based data loading

📌 SENIOR ADMINISTRATOR SYSTEM - Oracle Fusion (Noida)
🏢 Happiest Minds
📍 Noida