Description

Develop and maintain applications on the iSeries platform, focusing on RPG, SQL, and database management.

Build new programs using RPG, RPG ILE, SQLRPGLE, and Control Language (CLP/CLLE). Analyze and modify complex SQL queries, embedded SQL, cursor programming, and SQL stored procedures. Manage database objects including physical files, logical files, SQL tables, indexes, and views. Develop screen interfaces using display files, subfiles, and printer files. Document business rules and create data mapping documents by analyzing program and data flows.

Responsibilities

• Build new programs using RPG, RPG ILE, SQLRPGLE, and Control Language (CLP/CLLE).
• Analyze and modify complex SQL queries, embedded SQL, cursor programming, and SQL stored procedures.
• Manage database objects including physical files, logical files, SQL tables, indexes, and views.
• Develop screen interfaces using display files, subfiles, and printer files.
• Document business rules and create data mapping documents by analyzing program and data flows.

Required Skills

• 8+ years of experience in iSeries/AS400 development.
• Extensive experience with RPG, RPG ILE, SQLRPGLE, and CLP/CLLE.
• 3+ years of experience with SQL.
• Proficiency in ILE programming, including program modules, binding directories, and service programs.
• Experience with Message Queue (MQ), MQ Triggers, and embedding XML tags in RPG programs.
• Strong knowledge of database concepts and file management.
• Bachelor's Degree.

Key Skills

Education

Bachelor's Degree