Role & responsibilities
Design, develop, and maintain BI Publisher reports and documents (PDF, Excel, CSV, and XML file formats).
Create and maintain data models, SQL queries, and data sets used by reports and documentgeneration processes, including energetic input parameters of various types.
Expertly write SQL and PL/SQL code.
Build reports using various template types: RTF, XLS, and XSLT.
Valuable knowledge of bursting query configurations and schedulereport processing (job handling and monitoring).
Work with different types of subtemplates.
Analyze business requirements and translate them into reporting and documentgeneration specifications.
Troubleshoot production issues and resolve reportjob failures.
Optimize report performance and address data or logicrelated problems.
Manage ControlM job scheduling and monitoring.
Migration and deployment across Development, UAT, and Production settings, including version control with Git.
Prepare technical specifications, test cases, and user documentation.
Preferred candidate profile
Oracle BI Publisher
SQL / PLSQL
RTF, XSL, and XSLT templates
Basic knowledge of ControlM
Expertise in data modeling and analytics
Good working knowledge of Oracle SQL Developer / Database
REST APIs
📌 Oracle Bi Publisher Bengaluru
🏢 CGI
📍 Bengaluru