Key Responsibilities :

Report Development :

- 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.

- Strong 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