Technical Lead - Oracle ERP Data Migration

Role Description

We are currently undertaking a multi-year ERP modernization program for migrating and upgrading on-premise Oracle E-Business Financials, Oracle PeopleSoft Human Capital Management Applications, and Kronos Workforce Management System to the latest SaaS-based Oracle Cloud ERP Platform as part of business and technology transformation. The Technical Lead - Oracle ERP Data Migration will lead the Data Migration and Reporting for the ERP modernization program.

This role will be responsible for the orchestration of migrating On-Premise Oracle E-Business and Oracle PeopleSoft data to Oracle Fusion Cloud and Business Intelligence Analytical Reporting to meet the business and technical requirements and ERP Modernization Program delivery on time and within budget.

The Data Migration Technical Lead is accountable for the following responsibilities:

• Developing data management plans with solid experience in developing data cleansing strategies, action plans, reconciliation plans, and scripts.
• Good experience in understanding data models, data integrity and normalization rules, data extraction, load, and transformation scripts.
• Functional experience to understand the business context of data in Oracle E-Business Financials and Procurement, and Oracle PeopleSoft HCM and Payroll.
• Determining the validity of the values of the data elements and reviewing and validating data relationships.
• Coordinating with data owners to validate cleansed data (e.g., reconciling transaction details to summary records such as commitments and obligations to General Ledger (GL) balances).
• Determining data migration requirements.
• Defining roles and responsibilities for the data migration activities.
• Reviewing and providing comments and suggestions on the data management plan, data migration plan, checklist, timeline, and conversion report delivered.
• Documenting migration activity timelines for mock conversions and production deployment.
• Developing a data migration checklist and sign-off process to ensure completion of planned activities.
• Mapping the data in the format provided in conversion templates.
• Assisting with determining data migration security controls.
• Developing unit and end-to-end integration migration test plans (including testing for data extraction, transformation, data loading, and data validation).
• Validating data of multiple mock conversions and the full migration coordinating with unit and end-to-end integration testing.
• Documenting the end-to-end data migration test results and lessons learned report.

Qualifications

• Experience in migrating master data and transactional data from On-Premise Oracle E-Business and Oracle PeopleSoft to Oracle Fusion Cloud.
• Expertise in Data Migration of Master data and transactional data including Extraction, Cleansing, Transformation, Loading, and Validation from Legacy systems to Oracle Cloud.
• Experience with Data Migration activities for Master Data such as COA, Employee, etc., and Transactional and Historical data.
• Experience with Oracle Data Migration processes including preparation of migration strategy, conversion plan, timing of data loads, object dependencies, sequencing of tasks.
• Experience in using ETL and SQL tools used for data migration.
• Experience in working with Oracle Financials, Procurement, HCM, and Time and Labor Cloud modules.
• Excellent oral and written communication skills.
• Extensive interaction with functional and technical leads, business users, and Oracle SMEs.

Requirements

• Bachelor's Degree from an accredited college or university is required.
• A major in Business Administration, Information Technology, or Engineering is preferred.
• Master's Degree preferably an MBA with a major in MIS, Human Resources Management, Finance, or Accounting preferred.
• Oracle ERP Cloud certifications preferred.
• One recent end-to-end full life cycle experience as an Oracle Fusion data migration lead implementing Oracle Fusion Financials, HCM, and Procurement Cloud Services.
• Experience utilizing Oracle and other industry-leading ETL tools and technologies to support large scale ERP data migration efforts.
• 5+ years of experience in managing and leading Oracle Fusion Cloud Data migration workstream - On-Premise Oracle E-Business and Oracle PeopleSoft to Oracle Fusion Cloud.
• At least ten (10) years of demonstrated experience leading ERP Data Migration activities.
• At least five (5) years of experience managing data migration activities for Oracle ERP Cloud Tech stack.
• Experience in Education (K-12) ERP Oracle Fusion Cloud Implementation, preferred.