Oracle OTBI Consultant (Remote + Travel Required to VA)

Job Title: Oracle OTBI Consultant

Job Type: Contract

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

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.