Oracle ERP-Consultant

r3 Consultant; Maharashtra; On-site; INR 800,000 - 1,200,000; Full time

Job summary

A leading IT consultancy in India is seeking a Senior Oracle ERP Report Developer to design, develop, and maintain reporting solutions within Oracle Cloud ERP. This role necessitates deep technical expertise in Oracle tools such as BI Publisher, OTBI, and BICC, along with 5-8 years of experience. The ideal candidate will work closely with Finance and IT teams to deliver accurate reporting solutions while providing end-user support and training. Strong SQL skills and problem-solving abilities are essential for success in this position.

Qualifications

• 5-8 years of experience with Oracle ERP Cloud and reporting tools.
• Strong SQL and PL/SQL scripting skills.
• Familiarity with Oracle Cloud data models.

Responsibilities

• Develop reports using Oracle ERP Cloud tools.
• Translate business requirements into technical solutions.
• Validate data accuracy and integrity in reports.

Skills

SQL and PL/SQL scripting skills

Oracle ERP Cloud knowledge

Oracle Financials knowledge (GL, AR, AP)

Problem-solving abilities

Effective communication

Education

Bachelor’s degree in computer science or related field

Tools

BI Publisher

OTBI

BICC

Job description

Job Title

Oracle ERP Report Developer

Job Code

Reports to

Department

IT‑Infrastructure

Revision Date

05‑05‑2025

Basic Purpose

We are seeking a Senior Oracle ERP Report Developer to design, develop, and maintain reporting solutions within Oracle Cloud ERP. This role requires deep technical expertise in Oracle reporting tools (BI Publisher, OTBI, BICC), along with a solid understanding of finance and HCM business functions. The ideal candidate will partner with business and IT teams to deliver accurate, scalable, and insightful reporting solutions and provide end‑user support and training.

Essential Functions

• Develop reports using Oracle ERP Cloud tools including BI Publisher, OTBI, and BICC.
• Translate business requirements into scalable, maintainable technical solutions.
• Create and manage technical documentation including design specs and data mappings.
• Analyze business needs and translate them into data‑driven insights.
• Validate and ensure data accuracy, completeness, and integrity in reports.
• Develop ad‑hoc reports and schedule data extracts for multiple business units.
• Engage with Finance, HCM, PPM, and IT stakeholders to gather and clarify reporting needs.
• Collaborate with technical and functional teams to implement the best practices.
• Troubleshoot and resolve issues related to report performance and data discrepancies.
• Provide knowledge transfer and guidance to junior developers and power users.
• Conduct training sessions on report usage and best practices.

Reporting Relationships

Will report to Team Lead, IT‑BI

Qualifications

• Bachelor’s degree in computer science, Cybersecurity, Information Technology, or a related field.
• 5‑8 years of hands‑on experience with Oracle ERP Cloud and reporting tools (BI Publisher, OTBI, BICC).
• Strong SQL and PL/SQL scripting skills.
• Experience with Oracle Cloud data models and subject areas.
• Ability to optimize report performance and manage large datasets.
• Familiarity with Oracle Financials (GL, AR, AP), HCM, and PPM modules.
• Understanding of ERP business processes and data structures.
• Strong problem‑solving and analytical abilities.
• Effective verbal and written communication.
• Ability to work independently and manage multiple tasks.

Collaboration

Works cross‑functionally with Finance, HCM, IT, and Application teams to gather requirements and deliver scalable reporting solutions. Aligns reporting outputs with stakeholder needs.

Communication

Translates reporting logic and data models into business-friendly language. Communicates technical limitations and solutions clearly to non‑technical stakeholders.

Accountability

Takes ownership of the full report development lifecycle — from requirement analysis to deployment and post‑release support. Ensures data integrity and on‑time delivery.

Analytical Thinking

Breaks down complex data requirements into structured, optimized report logic. Diagnoses data issues, mismatches, and performance bottlenecks effectively.

Receptiveness to Feedback

Incorporates user and stakeholder feedback into report improvements. Participates in peer reviews and adheres to coding/reporting standards.

Continuous Learning

Keeps up with Oracle Cloud ERP updates and new features in BI Publisher, OTBI, and BICC. Evaluates new reporting capabilities and contributes to knowledge sharing within the team.

Work Conditions

• Employees must possess comfort in learning, training, and engaging with others virtually through Microsoft Teams, and TeamViewer.
• Employee must show readiness and be available to work from office.