AS400 Developer with EDI

Global Technical Talent, an Inc. 5000 Company; Issaquah (WA); On-site; USD 62,508 - 89,027; Part time

Benefits offered by this job

Medical, Vision, and Dental Insurance Plans

401(k) Retirement Fund

Job summary

A technology services company is seeking an AS400 Developer with Experience on the EDI platform, iSeries programming, and SQL skills. This role involves creating new programs using RPG, modifying SQL queries, and documentation of business rules, along with a keen understanding of various EDI transaction types. The position is contract-based for 3 months at a pay rate of $55 per hour, located in Issaquah, WA. Candidates should possess strong communication skills and the ability to manage project tasks effectively.

Skills

Excellent programming skills on the iSeries platform

Analyze and create new programs using RPG, RPG ILE, SQLRPGLE, and Control Language (CLP/CLLE)

Knowledge and hands-on experience working on the EDI platform on iSeries

Knowledge of various EDI transaction types like 810, 850, 820, 856

Very good knowledge of SQL concepts

Analyze and modify complex SQL queries

Embed SQL in SQLRPGLE and cursor programming

Database concepts including creating and analyzing physical files, logical files, SQL tables, indexes, views, and stored procedures

Good working knowledge of screen programming

Document business rules effectively

Create data-mapping documents after analyzing program flows and data flows

ILE programming to analyze and create program modules

Working knowledge of message queue (MQ) and embedding XML tags in RPG programs

Good communication skills

Own a project task completely based on communication with analysts at the client site

Tools

MDCMS

Turnover

X-Analysis

ROBOT job scheduler

iSeries Navigator

Job description

Job Summary

This AS400 Developer with EDI role requires excellent programming skills on the iSeries platform with a focus on analyzing and creating new programs using RPG, RPG ILE, SQLRPGLE, and Control Language (CLP/CLLE). The position demands knowledge and hands‑on experience working on the EDI platform on iSeries, with an understanding of various EDI transaction types such as 810, 850, 820, and 856, preferably with Trusted Link knowledge. The role involves very good knowledge of SQL concepts to analyze and modify complex SQL queries, embed SQL in SQLRPGLE, and perform cursor programming. Database concepts expertise is required to create and analyze physical files, logical files, SQL tables, indexes, views, and stored procedures. The position requires good working knowledge of screen programming, including display files, subfiles, and printer files, as well as the ability to document business rules effectively and create data‑mapping documents after analyzing program flows and data flows. ILE programming expertise is needed to analyze and create program modules, binding directories, and service programs. Working knowledge of message queue (MQ), MQ triggers, and embedding XML tags in RPG programs is essential. The role will involve owning a project task completely based on communication with the analysts at the client site and requires good communication skills.

Required Skills

• Excellent programming skills on the iSeries platform
• Analyze and create new programs using RPG, RPG ILE, SQLRPGLE, and Control Language (CLP/CLLE)
• Knowledge and hands‑on experience working on the EDI platform on iSeries
• Knowledge of various EDI transaction types like 810, 850, 820, 856, etc., preferably with Trusted Link
• Very good knowledge of SQL concepts
• Analyze and modify complex SQL queries
• Embed SQL in SQLRPGLE and cursor programming
• Database concepts including creating and analyzing physical files, logical files, SQL tables, indexes, views, and stored procedures
• Good working knowledge of screen programming, including display files, subfiles, and printer files
• Document business rules effectively
• Create data‑mapping documents after analyzing program flows and data flows
• ILE programming to analyze and create program modules, binding directories, and service programs
• Working knowledge of message queue (MQ), MQ trigger, and embedding XML tags in RPG programs
• Good communication skills
• Own a project task completely based on communication with analysts at the client site

Preferred Skills

• Good working knowledge of MDCMS and Turnover—the code configuration management tool
• Good working knowledge of X‑Analysis, a cross‑reference tool for iSeries
• Knowledge of triggers, message queuing for inter‑program/inter‑system communication
• ROBOT job scheduler knowledge, including creating and setting up scheduled jobs in iSeries
• Knowledge of normalized, denormalized tables, and Star Schema databases
• Working knowledge of iSeries Navigator to run queries and analyze the performance of SQL queries
• Knowledge in the retail domain, especially in areas like merchandising, warehouse management, and distribution

Benefits

• Medical, Vision, and Dental Insurance Plans
• 401(k) Retirement Fund

Contract Details

• Position type: Contract
• Start: As Soon As Possible
• Duration: 3 months
• Pay rate: $55 per hour

Location

Issaquah, WA

Job Number

26‑03543