As/400 Consultant

Role – AS400 Developer

Location – Issaquah, WA (Fully Onsite)

Must Have Skills –

• Excellent programming skills on the iSeries platform 5+ years

• SQL concepts 5+ years

• Database Concepts 5 years

• screen programming – Display Files, Subfiles, and Printer files. 5 years

Must-Have:

• Excellent programming skills on the iSeries platform – Analyze and Create new programs using RPG, RPG ILE, SQLRPGLE, and Control Language (CLP/CLLE).

• Very good knowledge of SQL concepts – Analyze and modify complex SQL queries, embedded SQL in SQLRPGLE, Cursor programming.

• Database Concepts – Create and Analyze Physical files, Logical Files, SQL tables, Indexes, Views, Stored procedures.

• Good working knowledge in screen programming – Display Files, Subfiles, and Printer files.

• Document business rules effectively and should be able to create data mapping documents after analyzing program flows and data flows

• ILE Programming – Analyze and Create program modules, binding directories, service programs.

• Working knowledge of Message Queue (MQ), MQ Trigger, and embedding XML tags in RPG Programs

• Good communication skills and the job will involve owning a project task completely based on the communication with the analysts at the client site

Good to Have:

• Good working knowledge in Turnover – the code configuration management tool

• Good working knowledge in X- Analysis – cross-reference tool for iSeries.

• Knowledge of Triggers, Message Queuing for inter-program/ inter-system communication

• ROBOT job scheduler – knowledge in creating and setting up scheduled jobs in the iSeries.

• Knowledge of normalized, denormalized tables, Star Schema databases

• Working knowledge on iSeries Navigator – to run queries and analyze the performance of SQL queries.

• Knowledge in the Retail Domain especially in areas like Merchandising, Warehouse Management, Distribution, etc.

Job Type: Contract

Pay: From $62.00 per hour

Expected hours: 40 per week

Benefits:

• 401(k)
• Dental insurance
• Health insurance

Compensation package:

• Hourly pay

Experience level:

• 10 years

Schedule:

• 8 hour shift

Experience:

• AS400: 10 years (Required)
• RPG: 5 years (Required)
• SQL: 5 years (Required)

Ability to Commute:

• Issaquah, WA 98027 (Preferred)

Ability to Relocate:

• Issaquah, WA 98027: Relocate before starting work (Required)

Work Location: In person