Oracle Technical Consultant

Gapblue Software Labs Pvt Ltd; Ernakulam; On-site; INR 1,200,000 - 2,200,000; Full time

Job summary

Gapblue Inc. in Kerala invites an experienced Oracle Technical Consultant to design, develop, and maintain Oracle EBS and Fusion technical solutions. The role requires hands-on SQL/PLSQL and strong BI Publisher and OTBI reporting capabilities.

You will collaborate with functional teams, handle data extraction and performance tuning, and contribute to testing, deployment, and production support. A Bachelor’s degree is expected.

Qualifications

• 4–6 years of Oracle technical development experience.
• 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.
• Good communication and collaboration skills.

Responsibilities

• Develop, customize, and maintain Oracle EBS and Fusion technical solutions.
• Develop complex SQL queries, 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.

Skills

SQL

PL/SQL

Oracle EBS

Oracle Fusion

BI Publisher (BIP)

OTBI

Performance tuning

Troubleshooting

Communication

Collaboration

Education

Bachelor's degree (CS/IT/Engineering)

Tools

REST/SOAP APIs

FBDI

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, 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 Skills

• 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.
• Good communication and collaboration skills.

Good to Have

• 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.

Education

Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related field.