Applications Programmer Oracle EDI

EDI Staffing, an EDI Specialists Company; San Clemente (CA); Hybrid; USD 110,000 - 140,000; Full time

Job summary

EDI Staffing, an EDI Specialists Company, is seeking an Applications Programmer – EDI/Oracle in California. The role focuses on developing, deploying, maintaining, and customizing Oracle EBS and EDI integrations across GL, AP, AR, OM, WIP, INV, PO, and FA. You will collaborate with Business Analysts to translate requirements and deliver technical solutions.

You will test, deploy, and support reports and forms, and participate in 24/7 on-call support, ensuring system processing and availability.

Qualifications

• Must be at least 18 years old.
• Bachelor's degree in Computer Science, Information Systems, or related IT field.
• Minimum 5 years of experience in Oracle Reports, Forms, Workflow Builder, Discoverer, PL/SQL, Shell Scripts and XML Publisher (GL/AP/AR/OM/INV/PO).
• 5+ years of hands-on experience in IBM Sterling B2B Integrator development and administration.
• 2+ years of experience with E-Commerce gateway/Oracle E-Business Suite (ERP).
• Hands-on experience with ANSI X12, CSV, XML, and EDIFACT standards related to 850/855/810/856.

Responsibilities

• Develop, deploy, maintain, and customize Oracle Applications and EDI integrations.
• Interface with Business Analysts to translate requirements and develop solutions.
• Test, deploy, and support reporting and forms from business requirements.
• Support Oracle Applications Production environment (12i) and integration touchpoints.
• Participate in 24/7 on-call department program.
• Create process flows and high-level functional and detailed technical design specifications.

Skills

BPML Mapping

Map Editor

Transformation Extender

EDI Concepts

AS2/VAN/SFTP

Oracle SQL/PLSQL

Communication Skills

Analytical Skills

Team Collaboration

Under Pressure

Oracle EBS Finance/SCM

Education

Bachelor's degree in Computer Science/Information Systems or related IT field

Tools

Sterling B2B Integrator

Map Editor

Transformation Extender

Oracle EBS

ANSI X12/EDIFACT

XML Publisher/Discoverer

Job description

The Applications Programmer – EDI/Oracle is responsible for assisting with the development, deployment, maintenance, and customization of various Oracle Applications and EDI integrations including General Ledger, Payables, Receivables, Order Management, Work in Process, Inventory, Purchasing and FA. This position will interface with Business Analysts to understand business requirements and develop solutions, test and deploy. This position will also work with the business on any technical development requirements such as reports and forms.

This is a hybrid positon based in CA*

• Proficiency in integrating Oracle e-business suite with EDI (IBM SI B2b) tool
• Working knowledge of the 3PL EDI integration with Oracle (850/810/940/945)
• Analyze project requirements and determine technical approach and programming required
• Support Oracle Applications Production environment (12i)
• Moderate to advanced proficiency in PL/SQL programming
• Demonstrate technical knowledge (RICE components) in EBS O2C and P2P cycles
• Troubleshoot, refactor, and enhance code to meet evolving business requirements
• Support business needs for system processing and availability
• Participate in 24/7 department on-call program
• Support day-to-day issues around integration touchpoints
• Create process flows, high-level functional and detailed technical design specifications from business requirements

Knowledge & Skills

• Deep expertise in Sterling B2B Integrator Business Process Development (BPML), Mapping using Map Editor and Transformation Extender
• Strong understanding of EDI concepts and delivery mechanisms like AS2, VAN, SFTP, HTTPS, and other protocols
• Proficient in Oracle SQL and PL/SQL for development and support of Oracle EBS applications
• Excellent verbal and written communication skills
• Strong analytical and problem-solving skills
• Excellent collaboration skills and able to work in a team environment
• Able to work quickly and effectively under pressure and to efficiently handle multiple priorities simultaneously
• Practical experience with Oracle EBS – finance and supply chain modules preferred

Minimum Qualifications, Education & Experience

• Must be at least 18 years of age
• Bachelor's degree from an accredited college or university in Computer Science, Information Systems, or related IT field
• Minimum 5 years of experience in Oracle Reports, Forms, Workflow Builder, Discoverer, PL/SQL, Shell Scripts and XML Publisher (GL/AP/AR/OM/INV/PO)
• 5+ years of hands-on experience in IBM Sterling B2B Integrator development and administration
• 2+; years of experience with E-Commerce gateway/Oracle E-Business Suite (ERP)
• Hands-on experience with ANSI X12, CSV, XML, and EDIFACT standards related to 850/855/810/856