Able to support Oracle Apex related applications & reports.
Developing BIP reports in Oracle Fusion Cloud PD and PIM
Able to develop new SQL based BI Reports
Responsible for designing and implementing new features into Oracle Cloud PLM using a combination of APEX, SQL, PL/SQL
Design and implement user interfaces, reports, dashboards, charts, and other components using APEX features and plugins.
Troubleshoot and resolve issues related to APEX applications, database performance, security, and integration.
Write and optimize complex SQL queries, stored procedures, functions, triggers, and packages.
Partner with business analysts, fellow IT resources and end users to evaluate business requirements, minimal viable product requirements, and deliver required features/functions.
Collaborate with IT business units to ensure that security and architecture requirements are fulfilled.
Responsible for the integration of third-party APEX Plugins and JavaScript libraries.
Suggesting application design enhancements and new product features.
Requirements :
Bachelor s degree in information technology, Process Management or related degree or experience
At least 4+ years of experience in SQL/ PL SQL, Oracle APEX, Reports & Analytics, PLM.
Previous experience in developing web applications using APEX, coupled with SQL and PL/SQL skills.
Candidates should have 2+ years of experience in Oracle APEX.
Hands-on experience with Oracle Fusion Reports & Analytics.
Familiar with APEX features such as Interactive Grids, Dynamic Actions, RESTful Services, Application Items, Processes, Branches, etc.
Experience in integrating APEX applications with external systems using REST APIs, SOAP Web Services, etc.
Experience in Oracle Agile PLM / Oracle Cloud PLM tools is an added advantage.
Experience in using version control tools such as GitLab.
Business Knowledge: Demonstrates strong knowledge of current and possible future policies, practices, trends, technology, and information related to the business and the organization.
Communication: Demonstrates excellent listening and communication skills (written and verbal)
Initiative : Works independently and is highly motivated to initiate and accept new challenges
Judgment/Decision Making : Makes solid decisions based on a mixture of analysis, wisdom, experience, and judgment.
Managing & Adapting to Change : Readily adapts to changes in priority of initiatives and overall strategic direction within a multi-plan, geographically widespread organization.
Professionalism : Exhibits appropriate attributes in all aspects of performance and demeanor
Teamwork : Organizes and directs effective teams at the cross-functional level that consistently achieve stated goals
Results Oriented : Bottom-line oriented and can be counted on to consistently meet and exceed goals.