Oracle Functional Consultant

Topcoder; India; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

Topcoder is seeking an experienced Oracle EBS Techno-Functional Senior Developer in India. The role is predominantly technical (80%) with functional oversight (20%), focusing on EBS Finance modules and integration tasks. Candidates should have hands-on experience with R12 architecture, P2P, O2C, interfaces, APIs, and data migration.

Strong leadership and communication are essential. Responsibilities include design, development, and optimization of PL/SQL packages, complex SQL, and reports, along

Qualifications

• 10+ years experience in Oracle EBS R12 Techno-Functional roles.
• Strong technical focus (80%) with functional contribution (20%).
• Hands-on with Oracle PL/SQL, SQL, interfaces, APIs and reports.

Responsibilities

• Design, develop, and maintain Oracle PL/SQL packages, procedures, functions, and triggers.
• Write and optimize complex SQL queries for large-volume data processing.
• Perform performance tuning using explain plans, indexes, and statistics.
• Handle data validation, reconciliation, and exception handling.

Skills

Oracle EBS

PL/SQL

SQL

Performance tuning

RICE components

P2P processes

Interfaces/APIs

Forms Personalization

XML Publisher

Reports

Tools

IBM DataStage

Job description

10+ years (Oracle EBS R12 Techno-Functional).

Technical – 80% and Functional – 20%.

Role Summary:

• EBS Finance Modules: AR, AP and GL.
• Experience in RICE Components and developing Interface scripts.
• Proficient in Procure to Pay (P2P) Business flows and O2C cycle rules in Oracle Applications.
• Proficient in handling Interfaces, API’s, Forms Personalization, XML Publisher, Reports, Stored procedures and Triggers in Oracle Apps R12.
• Strong experience in EBS Technical Senior Developer with hands-on experience in Oracle database development.
• Strong experience in Migration, Implementation, Upgrade and End-to-End Development project.
• Good Communication and Leadership skills are must.
• Work closely with Customer Leads and Project planning execution.
• Fair IBM DataStage knowledge is added advantage.

Key Responsibilities

Oracle EBS Technical (Primary – 80%)

• Design, develop, and maintain Oracle PL/SQL packages, procedures, functions, and triggers.
• Write and optimize complex SQL queries for large-volume data processing
• Perform performance tuning using explain plans, indexes, and statistics
• Handle data validation, reconciliation, and exception handling.