Oracle Cloud Integrations & Reporting Engineer

Accenture-Federal-Services-2; Arlington (VA); On-site; USD 86,000 - 176,000; Full time

Job summary

Accenture Federal Services is seeking an Integration/Report Developer to design, build, test and support Oracle Cloud ERP integrations and reporting solutions. The role focuses on high‑quality interfaces using OIC, REST/SOAP, BIP, OTBI, and PaaS technologies across Finance, SCM, and HCM modules.

You will develop real‑time and batch interfaces, implement transformations, and create BI Publisher reports and OTBI analyses, ensuring data accuracy and scalable designs. Must be a U.S. citizen.

Qualifications

• Hands‑on experience with Oracle Integration Cloud (OIC) or Oracle SOA Suite.
• Proficiency in SQL, PL/SQL, XML, JSON, REST/SOAP, and file‑based data exchange.
• Experience developing BIP and OTBI reports, data models, and custom extraction logic.
• Strong understanding of Oracle Cloud ERP modules (Finance, SCM, HCM) and related business processes.
• Ability to analyze requirements and convert them into scalable technical designs.

Responsibilities

• Develop end‑to‑end integrations using Oracle Integration Cloud (OIC), including REST adapters, SOAP adapters, FTP/SFTP, file‑based integrations (FBDI), and orchestration flows.
• Build real‑time and batch interfaces between Oracle ERP and external systems (legacy databases, partner applications, cloud platforms).
• Implement message transformations, mapping logic, fault handling, and structured logging aligned to enterprise integration standards.
• Build BI Publisher (BIP) reports, data models, templates, bursting logic, and scheduled report integrations.
• Develop OTBI analyses, dashboards, and subject‑area extensions for operational and financial reporting.
• Write custom SQL queries, PL/SQL packages, views, and materialized views for reporting or data‑service consumption.
• Validate integrations and reports through SIT, UAT, and production deployment cycles.
• Troubleshoot integration failures and reporting discrepancies, ensuring end‑to‑end accuracy and traceability.
• Collaborate with functional and technical teams to refine requirements and transform them into scalable technical designs.

Skills

Oracle Integration Cloud

SQL

PL/SQL

REST/SOAP

BI Publisher

OTBI

Oracle Cloud ERP

Data integration

Tools

OIC

Oracle SOA Suite

BI Publisher (BIP)

OTBI

Job description

Accenture Federal Services is seeking an Integration/Report Developer to design, build, test and support Oracle Cloud ERP integrations and reporting solutions. The role focuses on high‑quality interfaces using OIC, REST/SOAP, BIP, OTBI, and PaaS technologies across Finance, SCM, and HCM modules.

You will develop real‑time and batch interfaces, implement transformations, and create BI Publisher reports and OTBI analyses, ensuring data accuracy and scalable designs. Must be a U.S. citizen.