Senior Oracle Integration & Reporting Developer; Seattle-WA​/Dallas -TX

Position: Senior Oracle Integration & Reporting Developer (Seattle-WA/ Dallas -TX )

Job Title

Senior Oracle Integration & Reporting Developer (OSB / OIC / BIP)

Location

Seattle-WA/ Dallas
-TX
- Travel from Monday
- Thursday

Duration

3 month Contract

No H1B

No H1B

Contract

Contract

Senior Integration & Reporting Developer Oracle OSB / OIC / BIP for a 3 month Project. If you are available for a new project, please send your updated resume with best time and number to connect.

Role Summary

We are seeking a Senior Integration & Reporting Developer with strong hands‑on expertise in Oracle Service Bus (OSB), Oracle Integration Cloud (OIC), and Oracle BI Publisher (BIP) to support a large‑scale telecommunications ERP transformation program.

The role focuses on designing, developing, testing, and supporting integrations and reports across Oracle ERP Cloud and telecom enterprise systems, with deep involvement in System Integration Testing (SIT), User Acceptance Testing (UAT), and deployment activities.

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
• Providing technical explanations of integration and reporting behavior to business stakeholders
• Ensuring 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
• Providing post‑go‑live hyper‑care, monitoring interfaces and reports
• Proactively identifying and remediating 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
• Contributing to technical documentation and knowledge transfer
• Mentoring junior developers and supporting delivery excellence

Required Qualifications 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

Preferred Qualifications

• Experience with Oracle Integration Insight or OCI Streaming / Events
• Knowledge of ERP Cloud events and business events
• Oracle certifications in Integration Cloud, BI Publisher
• Experience with telecom ERP transformations or large ERP Cloud rollouts

Navya Gupta Sr. IT Technical Recruiter

#J-18808-Ljbffr