Oracle Integration & Reporting Developer

Overview

Remote
Full Time
Part Time
Accepts corp to corp applications
Contract - Independent
Contract - W2
Contract - 12 month(s)

Skills

7+ years of experience in Oracle middleware and reporting development. Strong hands-on experience with: Oracle Service Bus (OSB) Oracle Integration Cloud (OIC) Oracle BI Publisher (BIP)

Job Details

Key Responsibilities:

Integration Design & Development (OSB / OIC)

Design, develop, and maintain real-time and batch integrations using:

Oracle Service Bus (OSB)

Oracle Integration Cloud (OIC)

Build integrations between Oracle ERP Cloud (SCM, Financials) and:

Telecom OSS/BSS platforms

Network inventory systems

Logistics partners and 3PLs

External vendors and suppliers

Develop and consume REST/SOAP APIs, FTP/SFTP, and event-based integrations.

Implement canonical data models, error handling, logging, and reprocessing mechanisms.

Reporting & Document Development (BIP)

Design and develop BI Publisher (BIP) reports and documents, including:

Operational and transactional reports

Integration control and reconciliation reports

Business documents (invoices, POs, ASN, shipping docs)

Develop and optimize SQL queries against Oracle Fusion tables and views.

Support bursting, scheduling, and distribution of reports.

Troubleshoot BIP performance, data issues, and formatting defects.

System Integration Testing (SIT)

Support SIT planning, execution, and defect resolution for integrations and reports.

Validate end-to-end data flows across ERP, middleware, and telecom systems.

Analyze logs, payloads, and error messages across OSB, OIC, and ERP.

Collaborate with functional consultants to resolve data and process issues.

User Acceptance Testing (UAT)

Support business users during UAT by:

Executing test scenarios

Analyzing failures and root causes

Fixing defects and supporting retesting

Provide technical explanations of integration and reporting behavior to business stakeholders.

Ensure UAT readiness and successful sign-off.

Deployment & Production Support

Support cutover and go-live activities, including:

Migration of integrations and reports

Environment configuration and validation

Production smoke testing

Provide post-go-live hypercare, monitoring interfaces and reports.

Proactively identify and remediate performance or stability issues.

Governance & Collaboration

Work closely with:

Functional SCM and Finance consultants

Telecom business SMEs

ERP Cloud and infrastructure teams

Follow enterprise standards for:

Security

Error handling

Logging and monitoring

Contribute to technical documentation and knowledge transfer.

Mentor junior developers and support delivery excellence.

Technical Experience:

7+ years of experience in Oracle middleware and reporting development.

Strong hands-on experience with:

Oracle Service Bus (OSB)

Oracle Integration Cloud (OIC)

Oracle BI Publisher (BIP)

Proven experience integrating Oracle ERP Cloud with external systems.

Strong SQL and data analysis skills (Fusion schema familiarity preferred).

Telecommunications Industry Experience

Prior experience working with telecommunications providers or high-volume transaction environments.

Understanding of:

OSS/BSS system integrations

Network provisioning and fulfillment flows

High-throughput, near-real-time integrations

Experience supporting mission-critical interfaces is a strong plus.

Testing & Delivery Skills

Hands-on experience supporting SIT, UAT, and production deployments.

Strong troubleshooting and root-cause analysis skills.

Experience working in large, multi-vendor SI programs.

Familiarity with Agile or hybrid delivery methodologies.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.