Oracle Apps Technical Consultant

Sterling Information Resources (i); Bengaluru; On-site; INR 900,000 - 1,500,000; Full time

Benefits offered by this job

Employee benefits

Job summary

First Advantage is seeking an Oracle Apps Technical Consultant to design, develop, customize, and support Oracle E-Business Suite (R12) applications in Bengaluru. The role focuses on translating business requirements into scalable technical solutions while ensuring performance and Oracle standards.

You will work with functional teams to implement interfaces, data migrations, and concurrent programs, while providing production support and performance tuning.

Qualifications

• Strong experience with Oracle E-Business Suite R12 architecture and development.
• Proficient in SQL/PL-SQL, reports, and BI Publisher templates.
• Experience designing interfaces between Oracle EBS and external systems.

Responsibilities

• Design, develop, customize, and maintain Oracle EBS components.
• Create and modify PL/SQL procedures, packages, functions, and triggers.
• Develop Forms, OAF pages, and ADF components as applicable.

Skills

Oracle EBS R12

SQL

PL/SQL

Oracle Reports

BI Publisher

Interfaces/APIs

Concurrent Programs

Unix/Linux shell scripting

Performance tuning

Job description

What Youll Do

The 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 Development

• Design, develop, customize, and maintain Oracle E-Business Suite R12 components.
• Develop and modify Rice Components
• Create 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 Handling

• Design 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 Maintenance

• Provide 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 Skills

• Strong experience in Oracle E-Business Suite R12
• Expertise in SQL, PL/SQL
• Hands-on experience with:
  • Oracle Reports
  • BI Publisher (XML, RTF templates)
  • Interfaces and APIs
  • Concurrent Programs
• Good understanding of Oracle EBS architecture
• Experience with Unix/Linux shell scripting
• Knowledge of Oracle database objects and performance tuning

Why 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 Groups
• FA Cares volunteer opportunities
• Mentorship Advantage Program
• SOAR, award-winning manager development program

We have great people here and are looking for more. Come join us!

Follow us:

• Facebook
• Instagram
• LinkedIn
• X
• YouTube

Equal Employment Opportunities at First Advantage

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

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.