Role: iSeries /AS400 Developer

Location: Issaquah WA (Onsite)

Job type: Contact

Must Have Skills

Skill 1 – iSeries/AS400

Skill 2 - RPG

Skill 3 – SQL

Key Responsibilities:

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.

Interview feedback:

• Lacking SQL knowledge, Lacking ILE concepts, Lacking production support skills
• The candidate has lack of knowledge in ILE concepts and SQL and no hands-on experience in service programs.
• Unable to frame queries using join and No idea on SQL views.
• Missing knowledge on Service modules and subroutines.
• Candidate is not clear on cursor steps & SQL RPGLE code structure.

Job Type: Contract

Pay: $40.00 - $50.00 per hour

Experience level:

• 5 years

Ability to Commute:

• Washington, DC 20018 (Required)

Work Location: In person