Job Description: Oracle Fusion BI & Integration Consultant
Experience: 7+ Years
Work Location: Open (Hybrid/Remote based on project requirement)
Number of Positions: 1
Mandatory Skills:
Oracle Fusion BI
Oracle PL/SQL
Oracle APEX (Minimum 3 years of experience)
Oracle Integration Cloud (OIC) (Minimum 2 years of experience)
Job Summary:
We are looking for an experienced Oracle Fusion BI & Integration Consultant to join our energetic team. The ideal candidate should have solid expertise in Oracle BI reporting, PL/SQL development, Oracle APEX applications, and Oracle Integration Cloud (OIC) for seamless integrations across Oracle Cloud Applications and third-party systems.
Key Responsibilities:
Oracle Fusion BI:
Design, develop, and customize BI Publisher reports and dashboards in Oracle Fusion Cloud.
Expertise in OTBI (Oracle Transactional Business Intelligence) reporting.
Create custom data models and complex reports as per business requirements.
Work closely with functional teams to understand reporting needs and deliver high-performance BI solutions.
Oracle PL/SQL Development:
Design and develop complex PL/SQL procedures, functions, packages, triggers, and scripts.
Optimize and fine-tune PL/SQL queries for improved performance.
Perform data extraction, transformation, and loading (ETL) using PL/SQL.
Oracle APEX:
Design and develop low-code web applications using Oracle APEX.
Create interactive reports, dashboards, and user-friendly applications.
Maintain and enhance existing Oracle APEX applications.
Ensure APEX applications are optimized, responsive, and secure.
Oracle Integration Cloud (OIC):
Design and develop integrations using OIC (Application Integration, Process Automation, and Visual Builder).
Integrate Oracle Fusion Cloud Applications with on-premise and third-party systems.
Develop REST & SOAP-based integrations.
Monitor and troubleshoot integration issues.