Oracle OTBI Consultant

Apton Inc

United States

17 days ago

Apply on www.dice.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Working hours

Regular working hours

Job source

www.dice.com

Tech stack

Data Analysis Cloud Computing Data Validation Data Integrity Data Security Data Structures Database Schema Oracle (Applications) Oracle SQL Developer Performance Tuning PL-SQL Oracle Fusion Middleware

+6 more

Bi Publisher Netsuite Erp Xml Publisher Oracle Ebusiness Oracle Erp Oracle Integration

Job description

Location: Remote + traveling to a client warehouse for two consecutive weeks every month until the project is completed.

Requirements

Job Summary We are looking for an experienced Oracle BI Publisher Reports Developer / PL/SQL Engineer with robust expertise in Oracle Fusion Cloud ERP, Oracle E-Business Suite R12, BI Publisher, OTBI, XML Publisher, and Oracle PL/SQL.

The candidate will be responsible for designing, developing, optimizing, and supporting enterprise reporting solutions across GL, AP, AR, Procurement, and other Oracle ERP modules.

Must-Have Skills Strong experience in Oracle Fusion Cloud ERP reporting, including OTBI, BI Publisher, and reporting security such as roles and data access sets. Hands-on experience with Oracle E-Business Suite R12 reporting, preferably using BI Publisher/XML Publisher.

Solid knowledge of Oracle PL/SQL, XML Publisher, and BI Publisher. Ability to design and develop XML Publisher and BI Publisher templates. Experience working with functional teams to gather requirements and deliver technical solutions for GL, AP, and AR. Robust SQL skills with experience in query development, optimization, and performance tuning.

Experience developing and maintaining PL/SQL packages, procedures, functions, and triggers, including packages supporting Oracle Integration Cloud interfaces.

Strong understanding of Oracle GL, AP, and AR tables and data structures.

Experience implementing data validation, error handling, data integrity, and performance tuning in PL/SQL solutions.

Ability to prepare technical documentation and provide production support for reports and database objects.

Excellent communication and stakeholder management skills.

Key Responsibilities 1. Oracle Fusion & EBS Reporting Design, develop, enhance, and optimize reports using Oracle Fusion OTBI and BI Publisher. Work with Fusion Analytics Warehouse (FAW) where applicable.