Oracle Cloud Integration & Reporting Engineer

Socket.dev; Washington (District of Columbia); 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 technical integrations and reporting solutions for Oracle Cloud ERP (OIC, REST/SOAP, BIP, OTBI). You will ensure data accuracy and interoperability across Finance, SCM, HCM, and business processes.

The role focuses on scalable interfaces, real-time and batch data exchanges, and end-to-end reporting with strong SQL/PL/SQL expertise. Must be a U.S.

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 (OIC)

Oracle SOA Suite

SQL

PL/SQL

XML

JSON

REST/SOAP

BI Publisher (BIP)

OTBI

Job description

Accenture Federal Services is seeking an Integration/Report Developer to design, build, test, and support technical integrations and reporting solutions for Oracle Cloud ERP (OIC, REST/SOAP, BIP, OTBI). You will ensure data accuracy and interoperability across Finance, SCM, HCM, and business processes.

The role focuses on scalable interfaces, real-time and batch data exchanges, and end-to-end reporting with strong SQL/PL/SQL expertise. Must be a U.S.