Data Migration Engineer ( Xpedeon to SAP) Hr90 Degrees Consulting Services FZ LLC

The Data Migration Engineer is responsible for extracting, cleansing, transforming, and validating data from Xpedeon ERP and related legacy systems, preparing it for structured upload into SAP S/4HANA.

This role ensures data accuracy, semantic consistency, and completeness across all business domains (e.g., Projects, Procurement, Finance, Assets, and Materials) to enable a seamless transition to SAP.

Responsibilities:

1. Data Extraction & Analysis

• Extract master and transactional data from Xpedeon and associated databases.

• Analyze data structures, relationships, and dependencies between Xpedeon and SAP data models.

• Profile legacy data to identify gaps, duplicates, and inconsistencies.

2. Data Cleansing & Standardization

• Apply business rules and data quality checks to cleanse and enrich extracted data.

• Standardize naming conventions, codes, and units of measure across entities.

• Work with business owners to validate corrections and align with SAP master data standards.

3. Data Transformation & Mapping

• Design and execute transformation logic to map Xpedeon fields to corresponding SAP data objects (e.g., Material Master, Vendor, Project Definition, Cost Center, Purchase Request, Purchase Order, Open Items etc.).

• Develop and document data mapping templates, transformation scripts, and conversion rules.

• Apply data imputation techniques where required to fill missing or incomplete attributes.

4. Data Validation & Reconciliation

• Conduct data validation against business rules and SAP upload templates.

• Perform record count and value reconciliation between Xpedeon extracts and SAP load files.

• Collaborate with functional consultants to perform mock loads and verify data correctness post-upload.

5. Automation & Tooling

• Utilize ETL tools (e.g., SAP Data Services, SSIS, Alteryx, Python, Excel Power Query) for data cleansing and transformation.

• Create reusable data cleansing and transformation pipelines.

• Implement validation scripts and reports to automate quality checks.

6. Documentation & Governance

• Maintain detailed documentation of data mapping, transformation logic, and validation rules.

• Support audit and traceability by maintaining version-controlled migration files.

• Continuously report Metrics to stakeholders on mock exercises and final cutover.

• Timely escalate any bottleneck or challenges in progress.