Oracle Technical Consultant

Job Title: Oracle Technical Consultant

Experience: 4 to 7 Years

Location: Kochi

Employment Type: Full-Time

Job Summary

We are looking for an experienced Oracle Technical Consultant with 46 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.