AS400 Developer

Job Description

• 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 MDCMS, 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.