- Design, develop, and maintain Oracle BI Publisher (BIP) reports, OTBI dashboards, and custom data models.
- Work closely with functional teams to gather reporting requirements and translate them into technical specifications.
- Build SQL queries, data templates, and layout templates for complex business reports.
- Optimize report performance by tuning SQL queries and data model structures.
- Develop and maintain RTF, Excel, and online report templates for Oracle Cloud ERP modules.
- Configure bursting definitions for automated report delivery across channels.
- Perform report migration across environments and ensure version control.
- Troubleshoot report failures, data discrepancies, and performance issues.
- Ensure compliance with data security, role-based access, and Oracle Fusion security model.
- Collaborate with integration teams to embed reports within business workflows.Implementation & Delivery :
- Taking ownership and lead technical delivery of Oracle FDI projects from requirements through UAT and production go-live.
- Develop and review ETL/ELT mappings, interfaces, and transformation logic.Required Qualifications :
- 6 years of experience in Oracle reporting solution with good experience of understanding the business flows and good end to end Implementations.
- Deep expertise in Oracle FDI.
- Proficiency with OTBI and BIP reports.
- Solid understanding and experience of Oracle Fusion Cloud ERP: SCM, Finance modules.
- Hands-on experience with REST/SOAP APIs, JSON, and Oracle Integration Cloud (OIC) would be added advantage.
- Solid SQL skills; familiarity with Oracle Database, ADW, and data modeling best practices.Must-Have Skills :
- BI Publisher- OTBI- FDI- SQL Development- Oracle Fusion Finance & SCM- Data Models & Templates (ref:hirist.tech) .
📌 Automus Consulting - BI Reports Consultant - Oracle FDI (Pune)
🏢 AUTOMUS CONSULTING (INDIA) PRIVATE
📍 Pune
Reply to this offer
Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.