Oracle EBS HRMS Expert

CACI International•San Antonio, TX

1d•$99,800 - $219,600

About The Position

CACI is seeking an Oracle E-Business Suite (EBS) HRMS Expert to support data conversion and dual operation for an anticipated Department of the Air Force human resources modernization program. The program would move military personnel processes from legacy systems, including the Military Personnel Data System (MilPDS), to Oracle Fusion Cloud HCM hosted on Oracle Cloud Infrastructure (OCI). Legacy personnel environments may include Oracle EBS HRMS components and custom extensions. The expert will use knowledge of the EBS HR data model to extract, cleanse, and reconcile legacy personnel data and help keep legacy and Oracle Fusion Cloud HCM data consistent while both systems operate. The role serves as the technical authority for legacy Oracle HR data and advises data, integration, and engineering teams. Oracle Fusion Cloud HCM experience, particularly with HCM Data Loader, is a strong plus. The position is contingent upon contract award and funding and may not be filled immediately. The position requires an active Secret clearance to start and up to 25% travel within the continental United States.

Requirements

Bachelor's degree and 10 years of relevant experience; additional experience may substitute for the degree.
At least 8 years of technical experience with Oracle E-Business Suite HRMS or HCM, including the HR data model.
Advanced SQL and PL/SQL skills on Oracle Database.
Experience with date-tracked HR data and EBS flexfields.
Experience extracting and converting HR data for at least one system migration.
Experience reconciling converted data and resolving defects with functional teams.
Strong written and verbal communication skills.
Active Secret clearance required to start.

Nice To Haves

12 or more years of Oracle EBS technical experience.
Experience loading data to Oracle Fusion Cloud HCM with HDL or HCM Spreadsheet Data Loader (HSDL).
Experience with Oracle Integration Cloud, OCI GoldenGate, or OCI Data Integration.
Experience with DoD or federal HR data, such as military personnel or Defense Civilian Personnel Data System (DCPDS) data.
Oracle Database or Oracle EBS certification.
Experience planning legacy data archival and system decommissioning.
Experience in an Agile delivery environment.

Responsibilities

Analyze legacy Oracle EBS HRMS data structures, including date-tracked history, flexfields, and custom tables.
Document legacy customizations, extensions, interfaces, and reports, and assess whether each should be retired, replaced with standard Oracle Fusion Cloud HCM functionality, or rebuilt.
Write and tune SQL and PL/SQL extracts of personnel data for conversion.
Profile legacy data, identify quality issues, and define cleansing rules with Government data owners.
Build source-to-target mappings from EBS structures to HCM Data Loader (HDL) business objects.
Preserve date-effective history during conversion and reconcile record counts and values between source and target during each mock conversion cycle.
Support the design of data synchronization between legacy systems and Oracle Fusion Cloud HCM during dual operation.
Support cutover data extracts, final reconciliation, and post-conversion validation.
Plan archival of legacy data and retirement of legacy components after transition.
Advise integration and engineering teams on legacy Oracle database behavior, performance, and security.
Document extract programs, mappings, and reconciliation results for Government review.
Participate in Agile ceremonies, including Program Increment (PI) Planning, sprint planning, and backlog refinement.