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 thirdparty 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 highperformance BI solutions.
Oracle PL/SQL Development:
- Design and develop complex PL/SQL procedures functions packages triggers and scripts.
- Optimize and finetune PL/SQL queries for improved performance.
- Perform data extraction transformation and loading (ETL) using PL/SQL.
Oracle APEX:
- Design and develop lowcode web applications using Oracle APEX.
- Create interactive reports dashboards and userfriendly 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 onpremise and thirdparty systems.
- Develop REST & SOAPbased 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 handson experience in Oracle APEX development.
- Minimum 2 years of handson 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 problemsolving and communication skills.
- Ability to work independently and collaboratively in a fastpaced 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 & Problemsolving ability.
- Flexible to work in clientfacing roles.
- Strong team player with proactive approach.