🎁 Before you apply, rehearse this interview. Create your free WorkMundi account and get an Interview Training on HelpsYouSpeak — no cost, no card. I want my training →
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. 2. 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. 3. 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. 4. 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. 5. 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. 6. 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. 7. 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. .
Here's where they are and how to stand out in your next interview.
24.795Jobs
9.577IN
74%EN
That number includes positions in India (9,577), Poland (3,429), the United States (1,753), Singapore (787), and Brazil (779). If you're looking to move or work remotely, check which countries match your goals — then filter WorkMundi by location to see what's actually hiring near you.
Most developer ads you'll see are written in English: 18,397 of the 24,795. That doesn't tell you whether the job itself requires you to speak English or work in English daily, so read each posting carefully. Don't assume the language of the ad matches the language of the team.
The employers posting the most developer roles are Link Group (369 jobs), Upvanta (257), jobgether (226), and OfferZen (212). If you're applying to any of these, research their hiring patterns. They move fast and post often, which means they're either scaling hard or replacing people who didn't fit.
In your interview, expect this: 'Walk me through the last time you had to debug something that took you more than an hour. What was it, what did you try first, and what would you do differently?' Hiring managers ask this to see if you think systematically or just try random fixes. Have a real example ready with specifics.