Job Responsibilities and Requirements:
· 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, and cursor programming.
· Database Concept: 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
Experience level: 5 years
Schedule: Monday to Friday
Ability to Commute: Issaquah, WA (Required)
Work Location: In person
Experience:
- iSeries platform (RPG, RPG ILE, SQLRPGLE, and CLP/CLLE): 4 years (Required)
- SQL concepts (SQL queries, embedded SQL in SQLRPGLE): 4 years (Required)
- Database Concepts: 4 years (Required)
- ILE Programming: 4 years (Required)
- Message Queue (MQ) and MQ Trigger: 4 years (Required)
- Turnover: 1 year (Preferred)
- X- Analysis: 1 year (Preferred)
- ROBOT job scheduler: 1 year (Preferred)
- iSeries Navigator: 1 year (Preferred)
- Knowledge in the Retail Domain: 1 year (Preferred)
- AS400: 4 years (Required)