Oracle BI & Integration Consultant (BI / OIC)

Experience Range:

6 -9 years of relevant experience. 

Job Summary:

We are looking for a skilled Oracle BI & Integration Consultant with strong experience in Business Intelligence (BI) and Oracle Integration Cloud (OIC), along with working knowledge of BI Cloud Connector (BICC). The ideal candidate will be responsible for designing, developing, and supporting analytics and integration solutions across Oracle Cloud and enterprise systems.

Key Responsibilities:

Business Intelligence (Approx. 60%)

• Design, develop, and maintain BI reports, dashboards, and analytics solutions.
  

• Work with business stakeholders to gather reporting and analytical requirements.
  

• Build and optimize data models, subject areas, and semantic layers.
  

• Perform data validation, reconciliation, and performance tuning.
  

• Support enhancements, bug fixes, and production issues related to BI solutions.
  

Oracle Integration Cloud (Approx. 40%)

• Design and develop integrations using Oracle Integration Cloud (OIC).
  

• Build and manage integrations between Oracle SaaS applications and external systems.
  

• Create and maintain integrations using REST/SOAP services, adapters, and schedules.
  

• Handle error handling, tracking, and monitoring of integrations.
  

• Support deployment, versioning, and environment migrations.
  

BI Cloud Connector (BICC)

• Understand BICC architecture, concepts, and data extraction framework.
  

• Configure and execute data extracts from Oracle Cloud applications using BICC.
  

• Monitor BICC jobs and troubleshoot extraction issues.
  

• Collaborate with BI and integration teams to ensure accurate data loads.
  

Requirements

Required Skills & Qualifications:

• Strong hands -on experience in Oracle BI / Analytics solutions.
  

• Solid experience in Oracle Integration Cloud (OIC) development.
  

• Practical exposure to BICC concepts with prior implementation or support experience.
  

• Good understanding of data warehousing, ETL concepts, and reporting frameworks.
  

• Experience working with REST/SOAP APIs and integration patterns.
  

• Strong SQL skills and data analysis capabilities.
  

• Excellent communication and stakeholder interaction skills.
  

• Expertise on Oracle Financial module (i.e.
  Development of BI report of Finance module; similarly OIC integration with
  Finance module
  

Good to Have:

• Experience with Oracle Fusion / Oracle SaaS data models.
  

• Exposure to cloud -based data platforms.
  

• Knowledge of scheduling, automation, and monitoring tools.
  

• Experience working in Agile / Scrum environments.
  

Soft Skills:

• Strong problem -solving and analytical skills.
  

• Ability to work independently and collaboratively in a team.
  

• Good documentation and communication abilities.