? 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:
- FBDI (File - Based Data Import)
- ADFdi , where applicable
- Oracle Integration/interfaces
- REST/SOAP APIs, where applicable
- 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

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.
- Strong 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
- Solid 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

Oracle Fusion, SQL, Oracle EBS, Migration

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