Oracle EBS Developer

JOB PURPOSEDeveloping, Customize, Maintain and support Oracle applications' Reports/Personalization/Customizations/Workflows as per business requirement.Perform Oracle database maintenance activities including installation, configuration, upgrades, patching and backup and recovery of all databases.TASKSDevelop 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, OAF and APEX pages.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+5 years of experience in digital solutions, ERP operations, or software integrations.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 and MS Power BI is must.EDUCATIONA bachelor’s degree in computer science, Information Technology, or a related field.