Oracle Integration & Reporting Developer
Posted Today by Apetan Consulting
Negotiable
Undetermined
Remote
Remote or New Jersey
Summary: The Oracle Integration & Reporting Developer is responsible for designing, developing, and maintaining integrations and reports using Oracle technologies, specifically Oracle Service Bus (OSB), Oracle Integration Cloud (OIC), and Oracle BI Publisher (BIP). The role involves collaborating with various stakeholders to ensure seamless data flows and effective reporting, while also providing support during testing and deployment phases. The developer will also mentor junior team members and adhere to enterprise standards for security and error handling. Strong experience in the telecommunications industry and SQL is essential for success in this position.
Key Responsibilities:
- Design, develop, and maintain real-time and batch integrations using Oracle Service Bus (OSB) and Oracle Integration Cloud (OIC).
- Build integrations between Oracle ERP Cloud and Telecom OSS/BSS platforms, network inventory systems, logistics partners, and external vendors.
- Develop and consume REST/SOAP APIs, FTP/SFTP, and event-based integrations.
- Design and develop BI Publisher (BIP) reports and documents, including operational and transactional reports.
- Support system integration testing (SIT) and user acceptance testing (UAT) by executing test scenarios and analyzing failures.
- Support cutover and go-live activities, including migration of integrations and reports.
- Work closely with functional consultants and telecom business SMEs to resolve data and process issues.
- Contribute to technical documentation and mentor junior developers.
Key Skills:
- 7+ years of experience in Oracle middleware and reporting development.
- Strong hands-on experience with Oracle Service Bus (OSB), Oracle Integration Cloud (OIC), and Oracle BI Publisher (BIP).
- Proven experience integrating Oracle ERP Cloud with external systems.
- Strong SQL and data analysis skills.
- Experience in the telecommunications industry.
- Hands-on experience supporting SIT, UAT, and production deployments.
- Strong troubleshooting and root-cause analysis skills.
- Familiarity with Agile or hybrid delivery methodologies.
Salary (Rate): undetermined
City: undetermined
Country: undetermined
Working Arrangements: remote
IR35 Status: undetermined
Seniority Level: undetermined
Industry: IT
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.