Oracle Technical Consultant

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

Job summary

Gapblue Software Labs Pvt Ltd in India seeks an experienced Oracle Technical Consultant with 4–6 years of hands-on SQL, PL/SQL, Oracle EBS, and Oracle Fusion expertise to design and implement high-impact technical solutions.

You will develop complex SQL queries, BI Publisher and OTBI reports, and collaborate with cross-functional teams to support deployments and documentation. Strong communication and problem-solving skills are essential.

Qualifications

• 4–6 years of hands-on experience in Oracle technical development.
• Strong skills in SQL and PL/SQL development.
• Experience with Oracle EBS, preferably R12 and Oracle Fusion Cloud.

Responsibilities

• Develop, customize, and maintain Oracle EBS and Oracle Fusion technical solutions.
• Develop complex SQL queries, PL/SQL procedures, functions, packages, and triggers.
• Develop and maintain BI Publisher (BIP) reports and OTBI analyses, dashboards, and reports.
• Translate business requirements into technical solutions and perform data extraction/validation.

Skills

Oracle SQL

PL/SQL

Oracle EBS

Oracle Fusion

BI Publisher

OTBI

Data modeling

Performance tuning

Collaboration

Education

Bachelor's degree in Computer Science/IT/Engineering

Tools

Oracle EBS

Oracle Fusion Cloud

BI Publisher (BIP)

OTBI

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.