Integration/Report Developer

Summary

Accenture Federal Services is dedicated to helping the US federal government enhance its operations and services. They are seeking an Integration/Report Developer to design, build, test, and support technical integrations and reporting solutions for Oracle Cloud ERP, ensuring system interoperability and optimized reporting across various business processes.

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

• 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
• Must be a U.S. Citizen

Qualifications

Must Haves

• 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
• Must be a U.S. Citizen