Role Summary
The Oracle EBS Technical Consultant is responsible for designing, developing, and customizing Oracle 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 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 for 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
