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.
- Excellent Communication & Presentation Skills.
- Strong Analytical & Problem-solving ability.
- Flexible to work in client-facing roles.
- Strong team player with proactive approach.