Oracle-APEX Systems Analyst: Interfaces & Pricing Engine

Sumas Corporation Inc; SOUTH PLAINFIELD (NJ); On-site; USD 60,000 - 80,000; Full time

Job summary

Sumas Corporation Inc is seeking a full-time developer in South Plainfield, NJ. The role focuses on designing and supporting applications, including setting up database tables for customer and sales order data. Candidates should hold a Bachelor’s degree in a relevant field. Responsibilities include developing customizations for interfacing data from Oracle to APEX, coding database triggers, and participating in multiple project cycles. The position requires no prior experience, offering a great entry point for recent graduates.

Qualifications

• Minimum educational requirement is a bachelor’s degree in a relevant field.

Responsibilities

• Design, develop and support of the application.
• Design database tables to hold customer and sales order data.
• Develop customization to interface Price Lists data from Oracle to APEX application.
• Invoke pricing engine to get the order price with volume discounts.
• Work with Oracle Applications with multilingual and multiple operating units.
• Develop an interface from APEX to Oracle for sales order data.
• Create sales orders using open interface.
• Assist in CRP1, CRP2 cycles as needed.
• Develop technical design documents on interfaces and customizations.
• Involved in mass data conversion from Oracle Applications to APEX.
• Develop PLSQL packages to support object grouping.
• Code database triggers to capture updates to customer master.

Education

Bachelor Degree in Computer Science

Computer Information Systems

Computer Engineering

Computer Science & Engineering

Job description

Sumas Corporation Inc is seeking a full-time developer in South Plainfield, NJ. The role focuses on designing and supporting applications, including setting up database tables for customer and sales order data. Candidates should hold a Bachelor’s degree in a relevant field. Responsibilities include developing customizations for interfacing data from Oracle to APEX, coding database triggers, and participating in multiple project cycles. The position requires no prior experience, offering a great entry point for recent graduates.