What are the responsibilities and job description for the Oracle PL/SQL Technical Developer position at Estuate Inc.?
Role Name: Onsite Oracle PL/SQL Tech developer
Location: Camden, NJ. ONSITE
Job Description:
**This is onsite role at Camden, NJ as per Client mandated hybrid work model.**
1. Extensive experience in Oracle PL/SQL, leveraging the latest database features to write efficient and optimized code.
2. A solid understanding of EBS packaged modules—particularly within Supply Chain Management—is essential. Once business requirements are provided, the associate should be able to work independently and deliver results with minimal guidance from the Subaru EBS Engineering team.
3. Execute 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
**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.
• Translating 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.
• Providing 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.
Strong and effective offshore collaboration to deliver high quality deliverables as per project timelines.