Oracle EBS HRMS Expert
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 MilPDS, to Oracle Fusion Cloud HCM hosted on Oracle Cloud Infrastructure. Legacy personnel environments may include Oracle EBS HRMS components and custom extensions. The expert uses knowledge of the EBS HR data model to extract, cleanse, and reconcile legacy personnel data, and to keep legacy and Oracle Fusion Cloud HCM data consistent while both systems operate. The role provides 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.
Requirements
- Bachelor's degree and 10 years of relevant experience; additional experience may be substituted 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
- At least 12 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 to retire, replace, or rebuild them.
- 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 source and target record counts and values in 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 legacy data archival 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.
Benefits
- Flexible time off benefit.
- Learning resources and learning and development opportunities.
- Healthcare and wellness benefits.
- Financial and retirement benefits.
- Family support benefits.
- Continuing education benefits.
- Time off benefits.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
