AS400 Developer

Job Description

Must-Have:

• 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.
• 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 ability to own a project task based on communication with analysts at the client site.
• Good working knowledge in code configuration management tools.
• 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.
• Knowledge in the Retail Domain especially in areas like Merchandising, Warehouse Management, Distribution, etc.

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.