01Overview
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 (ref:hirist.tech) .
