25 Oct
|
Happiest Minds Technologies
|
Noida
25 Oct
Happiest Minds Technologies
Noida
Job Description
? 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
• 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 Oracle Fusion, SQL, Oracle EBS, Migration
📌 LEAD ADMINISTRATOR SYSTEM (Noida)
🏢 Happiest Minds Technologies
📍 Noida