Oracle ERP Data Migration Specialist

Specialist - Package Implementation

Oracle ERP Conversion Analyst

The Oracle ERP Conversion Analyst is responsible for planning executing and validating data migration activities during Oracle ERP implementations or upgrades This role ensures accurate extraction transformation and loading ETL of legacy data into Oracle ERP systems Fusion or EBS maintaining data integrity and compliance throughout the migration lifecycle

Key Responsibilities

Data Migration Conversion

Analyze source data from legacy systems and map it to Oracle ERP structures

Develop data conversion strategies schedules and test plans

Design and document ETL processes for data extraction transformation and loading

Validation Testing

Perform data cleansing and transformation to ensure accuracy and consistency

Conduct mock conversions and support data validation during system testing and UAT

Create pre validation and post validation reports for business signoff

Collaboration

Work closely with functional and technical teams to understand migration requirements

Coordinate with ERP implementation specialists and business analysts for smooth execution

Documentation

Maintain detailed documentation of conversion processes mappings and validations

Troubleshooting

Identify and resolve data quality issues discrepancies and gaps throughout the migration lifecycle

Required Skills

Technical Expertise

Strong SQL scripting and PLSQL skills for data extraction and transformation

Hands on experience with Oracle Fusion or Oracle EBS data conversion processes

Tools Technologies

Familiarity with FBDI ADFdi and Oracle ERP technical objects

Knowledge of ERP data migration tools and accelerators

Additional Skills

Understanding of ERP modules Finance SCM HCM

Ability to optimize SQL queries and data extraction processes

Soft Skills

Excellent communication and collaboration skills

Strong analytical and problem solving abilities