Computer Systems Analyst

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

Responsibilities

• Design, develop and support of the application.
• Design database tables at APEX side to hold the customer and sales order data.
• Develop a customization to interface, Price Lists data from Oracle to APEX application.
• Develop a customization to invoke pricing engine to get the order price with applicable volume discounts.
• Work with Oracle Applications with multilingual and multiple operating units.
• Develop an incremental interface from APEX to Oracle to interface sales order data.
• Develop customization to create sales orders using open interface.
• Involve in CRP1, CRP2 cycles and provide assistance, where needed.
• Develop technical design document on interfaces and customizations.
• Involve in one data mass data conversion from Oracle Applications to APEX.
• Develop PLSQL packages to support object grouping.
• Code database triggers to capture the updates to customer master, so to interface the changes to APEX.

Job Details

Job Code: SCJ-029

Job Location: South Plainfield, NJ

Type Of Job: Fulltime

Hours Per Week: 40

Experience: 0-2 Years

Qualifications

Requirements

Minimum educational requirement is a bachelor’s degree in Bachelor Degree in Computer Science or Computer Information Systems or Computer Engineering or Computer Science & Engineering.