Oracle Integration & Reporting Specialist

Accenture Federal Services; Washington (District of Columbia); On-site; USD 86,400 - 176,200; Full time

Job summary

Accenture Federal Services in Washington, DC is seeking an Integration/Report Developer to design, build, test, and support Oracle Cloud ERP integrations and reporting solutions. You will create scalable interfaces using OIC, REST/SOAP, BIP, OTBI, and PaaS technologies to ensure data accuracy across Finance, SCM, and HCM.

You will develop end-to-end integrations, BI reports, and OTBI analyses while collaborating with cross-functional teams to meet enterprise standards and project timelines.

Qualifications

• Hands-on experience with Oracle Integration Cloud (OIC) and 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 extraction logic.
• Strong knowledge of Oracle Cloud ERP modules (Finance, SCM, HCM).
• Ability to analyze requirements and translate 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/PLSQL

XML/JSON

REST/SOAP

BIP/OTBI reporting

Oracle Cloud ERP modules

Requirements analysis

Tools

Oracle SOA Suite

BIP

OTBI

Job description

Accenture Federal Services in Washington, DC is seeking an Integration/Report Developer to design, build, test, and support Oracle Cloud ERP integrations and reporting solutions. You will create scalable interfaces using OIC, REST/SOAP, BIP, OTBI, and PaaS technologies to ensure data accuracy across Finance, SCM, and HCM.

You will develop end-to-end integrations, BI reports, and OTBI analyses while collaborating with cross-functional teams to meet enterprise standards and project timelines.