Consultant | (BI Reports, OTBI, FRS, SmartView) | Mumbai | Oracle

Job requisition ID :: 93026

Date: Nov 28, 2025

Location: Mumbai

Designation: Consultant

Entity: Deloitte Touche Tohmatsu India LLP

Your potential, unleashed.

India's impact on the global economy has increased at an exponential rate and Deloitte presents an opportunity to unleash and realize your potential amongst cutting edge leaders, and organizations shaping the future of the region, and indeed, the world beyond.

At Deloitte, your whole self to work, every day. Combine that with our drive to propel with purpose and you have the perfect playground to collaborate, innovate, grow, and make an impact that matters.

The Team

Enterprise Technology and Performance (ET&P) is a Service Area within T&T where professionals provides various service offerings on Finance, Supply Chain, SAP, Oracle, Technology Strategy and ServiceNow. The goal is to help clients achieve outstanding value from their enterprise technology investments with a holistic and strategic approach to technology transformation.

Work you'll do

We are looking for a consultant with hands-on experience in Oracle Fusion BI Publisher (BIP) development and Integrations (OIC or REST/SOAP services). The role includes building reports, dashboards, data extracts, and integrating Oracle Fusion Cloud with internal and external systems.

Skills Required

BI Publisher (BIP) Development

• Design, develop, and maintain BI Publisher reports, data models, templates (RTF, Excel), and bursting logics.
• Work with OTBI to build subject areas, analyses, and dashboards; convert OTBI into BIP extracts when needed.
• Create XML/Excel templates and manage layout customizations.
• Develop Transactional, Operational, Financial, and Audit reports.
• Understand Oracle Fusion security roles and apply data security filters in reports.
• Optimize report performance and troubleshoot BIP issues.

2. Oracle Fusion Integrations

• Work on integrations using:
• Oracle Integration Cloud (OIC)
• REST APIs / SOAP Web Services
• FBDI and ADFDI data loads.
• Develop integrations between Fusion and external applications (HR, Finance, SCM, Legacy Systems).
• Build integration flows including:
• File-based integrations (FTP)
• Scheduled orchestrations
• Event-based integrations
• Troubleshoot integration failures and perform root-cause analysis.
• Support mapping, transformation, and orchestration design.

3. Technical Support & Documentation

• Work closely with functional teams to understand reporting and integration requirements.
• Prepare technical design documents (MD70), test scripts, and release documents.
• Participate in SIT/UAT cycles, fix defects, and support go-live.
• Provide post-production support for reports and integrations.

Required Skills & Experience

• 1–5 years of experience in Oracle Fusion technical areas.
• Hands-on experience with BI Publisher (BIP) report development.
• Strong knowledge of:
• SQL & PL/SQL
• XML / XSLT
• RTF / Excel templates
• Experience with OIC OR Oracle Fusion REST/SOAP APIs.
• Familiarity with FBDI/ADFDI, HDL (good to have).
• Understanding of Fusion ERP/Finance/SCM data model (at least one pillar).
• Experience with troubleshooting performance/functional issues.

How you'll grow

At Deloitte, our professional development plan focuses on helping people at every level of their career to identify and use their strengths to do their best work every day. From entry-level employees to senior leaders, we believe there's always room to learn. We offer opportunities to help build world-class skills in addition to hands-on experience in the global, fast-changing business world. From on-the-job learning experiences to formal development

Programs at Deloitte University, our professionals have a variety of opportunities to continue to grow throughout their career. Explore Deloitte University, The Leadership Centre.

Benefits

At Deloitte, we know that great people make a great organization. We value our people and offer employees a broad range of benefits. Learn more about what working at Deloitte can mean for you.

Our purpose

Deloitte is led by a purpose: To make an impact that matters.

Every day, Deloitte people are making a real impact in the places they live and work. We pride ourselves on doing not only what is good for clients, but also what is good for our people and the communities in which we live and work—always striving to be an organization that is held up as a role model of quality, integrity, and positive change. Learn more about Deloitte's impact on the world

Recruiter tips

We want job seekers exploring opportunities at Deloitte to feel prepared and confident. To help you with your interview, we suggest that you do your research: know some background about the organization and the business area you're applying to. Check out recruiting tips from Deloitte professionals.