LEAD ADMINISTRATOR SYSTEM - Oracle Fusion

Role overview

LEAD ADMINISTRATOR SYSTEM - Oracle Fusion at Happiest Minds

Key Responsibilities ?

?

Oracle EBS 11i to Oracle Fusion Data Migration Specialist Experience 4+ years Role Oracle Data Migration & Data Cleansing Specialist ?

EBS 11i to Oracle Fusion

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.

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 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. ?

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. ?

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

Strong 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

Preferred qualifications and skills

• Knowledge of REST/SOAP APIs is an advantage. ?
• Oracle EBS/Fusion certification is an advantage. ?

Employment details

• Location: Noida