Integration, Report Developer

This is a fully remote position, open to applicants in District of Columbia, +1 more state.

📋 Description

• Create comprehensive integrations utilizing Oracle Integration Cloud (OIC).

• Develop both real-time and batch interfaces linking Oracle ERP with external systems.

• Execute message transformations, mapping logic, fault management, and structured logging.

• Generate BI Publisher (BIP) reports, data models, templates, bursting logic, and scheduled report integrations.

• Design OTBI analyses, dashboards, and subject-area extensions for effective reporting.

• Craft custom SQL queries, PL/SQL packages, and views.

• Ensure the validation of integrations and reports throughout SIT, UAT, and production deployment phases.

• Diagnose integration failures and resolve reporting discrepancies.

• Work collaboratively with functional and technical teams to enhance requirements.

⛳️ Requirements

• Practical experience with Oracle Integration Cloud (OIC) or Oracle SOA Suite.

• Expertise in SQL, PL/SQL, XML, JSON, REST/SOAP, and file-based data interchange.

• Background in developing BIP and OTBI reports, data models, and bespoke extraction logic.

• Solid comprehension of Oracle Cloud ERP modules (Finance, SCM, HCM) and associated business processes.

• Capability to analyze requirements and translate them into scalable technical designs.

🏝️ Benefits

• Health insurance

• 401(k) matching

• Flexible work hours

• Paid time off

• Remote work options