Position Summary

We are seeking an experienced ERP Data Migration Engineer to support enterprise ERP implementation and transformation initiatives. This role is responsible for designing, developing, and executing data extraction, transformation, validation, and migration processes while ensuring data quality, accuracy, and auditability throughout the migration lifecycle.

The ideal candidate will have strong experience with ERP data migrations and ETL/ELT processes. Experience with Oracle Fusion Cloud ERP is highly preferred. Working closely with the Data Architect, Data Analyst, Business Analysts, Functional Consultants, and implementation partner technical teams, this individual will help deliver reliable, repeatable, and well-documented data migration solutions supporting Finance, Procurement, Supply Chain, Projects, Human Capital Management, and other enterprise functions.

Key Responsibilities

Data Engineering & Development

Design, develop, and maintain scalable data pipelines supporting ERP implementations.
Build data ingestion, transformation, and validation processes.
Develop reusable ETL/ELT frameworks for enterprise data processing.
Optimize data movement and processing for performance and scalability.
Build repeatable, auditable data movement and validation routines that ensure migration quality and traceability.

Data Migration

Support end-to-end ERP data migration activities.
Extract and stage data from legacy ERP, EPM, and other enterprise source systems for profiling, cleansing, and migration readiness.
Perform:
Data extraction
Data profiling
Data cleansing
Data transformation
Data validation
Data reconciliation
Support data conversion planning, mock migrations, and production cutovers.
Validate migrated data to ensure completeness, consistency, and business readiness.
Collaborate with implementation partner technical teams to coordinate migration activities and avoid duplicate or conflicting work during the migration process.

Data Mapping & Transformation

Support source-to-target mapping activities in collaboration with the Data Architect and Data Analyst.
Assist in defining business rules and transformation logic required for successful migrations.
Validate mapping accuracy throughout testing and deployment cycles.

Technical Documentation

Create and maintain technical documentation for:
Data extraction logic
Transformation logic
Validation rules
Data movement processes
Load results
Migration reconciliation activities
Ensure documentation is complete, repeatable, and auditable for future migration cycles and operational support.

Integration Support

Support integrations between ERP platforms and enterprise applications.
Work with technologies such as:
REST APIs
SOAP Web Services
Integration platforms
Batch data interfaces
Troubleshoot and optimize integration performance supporting migration activities.

Database Development

Develop SQL and PL/SQL scripts supporting migration, reporting, and validation.
Optimize database performance and data processing.
Assist in maintaining enterprise data repositories.

Data Quality

Perform data validation and reconciliation.
Identify and resolve data quality issues.
Support Master Data Management initiatives.
Ensure migrated data meets established quality standards before production deployment.

Collaboration

Work closely with:
Data Architect
Data Analyst
Business Analysts
Functional Consultants
Integration Developers
Implementation Partner Technical Teams
Business Stakeholders
Support testing, defect resolution, user acceptance testing, and production deployments.
Participate in migration planning sessions and technical design discussions.

Required Qualifications

Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field.
5+ years of Data Engineering or Data Migration experience.
Experience supporting enterprise ERP implementations or migrations.
Oracle Fusion Cloud ERP experience is highly preferred.
Strong SQL and PL/SQL skills.
Experience building ETL/ELT processes.
Experience extracting, transforming, validating, and reconciling enterprise data.
Excellent analytical, troubleshooting, and problem-solving skills.
Strong documentation and communication skills.

Required Technical Skills

ERP & Enterprise Platforms

ERP implementation and migration experience (Oracle Fusion Cloud ERP preferred)
Oracle Fusion Cloud ERP (preferred)
Oracle Cloud Infrastructure (OCI) (preferred)
Oracle Integration Cloud (OIC) (preferred)

Database Technologies

SQL
PL/SQL
Oracle Database

Data Integration

ETL/ELT Development
REST APIs
SOAP APIs
Enterprise Data Integration

Data Migration

Data Extraction
Data Profiling
Data Cleansing
Data Transformation
Source-to-Target Mapping
Data Validation
Data Reconciliation
Data Migration
Performance Optimization

Preferred Qualifications

Oracle Fusion Cloud certifications.
Experience migrating from Oracle E-Business Suite (EBS), SAP, PeopleSoft, JD Edwards, or other enterprise ERP platforms.
Experience with enterprise data governance and Master Data Management.
Experience working alongside large ERP implementation partners.
Familiarity with Agile delivery methodologies.