Oracle EBS HRMS Expert

About the role

• Job Title: Oracle EBS HRMS Expert
• Job Category: Information Technology
• Time Type: Full time
• Minimum Clearance Required to Start: Secret
• Employee Type: Regular
• Percentage of Travel Required: Up to 25%
• Type of Travel: Continental US

The Opportunity

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 (DAF) 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 EBS HRMS 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 run. The role carries technical authority for legacy Oracle HR data and advises the data, integration, and engineering teams.

We are hiring for Oracle EBS HRMS technical depth. Oracle Fusion Cloud HCM experience, especially with HCM Data Loader, is a strong plus. This position is contingent upon contract award.

Responsibilities

• Analyze legacy Oracle EBS HRMS data structures, along with date-tracked history, flexfields, and custom tables
• Document legacy customizations, extensions, interfaces, and reports, and assess each for retirement, replacement by standard Oracle Fusion Cloud HCM functionality, or rebuild
• 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 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 the archival of legacy data and the retirement of legacy components after transition
• Advise the 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

Qualifications

Required

• Bachelor's degree and 10 years of relevant experience. Additional experience may be substituted for degree.
• 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 to start

Desired

• 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

Additional information

This position is contingent on funding and may not be filled immediately. However, this position is representative of positions within CACI that are consistently available. Individuals who apply may also be considered for other positions at CACI.

What You Can Expect: A culture of integrity.

At CACI, we place character and innovation at the center of everything we do. As a valued team member, you'll be part of a high-performing group dedicated to our customer's missions and driven by a higher purpose - to ensure the safety of our nation.

An environment of trust.

CACI values the unique contributions that every employee brings to our company and our customers - every day. You'll have the autonomy to take the time you need through a unique flexible time off benefit and have access to robust learning resources to make your ambitions a reality.

A focus on continuous growth.

Together, we will advance our nation's most critical missions, build on our lengthy track record of business success, and find opportunities to break new ground - in your career and in our legacy.

Pay Range

There are a host of factors that can influence final salary including, but not limited to, geographic location, Federal Government contract labor categories and contract wage rates, relevant prior work experience, specific skills and competencies, education, and certifications. Our employees value the flexibility at CACI that allows them to balance quality work and their personal lives.

We offer competitive compensation, benefits and learning and development opportunities. Our broad and competitive mix of benefits options is designed to support and protect employees and their families. At CACI, you will receive comprehensive benefits such as; healthcare, wellness, financial, retirement, family support, continuing education, and time off benefits.

The proposed salary range for this position is

$99,800 - $219,600