Oracle BI Publisher Reports Developer

Zorba AI; Hyderabad; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Zorba AI is seeking an experienced Oracle BI Publisher Reports Developer / PL/SQL Engineer to design, develop, optimize, and support enterprise reporting across Oracle ERP modules including Fusion Cloud ERP and EBS R12.

The role focuses on OTBI, BI Publisher, XML Publisher, and Oracle PL/SQL to deliver pixel-perfect reports, ensure data integrity, improve performance, and partner with Finance, GL, AP and AR teams to meet business requirements.

Qualifications

• Extensive experience with Oracle Fusion Cloud ERP reporting (OTBI, BI Publisher) including security.
• Hands-on experience with Oracle E-Business Suite R12 reporting using BI Publisher/XML Publisher.
• Strong PL/SQL knowledge and data modeling skills.
• Experience with GL, AP, AR across ERP modules and data structures.
• Ability to gather requirements from functional teams and deliver scalable technical solutions.
• Excellent communication and stakeholder management skills.

Responsibilities

• Design, develop, and optimize Oracle Fusion OTBI and BI Publisher reports.
• Create and maintain XML Publisher templates for Oracle EBS R12.
• Develop and tune complex SQL queries and PL/SQL packages.
• Ensure security and data access controls for reports.
• Collaborate with Finance, GL, AP, AR teams to gather requirements.
• Provide production support and documentation for reporting assets.
• Validate data integrity and resolve data discrepancies.

Skills

Oracle Fusion Cloud ERP reporting

OTBI

BI Publisher/XML Publisher

Oracle PL/SQL

SQL development

Performance tuning

Requirements gathering

Stakeholder communication

Tools

BI Publisher

XML Publisher

OTBI

Oracle Integration Cloud (OIC)

Job description

Job Summary

We are looking for an experienced

Job Summary

We are looking for an experienced Oracle BI Publisher Reports Developer / PL/SQL Engineer with strong expertise in Oracle Fusion Cloud ERP, Oracle E-Business Suite R12, BI Publisher, OTBI, XML Publisher, and Oracle PL/SQL. The candidate will be responsible for designing, developing, optimizing, and supporting enterprise reporting solutions across GL, AP, AR, Procurement, and other Oracle ERP modules.

Must-Have Skills

• Strong experience in Oracle Fusion Cloud ERP reporting, including OTBI, BI Publisher, and reporting security such as roles and data access sets.
• Hands-on experience with Oracle E-Business Suite R12 reporting, preferably using BI Publisher/XML Publisher.
• Strong knowledge of Oracle PL/SQL, XML Publisher, and BI Publisher.
• Ability to design and develop XML Publisher and BI Publisher templates.
• Experience working with functional teams to gather requirements and deliver technical solutions for GL, AP, and AR.
• Strong SQL skills with experience in query development, optimization, and performance tuning.
• Experience developing and maintaining PL/SQL packages, procedures, functions, and triggers, including packages supporting Oracle Integration Cloud interfaces.
• Strong understanding of Oracle GL, AP, and AR tables and data structures.
• Experience implementing data validation, error handling, data integrity, and performance tuning in PL/SQL solutions.
• Ability to prepare technical documentation and provide production support for reports and database objects.
• Excellent communication and stakeholder management skills.

Key Responsibilities 1. Oracle Fusion & EBS Reporting

• Design, develop, enhance, and optimize reports using Oracle Fusion OTBI and BI Publisher.
• Work with Fusion Analytics Warehouse (FAW) where applicable.
• Develop reporting solutions across Oracle Fusion ERP modules including GL, AP, AR, Procurement, and related modules.
• Support reporting requirements across both Oracle Fusion Cloud ERP and Oracle EBS R12 environments.
• BI Publisher / XML Publisher
• Develop pixel-perfect management, operational, financial, and regulatory reports using BI Publisher.
• Design and maintain BI Publisher data models, templates, layouts, bursting, scheduling, and report delivery mechanisms.
• Develop and maintain XML Publisher templates and reports for Oracle EBS R12.
• Manage report catalogs, folders, permissions, and security.
• OTBI & Analytics
• Develop ad-hoc analytics and operational reports using OTBI.
• Work with relevant OTBI subject areas and reporting structures.
• Create and maintain reporting solutions aligned with business requirements.
• Perform data analysis and reconciliation across multiple ERP modules.
• SQL & PL/SQL Development
• Develop complex SQL queries, joins, views, and data extraction logic for reporting.
• Optimize queries for high-performance reporting.
• Develop and maintain PL/SQL packages, procedures, functions, triggers, and supporting database objects.
• Support PL/SQL packages used for Oracle Integration Cloud (OIC) interfaces.
• Implement robust exception handling, validation, logging, and data integrity controls.
• Cross-Platform Data & Reconciliation
• Extract and reconcile data between Oracle Fusion Cloud ERP and legacy Oracle EBS R12.
• Investigate and resolve data discrepancies across GL, AP, AR, Procurement, and related modules.
• Ensure accurate and consistent reporting across different Oracle platforms.
• Functional Collaboration
• Work closely with Finance, Accounting, Procurement, and other functional teams to understand reporting requirements.
• Translate business requirements into scalable technical reporting solutions.
• Participate in requirement gathering, technical design, development, testing, deployment, and production support.
• Production Support & Documentation
• Troubleshoot report failures, data issues, performance problems, and production incidents.
• Perform root-cause analysis and implement permanent fixes.
• Maintain technical specifications, report documentation, data mappings, and support documentation.
• Ensure reports and database objects meet performance, security, and data-quality standards.

Preferred Skills

• Experience with Oracle Fusion Financials reporting.
• Strong understanding of GL, AP, AR, and Procurement business processes.
• Experience with Fusion reporting security and data access.
• Knowledge of FAW is an advantage.
• Experience with Oracle Integration Cloud (OIC) interfaces is preferred.
• Experience in both Oracle Fusion Cloud and EBS R12 environments is highly desirable.

Candidate Profile

• 5+ years of relevant experience in Oracle reporting and PL/SQL development.
• Strong hands-on experience with BI Publisher + PL/SQL.
• Good understanding of Oracle ERP financial modules and underlying tables.
• Strong analytical and problem-solving skills.
• Excellent verbal and written communication skills.
• Ability to work independently and collaborate effectively with functional and technical stakeholders.