Reporting Line:

• Digital Solutions & ERP Operations Senior Manager

Responsibilities:

• Develop PL/SQL database objects, SQL scripts, interfaces, reports, and forms using standard tools (Toad, Oracle Reports, Oracle Forms, JDeveloper, XML Publisher, WinSCP).
• Develop, modify, and tune custom modules on Oracle Business Suite to meet business needs.
• Participate in designing integration solutions between EBS and other systems.
• Create DB scripts using standard APIs for data uploading and module integration.
• Optimize performance of PL/SQL blocks and SQL queries.
• Design and implement required EBS forms and OAF page.
• Participate in testing phases to fix defects, address performance issues, support code migration, and provide technical artifacts.
• Open SRs (Service Requests) with the product owner.
• Provide technical documentation as needed.
• Effectively manage issues and perform gap analysis between business requirements and the system.
• Develop error handling and reconciliation programs.

Experience:

• +3 years of experience in digital solutions, ERP operations, or related roles.
• A bachelors degree in computer science, Information Technology, or a related field.
• Having a good knowledge of Oracle FIN, SCM & MFG track modules.
• Expertise in writing SQL queries, Stored Procedures, Views, Functions, Packages and Triggers.
• Expertise in creating or modifying forms and reports under Oracle EBS environment.
• Using Oracle Open Interface tables APIs, Web ADI.
• Good knowledge in Oracle APEX is a plus.
• Good knowledge in MS Power BI is a plus.