Oracle EPM Integration Lead

About the role

CACI is seeking an Oracle EPM Integration Lead with DoD/Federal Oracle ERP implementation experience. The role sits in an Oracle EBS R12 Department of War (DoW) multi-customer solution, involves direct customer interaction and leads the execution of program goals. It is a fast-paced, full-time position working remotely, with no travel required.

Key responsibilities

• Lead the assessment, documentation and re-architecture of the legacy ETL integration layer connecting Oracle EBS to Oracle Cloud EPM.
• Design and implement a modern integration architecture using Oracle Data Management, EPM Automate and an ETL tool (Databricks or an Oracle-native equivalent).
• Own the end-to-end data flow: metadata governance through EDM, transactional actuals through Data Management, and reporting outputs through OAS/OAC.
• Resolve the structural BSS/EPM hierarchy mismatch causing parent-level OAS reporting failures.
• Drive EDM implementation as the metadata governance hub.
• Set up dependency management, job monitoring, alerting and error handling across agency data loads.
• Work with agency technical leads, the DBA team and Oracle Support on infrastructure issues.
• Produce and present program documentation and briefings to PMO leadership.

Required profile

• Bachelor's degree or equivalent.
• 10+ years in enterprise application integration, including 5+ years in the Oracle ecosystem.
• 5+ years of DoD/Federal financials and sustainment experience.
• Hands-on Oracle integration expertise, able to architect and build, not just advise.
• Experience as a solution architect implementing and supporting complex Oracle EPM solutions.
• U.S. citizen able to obtain an IT II background investigation.

Required skills

• Oracle Data Management (EDM/DRM) and Oracle EPM Automate.
• Oracle EBS integration and Oracle Analytics Server / OBIEE.
• JDBC, REST/SOAP APIs, Unix/Linux scripting, SQL/PLSQL.
• ETL tools such as Databricks, ODI or Informatica.
• Ability to read, maintain and modernize legacy scripts and PL/SQL packages.
• Desired: Oracle Cloud EPM Planning, Groovy scripting, OCI, DoD financial programs, PPBE budget cycles and DoW SDLC.

What we offer

• Proposed pay range of $82,100-$172,400, depending on location, experience and skills.
• Healthcare, wellness, financial, retirement, family support, continuing education and time off benefits.
• A flexible time off benefit and learning resources.