Oracle Technical Consultant - EBS

Gapblue Software Labs; Ernakulam; On-site; INR 900,000 - 1,300,000; Full time

Job summary

Gapblue Software Labs is seeking an experienced Oracle Technical Consultant with 4-6 years of hands-on SQL, PL/SQL, Oracle EBS, and Oracle Fusion. The role emphasizes BI Publisher (BIP) and OTBI reporting, with duties spanning development, customization, and production support.

Responsibilities include crafting complex SQL/PL/SQL, building BI Publisher reports, OTBI dashboards, and translating business requirements into technical solutions while collaborating with cross-functional teams.

Qualifications

• 4-6 years of Oracle technical development experience.
• Strong SQL and PL/SQL expertise.
• Experience with Oracle EBS (preferably R12) and Oracle Fusion Cloud.
• BI Publisher report development and OTBI reports/dashboards.
• Good understanding of Oracle DB concepts and performance tuning.
• Troubleshooting and debugging skills; translate requirements to solutions.
• Bachelor's degree in CS/IT/Engineering or related field.

Responsibilities

• Develop, customize, and maintain Oracle EBS and Fusion technical solutions.
• Create complex SQL queries, PL/SQL procedures, functions, packages, and triggers.
• Support Oracle technical development, enhancements, integrations, and support activities.
• Develop and maintain BI Publisher (BIP) reports and OTBI analyses.
• Build OTBI dashboards and reports per business requirements.
• Translate business needs into effective technical solutions.
• Perform data extraction, transformation, validation, and troubleshooting.
• Troubleshoot issues and deliver root-cause analysis.
• Collaborate with functional consultants and technical teams; participate in testing and deployments.
• Prepare and maintain technical documentation.

Skills

Oracle technical development

SQL

PL/SQL

Oracle EBS

Oracle Fusion Cloud

BI Publisher

OTBI

Performance tuning

Troubleshooting

Requirements translation

Education

Bachelor's degree in Computer Science/IT/Engineering

Tools

BI Publisher (BIP)

OTBI

Oracle EBS

Oracle Fusion Cloud

Job description

We are looking for an experienced Oracle Technical Consultant with 4-6 years of hands-on experience in SQL, PL/SQL, Oracle EBS, and Oracle Fusion. The candidate should have strong expertise in Oracle development and reporting tools, including BI Publisher (BIP) and OTBI.

Key Responsibilities

• Develop, customize, and maintain Oracle EBS and Oracle Fusion technical solutions.
• Develop complex SQL queries and PL/SQL procedures, functions, packages, and triggers.
• Work on Oracle technical development, enhancements, integrations, and support activities.
• Develop and maintain BI Publisher (BIP) reports, including data models and templates.
• Develop and support OTBI analyses, dashboards, and reports.
• Understand business requirements and translate them into effective technical solutions.
• Perform data extraction, transformation, validation, and troubleshooting.
• Troubleshoot technical issues and provide root-cause analysis and solutions.
• Collaborate with functional consultants, business users, and technical teams.
• Participate in unit testing, system/integration testing, deployment, and production support.
• Prepare and maintain technical documentation.

Required Qualifications and Experience

• 4-6 years of relevant experience in Oracle technical development.
• Strong hands-on experience in SQL and PL/SQL.
• Experience with Oracle EBS, preferably R12.
• Experience with Oracle Fusion Cloud.
• Strong hands-on experience in BI Publisher (BIP) report development.
• Experience with OTBI reports, analyses, and dashboards.
• Good understanding of Oracle database concepts and performance tuning.
• Strong troubleshooting and debugging skills.
• Ability to understand functional requirements and convert them into technical solutions.
• Bachelor s degree in Computer Science, Information Technology, Engineering, or a related field.

Additional Qualifications

• Experience with Oracle EBS R12 technical development.
• Knowledge of Oracle Fusion technical architecture.
• Exposure to REST/SOAP APIs, FBDI, or other Oracle integration technologies.
• Experience in implementation, enhancement, and production support projects.
• Good communication and collaboration skills.