Job Title: Data Integration Engineer - Oracle Fusion HCM
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 a Data Integration Engineer to build integrations and data loads 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 and Oracle Cloud Infrastructure (OCI). The Data Integration Engineer builds and supports the interfaces that move personnel data between Fusion and other DoD systems. The engineer works independently on assigned integrations and coordinates directly with partner system teams. We are hiring for hands-on integration engineering. Oracle Fusion Cloud HCM experience is preferred. This position is contingent upon contract award.
Responsibilities
- Build, test, and deploy integrations in Oracle Integration Cloud (OIC) using REST and SOAP adapters, file-based interfaces, and scheduled orchestrations
- Develop outbound interfaces with HCM Extracts, BI Publisher, and HCM REST APIs, and inbound loads with 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 each integration
- Protect data in transit and at rest with encryption, secure file transfer, and certificate-based authentication
- Write technical designs and interface control documents from functional specifications
- Support data conversion loads and mock conversion cycles with the data conversion team
- Run 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 Scaled Agile Framework (SAFe) ceremonies, including sprint planning, backlog refinement, and demos
Show the full description
Qualifications
Required
- Bachelor's degree and 7 years of relevant experience. Additional experience may be substituted for degree.
- 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 to start
- Desired:
- 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