Oracle Fusion BIP / Technical Consultant

Job Description

Position: Oracle Fusion BIP / Technical Consultant

Experience Level: 5+ Years

Work Schedule: 2:00 PM - 11:00 PM IST

Role Overview:

We are seeking an experienced Oracle Fusion Technical Consultant with deep expertise in Oracle BI Publisher (BIP), OTBI reporting, and data modeling across Oracle ERP Cloud Financials and Supply Chain Management (SCM) modules.

Key Responsibilities:

• Design, build, and maintain complex BI Publisher (BIP) reports, data models, and OTBI analyses within Oracle ERP Cloud.

• Implement and configure email and SFTP report bursting mechanisms for automated high-volume outbound distributions.

• Define, configure, schedule, and optimize Enterprise Scheduler Service (ESS) jobs.

• Build custom RTF, eText, and Excel templates aligning strictly with business reporting formats.

• Write, fine-tune, and optimize complex SQL queries and PL/SQL procedures against Oracle Fusion database schemas.

• Support data validation, inbound/outbound file processing, and interface coordination with integration tools such as Oracle Integration Cloud (OIC).

Mandatory Skills & Qualifications:

• Minimum 5 years of hands-on technical experience with Oracle ERP Cloud / Fusion Applications.

• Strong proficiency in BI Publisher (BIP), bursting configurations, and OTBI.

• Solid database fundamentals with advanced SQL and PL/SQL scripting capabilities.

• Practical understanding of Oracle Financials (GL, AP, AR) and SCM (PO, INV, OM) backend tables and data flows.

• Bachelors or Masters degree in Computer Science, Information Technology, Commerce, or related disciplines.