Note: The job is a remote job and is open to candidates in USA. STAFFXPERT is seeking an experienced Oracle OTBI Consultant / BI Publisher Reports Developer. The role designs, develops, enhances, optimizes, and supports enterprise reporting solutions across Oracle Fusion Cloud ERP and Oracle EBS R12, with responsibilities spanning reporting, SQL/PLSQL development, security, integrations, troubleshooting, documentation, and production support.
Responsibilities
- Develop and maintain reports using Oracle Fusion OTBI and BI Publisher
- Design and develop BI Publisher/XML Publisher reports and templates
- Build reporting solutions across GL, AP, AR, Procurement, and related Oracle ERP modules
- Develop and optimize complex Oracle SQL queries for reporting and data extraction
- Perform SQL/database performance tuning
- Develop and maintain PL/SQL packages, procedures, functions, and triggers
- Support database objects/packages utilized by Oracle Integration Cloud (OIC) interfaces
- Develop and maintain reporting solutions within Oracle EBS R12
- Work with Fusion Analytics Warehouse (FAW) when applicable
- Configure and support Fusion reporting security, including roles and data access sets
- Troubleshoot reporting, SQL, PL/SQL, and production issues
- Implement data validation, exception handling, and data-integrity controls
- Gather requirements from functional/business teams and translate them into technical reporting solutions
- Prepare technical documentation and provide ongoing production support
- Collaborate with functional consultants, developers, business stakeholders, and project teams
Skills
- Experienced Oracle OTBI Consultant / BI Publisher Reports Developer with strong hands-on experience in Oracle Fusion Cloud ERP, OTBI, BI Publisher, XML Publisher, Oracle SQL, PL/SQL, and Oracle EBS R12
- 2 consecutive weeks onsite at the client warehouse every month until project completion
- Oracle Fusion Cloud ERP Reporting
- OTBI – Mandatory
- BI Publisher – Mandatory
- XML Publisher
- Fusion Analytics Warehouse (FAW)
- Oracle SQL – Strong
- Oracle PL/SQL – Strong
- Complex SQL queries
- SQL optimization/performance tuning
- PL/SQL Packages
- Procedures
- Functions
- Triggers
- Oracle Fusion Cloud ERP
- Oracle EBS R12
- General Ledger ( GL )
- Accounts Payable ( AP )
- Accounts Receivable ( AR )
- Procurement
- Fusion Reporting Security
- Roles and Data Access Sets
- Oracle Integration Cloud ( OIC )
- Database packages supporting OIC interfaces
- Data validation and exception handling
Benefits
- Remote work arrangement with 2 consecutive weeks onsite at the client warehouse every month until project completion
Company Overview