Role : Oracle Reporting / BI / OTBI Consultant

Exp range : 4.5- 8 years

Location : Pan India

Virtual Interview: 28th Aug

:
We are seeking experienced Oracle Cloud Reporting Consultants with expertise in BI Publisher, OTBI (Oracle Transactional Business Intelligence), and Smart View. The role focuses on designing, developing, and supporting enterprise reporting and analytics solutions across Oracle Fusion applications (ERP, HCM, SCM, EPM).
Develop, customize, and maintain reports using:
BI Publisher (BIP)
OTBI (Oracle Transactional BI)
Smart View (Excel-based reporting)
Design and build
Data models using SQL (Joins, subqueries, aggregations) and data templates
BI Publisher templates (RTF, Excel, XML)
Create OTBI
Analyses, dashboards, KPIs
Custom subject areas (if applicable)
Develop Smart View reports
Ad-hoc queries
Financial and management reports
Work with SQL queries for data extraction, Logical and physical data layers
Manage Report security and role-based access, Scheduling and bursting in BI Publisher




Perform Data validation and reconciliation, Performance tuning of reports
Handle integrations where reporting data is extracted via REST APIs / Web Services, Data extracts
Troubleshoot Report failures, Data inconsistencies, Performance issues
Oracle BI Publisher / OTBI certifications
Experience across multiple Oracle Cloud pillars (ERP, HCM, SCM, EPM)
Exposure to Data warehousing / analytics tools, Oracle Analytics Cloud (OAC)
Experience in global implementations or large-scale reporting settings
Problem-solving and analytical thinking
Attention to detail and accuracy in reporting
Ability to manage multiple reporting requests simultaneously

If you are interested and available for the virtual Interview (28th Aug). Kindly apply at the earliest. Post receiving your application, I will connect with you for the data collection and the further steps. Looking forward to your responses.

📌 Oracle Reporting Bengaluru (India)
🏢 Tata Consultancy Services
📍 India