Oracle Apps Technical Consultant

First Advantage; Indi; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

First Advantage is seeking an Oracle Apps Technical Consultant to design, develop, customize, and support Oracle EBS R12 applications. You will translate business requirements into technical solutions, ensure performance, and collaborate with functional consultants and users.

The role requires strong SQL/PL/SQL, Oracle Reports, BI Publisher, and Unix/Linux scripting skills. You will work on interfaces, data migration, and concurrent programs while maintaining Oracle standards.

Qualifications

• Strong experience in Oracle E‑Business Suite R12.
• Expertise in SQL and PL/SQL.
• Hands-on with Oracle Reports and BI Publisher.
• Experience with Unix/Linux shell scripting.
• Knowledge of Oracle EBS architecture and concurrent programs.
• Understanding of interfaces/APIs and data migration.

Responsibilities

• Design, develop, customize, and maintain Oracle E‑Business Suite R12 components.
• Develop PL/SQL procedures, packages, functions, and triggers.
• Build and modify Forms, OAF pages, and ADF components.
• Create and troubleshoot interfaces between EBS and external systems.
• Perform data migration and reconciliation using SQL, PL/SQL, and Oracle standard tools.
• Provide production support, including issue analysis, bug fixes, and performance tuning.
• Monitor and optimize SQL queries and PL/SQL programs for performance.

Skills

Oracle EBS R12

SQL

PL/SQL

Oracle Reports

BI Publisher

OAF

ADF

Forms

Unix/Linux

Interfaces & APIs

Concurrent Programs

Performance Tuning

Tools

Oracle Reports

BI Publisher

Job description

What You'll DoThe Oracle Apps Technical Consultant is responsible for the technical design, development, customization, and support of Oracle E‑Business Suite (EBS) applications. The role involves working closely with functional consultants and business users to translate business requirements into technical solutions while ensuring performance, scalability, and compliance with Oracle standards.Responsibilities:Technical DevelopmentDesign, develop, customize, and maintain Oracle E‑Business Suite R12 components.Develop and modify Rice ComponentsCreate and maintain PL/SQL procedures, packages, functions, and triggers.Develop and customize Forms, OAF (Oracle Application Framework) pages, and ADF components (as applicable).Work with Workflow Builder to customize and troubleshoot workflows.Integration & Data HandlingDesign and develop interfaces between Oracle EBS and third-party/external systems.Perform data migration and conversion using SQL, PL/SQL, and Oracle standard tools.Troubleshoot and resolve data inconsistencies and reconciliation issues.Support & MaintenanceProvide production support, including issue analysis, bug fixes, and performance tuning.Analyze and resolve concurrent program failures, performance issues, and database-related errors.Monitor and tune SQL queries and PL/SQL programs for optimal performance.What You Will Need to be Successful:Technical SkillsStrong experience in Oracle E‑Business Suite R12Expertise in SQL, PL/SQLHands-on experience with:Oracle ReportsBI Publisher (XML, RTF templates)Interfaces and APIsConcurrent ProgramsGood understanding of Oracle EBS architectureExperience with Unix/Linux shell scriptingKnowledge of Oracle database objects and performance tuningWhy Join Us at First Advantage?At First Advantage, team members are united around a noble purpose: helping organizations to safeguard their workplaces and manage risk. The company’s culture is shaped by its core values — Authenticity, Curiosity, Integrity, Teamwork, Customer-Inspired — empowering team members to bring their best ideas forward, collaborate across departments, and make a real impact.First Advantage offers a variety of culture programs and benefits designed to enhance employee experience and development.Employee Impact GroupsFA Cares volunteer opportunitiesMentorship Advantage ProgramSOAR, award-winning manager development programWe have great people here and are looking for more. Come join us!Fraud AlertFirst Advantage does not charge candidates any fees at any stage of the recruitment process. We will never ask you to make a payment, purchase equipment, transfer money, or provide financial account information to obtain employment. If anyone claiming to represent First Advantage requests payment or other financial information, please treat the communication as suspicious and contact us through this website for verification.Follow us:FacebookInstagramLinkedInXYouTubeEqual Employment Opportunities at First AdvantageFirst Advantage is an equal opportunity employer. We are committed to providing a workplace and recruitment process that is free from unlawful discrimination, harassment, and retaliation. Employment decisions at First Advantage are based solely on qualifications, merit, and business needs. We do not discriminate in any aspect of employment on the basis of race, color, national origin, ancestry, citizenship, religion, creed, sex, gender identity, gender expression, sexual orientation, marital or family status, pregnancy, age, physical or mental disability, medical condition, genetic information, veteran or military status, or any other characteristic protected by applicable law.