Required Skills

SQL databases

Work Authorization

  • US Citizen

  • Green Card

  • EAD (OPT/CPT/GC/H4)

  • H1B Work Permit

Preferred Employment

  • Corp-Corp

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 31st Aug 2022

JOB DETAIL

Job Details:
• 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 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.

Company Information