Oracle EBS Tech - PL/SQL integrations

Elfonze Technologies; Hyderabad; On-site; INR 1,800,000 - 2,600,000; Full time

Job summary

Elfonze Technologies is seeking an experienced Oracle EBS Technical Consultant to join our Hyderabad team. The role requires 8+ years of Oracle EBS technical development, with strong PL/SQL, integrations, and custom extensions capabilities.

Responsibilities include designing complex PL/SQL packages, building inbound/outbound integrations, and developing BI Publisher reports, Oracle Reports, and Forms. Collaboration with functional teams and performance tuning are key aspects of this position.

Qualifications

• 8+ years of Oracle EBS Technical development experience.
• Strong expertise in Oracle PL/SQL.
• Experience in developing custom extensions in Oracle EBS.
• Hands-on experience with Oracle EBS Integrations.
• Experience with Oracle Reports, XML Publisher (BI Publisher) and Oracle Forms.
• Strong knowledge of Oracle Financials modules (AP, AR, GL, FA, CM).
• Functional understanding of Oracle Projects (PA) module (preferred).
• Experience in developing Interfaces, Conversions, Extensions, Reports, and Workflow customizations.
• Strong debugging and performance tuning skills for PL/SQL programs.
• Ability to convert business requirements into technical designs and custom logic.
• Experience with Oracle Concurrent Programs.
• Strong SQL query writing and database optimization skills.
• Excellent analytical, problem-solving, and communication skills.

Responsibilities

• Develop and maintain Oracle EBS customizations, extensions, and technical solutions.
• Design and develop complex PL/SQL packages, procedures, functions, triggers, and database objects.
• Build and support Oracle EBS inbound and outbound integrations.
• Develop Interfaces, Conversions, Reports, Extensions, and custom technical objects.
• Create and customize BI Publisher/XML Publisher reports, Oracle Reports, and Forms.
• Analyze business requirements and translate them into technical specifications.
• Support Oracle Financials modules and provide technical solutions for enhancements.
• Work closely with functional consultants to understand business processes and implement technical solutions.
• Optimize SQL queries and PL/SQL code for performance.
• Troubleshoot production issues and provide timely resolutions.
• Participate in code reviews, testing, deployment, and documentation.

Skills

Oracle EBS

PL/SQL

Integrations

Custom extensions

Oracle Financials

Oracle Reports

BI Publisher

Oracle Forms

Projects PA

Interfaces

Conversions

Workflows

Performance tuning

SQL optimization

Analytical/communication

Job description

We are looking for an experienced Oracle EBS Technical Consultant with 8+ years of experience in Oracle E-Business Suite (EBS) Technical development. The ideal candidate should have strong expertise in PL/SQL, Oracle EBS Integrations, and custom extensions, with functional knowledge of Oracle Financials and preferably Oracle Projects modules. The candidate should be capable of converting business requirements into scalable technical solutions and custom development.

Mandatory Skills

• 8+ years of Oracle EBS Technical development experience
  
• Strong expertise in Oracle PL/SQL
  
• Experience in developing custom extensions in Oracle EBS
  
• Hands-on experience with Oracle EBS Integrations
  
• Experience with Oracle Reports, XML Publisher (BI Publisher) and Oracle Forms
  
• Strong knowledge of Oracle Financials modules (AP, AR, GL, FA, CM)
  
• Functional understanding of Oracle Projects (PA) module (preferred)
  
• Experience in developing Interfaces, Conversions, Extensions, Reports, and Workflow customizations
  
• Strong debugging and performance tuning skills for PL/SQL programs
  
• Ability to convert business requirements into technical designs and custom logic
  
• Experience with Oracle Concurrent Programs
  
• Strong SQL query writing and database optimization skills
  
• Excellent analytical, problem-solving, and communication skills
  

Key Responsibilities

• Develop and maintain Oracle EBS customizations, extensions, and technical solutions.
  
• Design and develop complex PL/SQL packages, procedures, functions, triggers, and database objects.
  
• Build and support Oracle EBS inbound and outbound integrations.
  
• Develop Interfaces, Conversions, Reports, Extensions, and custom technical objects.
  
• Create and customize BI Publisher/XML Publisher reports, Oracle Reports, and Forms.
  
• Analyze business requirements and translate them into technical specifications.
  
• Support Oracle Financials modules and provide technical solutions for enhancements.
  
• Work closely with functional consultants to understand business processes and implement technical solutions.
  
• Optimize SQL queries and PL/SQL code for performance.
  
• Troubleshoot production issues and provide timely resolutions.
  
• Participate in code reviews, testing, deployment, and documentation.