Oracle EBS HRMS Expert

CACI International Inc

San Antonio (TX)

On-site

USD 120,000 - 170,000

Full time

3 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

CACI International Inc in San Antonio, TX seeks an Oracle EBS HRMS Expert to lead data conversion and dual operation for a DoD HR modernization program. You will extract, cleanse, and reconcile legacy personnel data while ensuring consistency with Oracle Fusion Cloud HCM.

The role requires deep knowledge of EBS HR data models, HDL/HSDL experience, and strong SQL/PLSQL skills. You will work with government data owners, participate in Agile ceremonies, and advise engineering teams on legacy

Qualifications

  • Bachelor's degree with 10 years of relevant experience; substitution allowed.
  • 8+ years technical experience with Oracle EBS HRMS/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 system migrations.
  • Experience reconciling converted data and resolving defects with functional teams.
  • Strong written and verbal communication skills.
  • Active Secret clearance to start.

Responsibilities

  • Analyze legacy EBS HRMS data structures and date-tracked history.
  • Document legacy customizations, interfaces, and reports for retirement or replacement.
  • Write and tune SQL/PL/SQL extracts of personnel data for conversion.
  • Profile legacy data, identify quality issues, and define cleansing rules.
  • Build source-to-target mappings from EBS to HDL objects.
  • Preserve date-effective history during conversion and reconcile counts/values.
  • Support data synchronization between legacy systems and Fusion Cloud HCM.
  • Support cutover data extracts, final reconciliation, and post-conversion validation.
  • Plan archival of legacy data and retirement of legacy components.
  • Advise integration and engineering teams on legacy Oracle behavior, performance, and security.
  • Document extract programs, mappings, and reconciliation results for Government review.
  • Participate in Agile ceremonies including PI Planning, sprint planning, and backlog refinement.

Skills

Strong written and verbal komunikasi
Active Secret clearance

Education

Bachelor's degree

Tools

Oracle EBS HRMS
SQL/PLSQL
HDL
HSDL
Oracle Fusion Cloud HCM
OCI Data Integration

Job description

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

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 ra

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Migration & Conversion Specialist
Data Migration & Conversion Specialist

CACI International Inc • United States

On-site
USD 120,000 - 160,000
Oracle Fusion Cloud HCM Functional (SME)
Oracle Fusion Cloud HCM Functional (SME)

CACI International Inc • United States

On-site
USD 170,000 - 250,000
Senior Oracle Fusion Cloud HCM Functional
Senior Oracle Fusion Cloud HCM Functional

CACI International Inc • United States

Remote
USD 105,000 - 231,000
Oracle HCM Lead Functional SME
Oracle HCM Lead Functional SME

CACI International Inc • San Antonio (TX)

On-site
USD 100,000 - 220,000
Senior HR Expert - Military Personnel Modernization
Senior HR Expert - Military Personnel Modernization

CACI International Inc • San Antonio (TX)

On-site
USD 100,000 - 220,000
Oracle Cloud Solution Architect
Oracle Cloud Solution Architect

CACI International Inc • United States

On-site
USD 150,000 - 210,000
Data Integration Engineer - Oracle Fusion HCM
Data Integration Engineer - Oracle Fusion HCM

CACI International Inc • San Antonio (TX)

On-site
USD 94,000 - 197,000
Transition Manager - Oracle HCM Modernization
Transition Manager - Oracle HCM Modernization

CACI International Inc • San Antonio (TX)

On-site
USD 120,000 - 180,000
HCM Analytics & BI Developer
HCM Analytics & BI Developer

CACI International • United States

Remote
USD 75,000 - 158,000
HCM Test Automation, Quality Engineer
HCM Test Automation, Quality Engineer

Software Testing Notes • United States

Remote
USD 90,000 - 190,000