Analysis Skills, Communication Skills, Computer Programming, Configuration Management, Data Mapping, Database Administration, Database Technology, Distribution Management, Distribution Warehousing, Embedded SQL, IBM AS-400 Server, Merchandising, Messaging Middleware, Performance Analysis, Printers, Query Analysis, RPG Programming Language, Retail, SQL (Structured Query Language), Schedule Development, Star Schema, Stored Procedures, XML (EXtensible Markup Language)
Job Title:AS400 Developer
Location: Issaquah, WA
Mandatory Areas
Must Have Skills – AS400 Developer
Skill 1 – 8 + Years of exp in As400
Skill 2 – 3 + Years of Exp in RPGLE, SQL
Good To have Skills
Number of days onsite – 3 Days
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.