Oracle PL/SQL Technical Developer

Key roles and responsibilities

• Develop and support various R12.2.14 ERP modules like Pricing, Purchasing, Inventory, Order Management, Shipping
• Execution, Bill of Materials, Oracle Quality with expertise on Trading Community Architecture (TCA).
• Design, develop, implement, customize, integrate, and maintain Oracle e-Business Suite applications of Quality, Manufacturing, Supply Chain, and Procurement modules.
• Translate business requirements to IT solutions through customizations to fit and enhance the Oracle EBS applications to specific business needs:
• Translate functional documents into technical design documents (MD70) for Reports, Interfaces, Conversions, Extensions, Workflows (RICEW) components, prepare high-level design specification, technical process flow diagrams, pseudo logic, database objects using standard Oracle application implementation methodology (AIM) in Oracle E-Business applications R12.2.14
• Design, Development, and Testing of Oracle Reports, XML Reports, and SQL Scripts development in Oracle EBS applications and integrated systems to extract and report data.
• Provide production support in troubleshooting defects and providing timely resolutions, support to the users during the Integration testing and User Acceptance Testing (UAT).
• Develop Oracle EBS Integration with multiple upstream and downstream systems.
• Supports production deployment and project go-live tasks.
• Actively participate in Status meetings and collaborate with other team members to carry out project deliverables.

Requirements

A strong background in Oracle PL/SQL and extensive experience in Oracle EBS packaged modules, particularly within Supply Chain Management.

Ability to work independently and deliver results with minimal guidance from the Subaru EBS Engineering team.

Skills

• Oracle PL/SQL
• Leveraging the latest database features to write efficient and optimized code
• Oracle E-Business Suite Technical development using PL/SQL & SQL Developer, SQL*Loader, Unix Shell scripting, Workflow Builder, SOA, Oracle BI Publisher, ORDS, Oracle reports and forms
• Oracle Reports, XML Reports, and SQL Scripts development
• Oracle EBS Integration with multiple upstream and downstream systems
• Production support in troubleshooting defects and providing timely resolutions
• Collaboration with other team members to carry out project deliverables