Data Integration Engineer - Oracle Fusion HCM

CACI International•San Antonio, TX

3d•$93,500 - $196,500

About The Position

CACI is seeking a Data Integration Engineer to build and support integrations and data loads 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 and Oracle Cloud Infrastructure (OCI). The engineer builds interfaces that move personnel data between Fusion and other DoD systems, works independently on assigned integrations, and coordinates directly with partner system teams. Oracle Fusion Cloud HCM experience is preferred. The position is contingent upon contract award and funding and may not be filled immediately. The role involves hands-on integration engineering using Oracle Integration Cloud (OIC), Oracle Fusion HCM data tools, web services, and secure file transfer. The engineer supports development, conversion, testing, deployment, production monitoring, incident resolution, and quarterly release regression testing. The position requires an active Secret clearance to start and may require up to 25% travel within the continental United States. CACI describes a culture centered on integrity, character, innovation, and customer missions. Employees have a flexible time off benefit and access to learning resources. The company offers competitive compensation and benefits, including healthcare, wellness, financial, retirement, family support, continuing education, and time off benefits. The proposed salary range is $93,500–$196,500.

Requirements

Bachelor's degree and 7 years of relevant experience; additional experience may be substituted for the degree.
At least 4 years building enterprise integrations with Oracle Integration Cloud (OIC).
Experience with REST and SOAP web services, JSON, XML, XSLT, and secure file transfer.
Experience loading or extracting HR or ERP data in bulk.
Strong SQL skills.
Experience with integration testing and production support.
Strong written and verbal communication skills.
Active Secret clearance required to start.

Nice To Haves

At least 9 years of integration engineering experience.
Hands-on experience integrating with Oracle Fusion Cloud HCM.
Experience with HDL, HSDL, HCM Extracts, ATOM feeds, and HCM REST APIs.
Oracle Integration Cloud certification.
Experience with OCI services such as Object Storage, Vault, OCI GoldenGate, or OCI Data Integration.
Experience integrating with DoD systems such as the Defense Joint Military Pay System (DJMS) or the Defense Enrollment Eligibility Reporting System (DEERS).
Experience in a DevSecOps environment with source control and automated deployment.

Responsibilities

Build, test, and deploy Oracle Integration Cloud (OIC) integrations using REST and SOAP adapters, file-based interfaces, and scheduled orchestrations.
Develop outbound interfaces using HCM Extracts, BI Publisher, and HCM REST APIs, and inbound loads using HCM Data Loader (HDL) and HCM Spreadsheet Data Loader (HSDL).
Use ATOM feeds and event-based patterns to send personnel changes to downstream systems.
Build and test bidirectional data synchronization between Oracle Fusion Cloud HCM and legacy personnel systems during dual operation.
Implement error handling, retry logic, alerting, and reconciliation reports for integrations.
Protect data in transit and at rest through encryption, secure file transfer, and certificate-based authentication.
Write technical designs and interface control documents based on functional specifications.
Support data conversion loads and mock conversion cycles with the data conversion team.
Conduct integration testing with partner system teams and support end-to-end and user acceptance testing.
Regression test integrations for Oracle quarterly release updates.
Monitor production integrations and resolve incidents during hypercare and sustainment.
Participate in SAFe ceremonies, including sprint planning, backlog refinement, and demos.