Role Summary
The Oracle EBS Technical Consultant is responsible for designing, developing, and customizing Oracle E-Business Suite applications to meet business needs. They work closely with functional teams to translate requirements into technical solutions, leveraging tools such as PL/SQL, Forms, Reports, BI Publisher, and OAF. The role ensures seamless integrations, performance optimization, and adherence to Oracle best practices
Hybrid
Oracle Technical
Duties and Responsibilities
-
Design, develop, and customize Oracle E-Business Suite modules to meet business requirements
-
Build and optimize PL/SQL objects, SQL scripts, interfaces, reports, and forms using tools such as Toad, Oracle Reports, Oracle Forms, JDeveloper, and XML Publisher
-
Develop integration solutions between EBS and external systems, leveraging standard APIs for data uploads and module integration
-
Enhance performance of PL/SQL blocks and SQL queries
-
Implement and support Business Events, AME, and Oracle Workflow processes
-
Translate functional requirements into practical technical solutions
-
Conduct technical reviews, resolve defects, support code migration, and deliver technical documentation
-
Maintain efficient, reusable, and reliable database code for forms, reports, and web services
-
Identify and resolve performance bottlenecks and bugs
-
Ensure code quality, organization, and optimization
-
Open and manage Service Requests with Oracle as needed
Required Skills & Qualifications
-
Minimum 3 years of experience in Oracle Applications and Database development, including full lifecycle implementations
-
Expertise in SQL performance tuning and Oracle APIs
-
Proficient in Oracle Reports, BI Publisher, AME, Alerts, Forms Personalization, Custom Libraries, and Custom Forms under APPS
-
Oracle Certified Associate (OCA) and Oracle Certified Professional (OCP) preferred
