Data Migration Analyst

Job Title:

Engagement Type:

Duration:

Location:

Budget:

Role Overview

We are seeking a Data Migration Analyst to support large-scale data extraction, profiling, and cleansing activities for migrating data from Microsoft GP and legacy systems to Oracle Fusion using FBDI templates.

Key Responsibilities

• Extract BOQ, PO, Item, Vendor, Customer, Project, and Financial data from Microsoft GP and legacy sources
• Perform data profiling on high-volume BOQ datasets (1K20K lines per project; ~1,500 projects annually)
• Assess data completeness, accuracy, consistency, and readiness for Oracle Fusion FBDI formats

Identify and document:

• Duplicate records
• Missing values
• Inconsistencies
• Validation gaps affecting migration
• Analyze ItemProject linkages, open BOQs/POs, partially completed contracts, and dependencies
• Prepare data profiling & readiness reports
• Maintain migration risk and dependency logs
• Support trial balance, open transactions, and financial data validation

In-Scope Data Domains

Master Data

• Item Master
• Customer Master
• Supplier/Vendor Master
• GL Master
• Budget / COA Structures
• Fixed Assets
• CPQ, Projects, Contracts

Transactional Data

• Open BOQs
• Open Purchase Orders
• AP Invoices
• Receipts
• Sales (Leads & Opportunities)
• Trial Balance

Key Deliverables

• Data profiling & readiness report
• BOQ complexity & volume assessment
• Migration risk and dependency log
• Cleaned master and transactional datasets (pre-FBDI)

Required Skills

• Strong experience with ERP data (Microsoft GP preferred)
• Hands-on data profiling, validation, and reconciliation
• Excellent understanding of master and transactional data structures
• Advanced Excel / CSV handling
• Good documentation and stakeholder communication skills