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 dynamic input parameters of various types.

- Expertly write SQL and PL/SQL code.

- Build reports using various template types: RTF, XLS, and XSLT.

- Good 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 environments, 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

- Positive working knowledge of Oracle SQL Developer / Database

- REST APIs

📌 Oracle BI Publisher (Bengaluru)
🏢 CGI
📍 Bengaluru