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 dynamic 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 experience in Oracle technology stack.
• Expert in Oracle Fusion BI reporting tools.
• Strong proficiency in Oracle PL/SQL development.
• Minimum 3 years of hands-on experience in Oracle APEX development.
• Minimum 2 years of hands-on experience with Oracle Integration Cloud (OIC).
• Strong knowledge of Oracle Fusion Cloud Data Model and Architecture.
• Good understanding of Oracle ERP, HCM, or SCM modules is a plus.
• Strong analytical, problem-solving, and communication skills.
• Ability to work independently and collaboratively in a fast-paced environment.

Preferred Certifications (Good to Have):

• Oracle BI Publisher Certification
• Oracle APEX Developer Certification
• Oracle Integration Cloud Certification
• Oracle PL/SQL Developer Certified Associate

Soft Skills:

• Excellent Communication & Presentation Skills.
• Strong Analytical & Problem-solving ability.
• Flexible to work in client-facing roles.
• Strong team player with proactive approach.