Overview
On Site
Depends on Experience
Contract - Independent
Contract - W2
Skills
iSeries
AS400
RPGL
SQL
SQLRPGLE
Retail
Merchandising
Warehouse Management
CLP
CLLE
Job Details
Position: AS400 Programmer
Location Issaquah, WA,
Must Have Skills
- Skill 1 iSeries/AS400
- Skill 2 - RPGL
- Skill 3 SQL
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.
- Good working knowledge on iSeries.