• Looking for a talented and creative iSeries/AS400 Developer for Application Development and Solutions support
• 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, SQL Sprocs
• 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 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

Database Concepts - Create and Analyze Physical files, Logical Files, SQL tables, Indexes, Views, Stored procedures