Oracle Cloud HCM Technical Data Conversion Specialist

Job Overview & Responsibilities

We are looking for a highly skilled Oracle Cloud HCM Technical Data Conversion Specialist to join our rapidly expanding SAAS Cloud practice. In this role, you will be responsible for the successful design, development, execution, and validation of data conversions from PeopleSoft and other legacy systems into Oracle Cloud HCM, Finance, and SCM. You will work closely with functional teams and clients to define data transformation strategies, automate loading processes, and ensure data integrity.

 

Key responsibilities include:

• Lead and oversee end-to-end data conversion processes for Oracle Cloud HCM, ensuring seamless migration from legacy systems.
• Design and develop PL/SQL queries, packages, stored procedures, and conversion scripts to load client data via HDL, HCM Extracts, and FBDI.
• Understanding of OIC-ATP, data mapping and translation to create FBDI file required to use KPMG conversion tool.
• Oversee data validation, reconciliation, and transformation mapping in collaboration with business and functional teams.
• Ensure error handling, logging mechanisms, and troubleshooting capabilities are in place for conversion failures.
• Manage seamless integration with PeopleSoft, Oracle DB custom applications, and third-party systems.
• Collaborate with testing teams to support unit testing, SIT, UAT, and post-go-live validation.
• Drive performance optimization of data conversion processes, ensuring efficiency and scalability.
• Provide leadership in troubleshooting and resolution of data migration issues throughout project phases.
• Support cutover planning and post-go-live hypercare to ensure smooth production adoption.

Qualifications

 

• Bachelor's degree and/or equivalent experience required.
• Must be a Greencard Holder or US Citizen.
• Must have a minimum of 10 years of work experience.

Technical Qualifications:

• Experience in implementing multiple full cycle Oracle HCM (ERP - Finance and SCM a plus) cloud with the latest version of Oracle fusion cloud.
• Strong hands-on experience in creating PLSQL query, packages, and Stored Procedure to develop conversion scripts to load Client provided DB queries, flat file in the specific format into HDL, HCM extracts and FBDI.
• Troubleshooting skills in Conversion development in pre-validation, data loading, loading errors and post validation process
• Experience in creating data validation and reconciliation scripts.
• Strong data mapping knowledge to work with business and functional team members.
• Understanding of the OIC-ATP, data mapping and translation to create FBDI file required to use KPMG conversion tool.
• Nice to have - Alteryx experience to use KPMG conversion template for HCM for the data mapping, translation to create HDL to load the data.
• Strong Oracle Cloud implementation experience

Management Qualifications:

• Effective communication skills to understand conversion process, overall Oracle conversion skills.
• Technical implementation knowledge and hands-on experience of Oracle Cloud HCM, Finance and SCM modules
• SDLC development cycle, code repository, code control and change control process.
• Consulting experience.
• Effective written and verbal communication with strong presentation experience.
• Excellent time management and organizational skills.
• Ability to work collaboratively in a project team.
• Ability to travel nationwide, up to 40%
• Public sector experience preferred.

Company Overview

As a federal government contractor and a recipient of federal funding, Mythics and Emergent is required to abide by the Drug-Free Workplace Act, which requires Mythics and Emergent to provide a drug-free workplace, among other obligations.  As part of this effort, Mythics and Emergent requires pre-employment drug tests for all candidates for employment.  Please note that marijuana (including medical marijuana) is designated as a controlled substance under federal law and will be screened for in the drug test.

Why work at Mythics?

Because at Mythics, YOU count! At Mythics, our Corporate Values are at the foundation of everything we do. Our values, Respect – Empathy – Excellence – Fun (REEF), have created an environment that fosters creative thinking, respects your contributions, and accepts nothing less than excellence in serving our customers.  At Mythics, you will experience a truly enjoyable corporate culture. But don’t just take our word for it! 

 

Enjoy Tailored Benefits to Suit Your Needs with our Flexible Options. Our benefit options include:  

• Co