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 strong 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.
Required Skills & Experience:
- 7+ years of total e