Oracle Report Developer Consultant

r3 Consultant; Maharashtra; Hybrid; INR 2,000,000 - 2,500,000; Full time

Job summary

r3 Consultant in Pune (Hybrid – 10 Days Work From Office per Quarter) seeks an experienced Oracle ERP Report Developer Consultant to lead OTBI-based reporting on a 12-month fixed contract. The role focuses on Oracle ERP Cloud HR and Finance modules with advanced SQL skills to deliver enterprise reporting solutions.

The ideal candidate will design, develop, and optimize dashboards, collaborate with stakeholders, and ensure data accuracy across Oracle ERP applications. Immediate joiners preferred.

Qualifications

• 6+ years of experience in Oracle ERP Reporting and Analytics.
• Hands-on experience with Oracle Transactional Business Intelligence (OTBI).
• Advanced SQL and Oracle DB querying skills.
• Experience with Oracle ERP Cloud HR (HCM) and Finance (Financials) modules.
• Knowledge of Oracle ERP Cloud reporting architecture and data models.
• Experience building operational, analytical, and management reports.
• Ability to translate business requirements into technical reporting solutions.
• Strong analytical and problem-solving abilities; excellent communication.

Responsibilities

• Design, develop, and maintain OTBI reports and dashboards.
• Develop complex SQL queries and data extraction scripts.
• Build and support reports for Oracle ERP Cloud HR and Finance.
• Gather requirements and translate them into technical solutions.
• Develop operational, analytical, and management reports.
• Optimize report performance and ensure data accuracy.
• Troubleshoot reporting issues and provide timely resolutions.
• Prepare technical documentation and user guides.
• Collaborate with functional and technical teams during implementations.
• Ensure compliance with reporting standards and data governance.
• Support users with report enhancements and best practices.

Skills

OTBI

SQL

Oracle ERP Cloud HR

Oracle ERP Cloud Financials

Data models

Reporting design

Analytical

Stakeholder management

Education

Bachelor's degree in CS/IT/Engineering

Tools

Oracle BI Publisher

Job description

Job Title: Oracle ERP Report Developer Consultant

Experience: 6+ Years

Location: Pune (Hybrid – 10 Days Work From Office per Quarter)

Employment Type: 12-Month Fixed Contract

CTC: ₹20–25 LPA (Contract)

Notice Period: Immediate to 15 Days Preferred

About The Role

We are looking for an experienced Oracle ERP Report Developer Consultant to join our client engagement on a 12-month fixed contract. The ideal candidate should have strong hands-on experience in Oracle Transactional Business Intelligence (OTBI), Oracle ERP Cloud HR & Finance modules, and advanced SQL. The role involves designing, developing, and optimizing enterprise reporting solutions that provide meaningful business insights and support strategic decision-making.

The candidate will work closely with business stakeholders, functional consultants, and technical teams to gather reporting requirements, build dashboards, and deliver high-quality reporting solutions across Oracle ERP applications.

Key Responsibilities

• Design, develop, and maintain reports and dashboards using Oracle Transactional Business Intelligence (OTBI).
• Develop complex SQL queries, data extraction scripts, and reporting solutions across Oracle ERP Cloud applications.
• Build and support reports for Oracle ERP Cloud HR (HCM) and Finance (Financials) modules.
• Gather, analyze, and document business reporting requirements and translate them into technical solutions.
• Develop operational, analytical, and management reports to support business functions.
• Optimize report performance while ensuring data accuracy, consistency, and reliability.
• Troubleshoot reporting issues and provide timely resolution.
• Prepare technical documentation, report specifications, and user guides.
• Collaborate with functional consultants and technical teams during implementations, enhancements, and upgrades.
• Ensure compliance with reporting standards, security policies, and data governance guidelines.
• Support business users with report enhancements and reporting best practices.

Required Skills

• 6+ years of experience in Oracle ERP Reporting and Analytics.
• Strong hands-on experience with Oracle Transactional Business Intelligence (OTBI).
• Advanced expertise in SQL and Oracle database querying.
• Experience with Oracle ERP Cloud HR (HCM) and Finance (Financials) modules.
• Strong knowledge of Oracle ERP Cloud reporting architecture and data models.
• Experience developing operational, analytical, and management reports.
• Ability to understand business requirements and convert them into technical reporting solutions.
• Strong analytical, troubleshooting, and problem-solving skills.
• Excellent communication and stakeholder management skills.

Preferred Skills

• Oracle BI Publisher.
• Oracle HCM Cloud Reporting.
• Oracle Financials Cloud Reporting.
• Experience with Oracle ERP Cloud integrations.
• Exposure to data migration and reporting best practices.
• Oracle ERP Cloud implementation or support experience.
• Relevant Oracle Cloud certifications.

Educational Qualification

• Bachelor's Degree in Computer Science, Information Technology, Engineering, or a related discipline.
• Oracle certifications will be an added advantage.

Preferred Candidate Profile

• Immediate joiner or candidates with a notice period of up to 15 days.
• Strong experience in Oracle ERP Cloud reporting solutions.
• Excellent communication and stakeholder management abilities.
• Ability to work independently while collaborating with cross-functional teams.
• Willing to work in a Hybrid model with 10 days of work from office per quarter from the Pune location.