Oracle Fusion Technical Consultant

Job Description: We are looking for an experienced Oracle Fusion Technical Consultant with strong expertise in Oracle Fusion Cloud technical development, BI Publisher (BIP), OTBI, SQL, and reporting. The candidate should have hands-on experience in developing reports, integrations, and technical customizations within Oracle Fusion Applications.

Required Skills

Strong experience in Oracle Fusion Technical development. Hands-on experience with BI Publisher (BIP) report development. Experience in developing OTBI (Oracle Transactional Business Intelligence) analyses and dashboards. Expertise in SQL, PL/SQL, and Oracle Database. Experience with BIP Data Models, RTF templates, Excel templates, and bursting.

Knowledge of Fusion Security Roles and Data Security. Experience with Oracle Fusion Web Services (SOAP/REST APIs). Hands-on experience with File-Based Data Import (FBDI) and HDL/HSDL (preferred). Experience with Oracle Integration Cloud (OIC) is an added advantage. Good understanding of Fusion Business Objects and reporting architecture.

Experience in troubleshooting report performance and data issues. Excellent analytical and communication skills. Roles & Responsibilities: Design and develop BI Publisher reports and data models. Develop OTBI reports, dashboards, and analyses. Create SQL queries and optimize report performance. Develop custom technical solutions based on business requirements.

Work with functional consultants to gather reporting requirements. Develop and support Fusion integrations using REST/SOAP services. Perform unit testing, deployment, and production support. Prepare technical design documents and maintain technical artifacts. Resolve production issues related to reports and technical objects.

Nice to Have

Oracle Integration Cloud (OIC) FBDI/HDL Visual Builder Studio (VBS) Oracle Analytics Cloud (OAC) XML Publisher ADF knowledge (preferred) Mandatory Skills: Oracle Fusion Technical BI Publisher (BIP) OTBI SQL Oracle Fusion Reports REST/SOAP APIs