Job Description
Position: Oracle Data Migration Consultant
Location: Remote
Automotive or Manufacturing background is required
Job Overview
Seeking an experienced Oracle Data Migration Consultant to lead and support data migration initiatives across Oracle ERP and Oracle Fusion Cloud environments. The role involves data assessment, extraction, transformation, cleansing, validation, reconciliation, and loading while ensuring data accuracy, integrity, security, and business continuity throughout the migration lifecycle.
Key Responsibilities
- Lead end-to-end data migration activities for Oracle E-Business Suite, Oracle Fusion Cloud ERP, and related Oracle applications.
- Analyze legacy data sources, identify data quality issues, and define migration strategies, mappings, and transformation rules.
- Develop data migration plans covering extraction, cleansing, transformation, validation, loading, reconciliation, and cutover activities.
- Work with functional teams across Oracle Financials, SCM, Manufacturing, HCM, Procurement, and other modules to understand data requirements.
- Perform source-to-target data mapping and develop detailed migration specifications.
- Extract and transform data using Oracle tools, SQL, ETL technologies, and other migration utilities.
- Configure and execute data loads using Oracle Fusion File-Based Data Import (FBDI), ADFdi, REST/SOAP APIs, and other appropriate Oracle integration mechanisms.
- Support Oracle Data Management and migration tools, including Oracle Enterprise Data Management and related utilities where applicable.
- Perform data profiling, cleansing, deduplication, enrichment, and standardization activities.
- Develop and execute data validation, reconciliation, and audit processes to ensure migration accuracy.
- Coordinate mock conversions, migration rehearsals, system integration testing, user acceptance testing, and production cutover.
- Troubleshoot data migration failures, interface issues, transformation errors, and reconciliation discrepancies.
- Develop SQL queries and scripts for data extraction, validation, reconciliation, and reporting.
- Maintain migration templates, mapping documents, conversion rules, data dictionaries, and technical documentation.
- Collaborate with business stakeholders, functional consultants, technical teams, integration teams, and external vendors.
- Support legacy-to-Oracle Fusion Cloud transformation and modernization programs.
- Ensure migrated data complies with organizational security, privacy, governance, and regulatory requirements.
- Provide post-migration support, issue resolution, and data verification.
- Identify opportunities to improve migration processes, automation, data quality, and repeatability.
Required Qualifications
- 7+ years of experience in Oracle data migration, data conversion, or Oracle ERP implementation projects.
- Strong experience with Oracle Fusion Cloud and/or Oracle E-Business Suite.
- Hands-on experience with end-to-end data migration and conversion processes.
- Strong SQL skills and experience working with relational databases.
- Experience with Oracle migration tools and technologies such as FBDI, ADFdi, REST APIs, SOAP APIs, and Oracle Integration Cloud.
- Experience creating source-to-target mappings, transformation rules, validation procedures, and reconciliation reports.
- Strong understanding of Oracle ERP data structures and business processes.
- Experience supporting multiple migration cycles, mock conversions, testing, and production cutovers.
- Strong analytical, problem-solving, documentation, and communication skills.
Preferred Qualifications
- Experience with Oracle Cloud ERP, SCM, HCM, Manufacturing, or Procurement data migration.
- Experience migrating data from SAP, PeopleSoft, JD Edwards, legacy Oracle applications, or other ERP platforms into Oracle Fusion Cloud.
- Knowledge of ETL/data integration tools such as Informatica, Talend, ODI, or similar technologies.
- Experience with Oracle Integration Cloud (OIC).
- Familiarity with Oracle Enterprise Data Management (EDM).
- Experience with large-scale ERP transformation and cloud migration programs.
- Understanding of data governance, master data management, and data quality frameworks.
- Oracle certifications are preferred.
Key Skills
Oracle Fusion Cloud | Oracle EBS | Data Migration | Data Conversion | FBDI | ADFdi | Oracle Integration Cloud | SQL | REST/SOAP APIs | ETL | Data Mapping | Data Cleansing | Data Validation | Data Reconciliation | Data Governance | Master Data Management | Mock Conversion | Cutover | Oracle ERP
Job Tags
Full time, Internship, Seasonal work