Oracle Fusion Reporting Consultant (BIP & OTBI)

Roles : Oracle Fusion Reporting Consultant (BIP & OTBI)

Exp : 7+ years

Location : Bangalore, Pune , Noida, Chennai, Jaipur

Shift timing : 2 to 11 PM IST

Notice period : 0 - 30 days

Job Description :

Proven expertise and hands-on experience on incidents and service requests, including configuration changes and enhancements, related to the following areas :

Reporting :

Experience with Oracle reporting tools such as BI Publisher, OTBI, and OAC.

Ability to design complex reports and dashboards.

Proficiency with data modeling, warehousing, and ETL processes.

General Technical Skills :

Proficiency in querying and manipulating data within Oracle databases using SQL and PL / SQL.

Hands-on technical experience in Finance, SCM, PPM modules

Solid understanding of the broader Oracle modules to ensure effective integration and support.

Additionally, expertise in the following skills will be advantageous

Understanding of Oracle HCM modules and Fast Formulas, HCM extracts.

General reporting on HCM domain by fetching data from HCM tables.

Data Management : Experience with data modeling, data warehousing, and ETL processes to support reporting and analytics requirements

Oracle Integration Cloud (OIC) & Visual Builder Studio (Redwood pages)

Application Integration Specialist with strong experience in Oracle Integration Cloud (OIC), specializing in Oracle Cloud ERP integrations (inbound / outbound). Skilled in Cloud-to-Cloud and On-Premise to Cloud integrations across Financials, HCM, and SCM modules, including event-driven workflows.

Expert in designing and troubleshooting OIC integrations, building PaaS extensions, and handling bulk data flows using FBDI files. Proficient in REST APIs, SOAP Web Services, and Oracle Autonomous Database.

Hands-on experience with Visual Builder (VBCS) for customizing Redwood pages, and developing responsive web / mobile apps. Strong in error handling, SaaS customization, and technologies like JSON, XML, OAuth, JavaScript, HTML, and CSS.