Oracle Erp Technical Consultant

R3 Consultant; Pune District; Hybrid; INR 1,200,000 - 1,800,000; Full time

Job summary

R3 Consultant is seeking a Senior Oracle ERP Report Developer to design, develop, and maintain comprehensive reporting solutions within Oracle Cloud ERP. The role requires expertise in BI Publisher, OTBI, and BICC, with strong knowledge of finance and HCM processes.

You will collaborate with Finance, HCM, PPM, and IT teams to deliver accurate, scalable reports and provide end-user training. The ideal candidate has 5+ years of experience in Oracle ERP Cloud reporting, strong SQL/PLSQL skills, and

Qualifications

• 5+ years of hands-on experience with Oracle ERP Cloud and reporting tools (BI Publisher, OTBI, BICC).
• Strong proficiency in HCM Extract, HCM Data Loader, Payroll, Absence, Core HR, Talent Management.
• Strong proficiency in SQL and PL/SQL.
• Experience with Oracle Cloud data models and subject areas.
• Understanding of Oracle Financials (GL, AR, AP) and PPM modules.

Responsibilities

• Develop, test, and deploy reports using Oracle ERP Cloud tools (BI Publisher, OTBI, BICC).
• Translate business requirements into scalable reporting solutions with performance in mind.
• Create and maintain technical documentation including design specs and data mappings.
• Collaborate with Finance, HCM, PPM, and IT stakeholders to gather reporting needs.

Skills

Oracle ERP Cloud

SQL & PL/SQL

Data modeling

Communication

Problem solving

Education

Bachelor's degree in Computer Science or related

Tools

BI Publisher

OTBI

BICC

HCM Extract

HCM Data Loader

Job description

Job Title: Senior Oracle ERP Report Developer

Department: IT-Infrastructure

Employment Type: Contract ( 3 months, extendable)

Reports To: Team Lead, IT-BI

Job Purpose:

We are seeking a highly skilled Senior Oracle ERP Report Developer to design, develop, and maintain comprehensive reporting solutions within Oracle Cloud ERP. The ideal candidate will possess deep expertise in Oracle reporting tools such as BI Publisher, OTBI, and BICC, coupled with a solid understanding of finance and HCM business functions. This role involves partnering with business and IT teams to deliver accurate, scalable, and insightful reports, while providing end-user support and training to maximize user adoption and understanding.

Key Responsibilities:

• Develop, test, and deploy reports using Oracle ERP Cloud tools including BI Publisher, OTBI, and BICC.
• Translate business requirements into effective, scalable reporting solutions ensuring performance and maintainability.
• Create and maintain detailed technical documentation including design specifications, data mappings, and data models.
• Analyze business needs and generate data-driven insights to support decision-making.
• Validate report data accuracy, completeness, and integrity.
• Develop ad-hoc reports and schedule data extracts for various business units.
• Collaborate with Finance, HCM, PPM, and IT stakeholders to gather and clarify reporting needs.
• Troubleshoot report performance issues and resolve data discrepancies.
• Provide mentorship, guidance, and knowledge transfer to junior developers and power users.
• Conduct training sessions on report usage, features, and best practices.
• Stay current with updates and new features in Oracle Cloud ERP reporting tools and recommend best practices for implementation.

Qualifications:

• Bachelors degree in Computer Science, IT, Cybersecurity, or a related field.
• 5+ years of hands-on experience working with Oracle ERP Cloud and related reporting tools (BI Publisher, OTBI, BICC).
• Strong proficiency in HCM Extract, HCM Data Loader, Payroll, Absence, Core HR, Talent Management.
• Strong proficiency in SQL and PL/SQL scripting.
• Experience with Oracle Cloud data models and subject areas.
• Understanding of Oracle Financials (GL, AR, AP), HCM, and PPM modules.
• Ability to optimize report performance and handle large datasets.
• Strong analytical, problem-solving, and troubleshooting skills.
• Excellent verbal and written communication skills.
• Ability to work independently and manage multiple projects simultaneously.

Competencies & Attributes:

• Strong cross-functional collaboration skills.
• Ability to communicate complex technical details effectively to non-technical stakeholders.
• Ownership of the entire report development lifecycle.
• Receptive to feedback and committed to continuous learning.
• Ability to adapt to Oracle Cloud updates and adopt new reporting capabilities.