Iseries/AS400 Programmer C2C jobs Hybrid role in WA

Role- Iseries/AS400 Programmer

Location- Issaquah, WA

Duration: 12+ Months

Must Have Skills-

Skill 1 – Strong experience in AS400
Skill 2 – Good Handson Programming experience in SQL
Skill 3 – Solid understanding on ILE concept
Skill 4 – Knowledge on Iseries.

Job description-

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.