AS400 Developer

· RPGLE Programming: Extensive hands-on experience with ILE and free-format RPGLE, including embedded SQL-RPGLE
· SQL & DB2: Extensive experience with IBM DB2/400, including writing complex SQL queries, joins, and performance tuning
· Database Integration: Skilled in developing and maintaining APIs, Stored Procedures, Service Programs, and User-Defined Functions
· Data Transfer & Transformation: Solid working knowledge of FTP jobs, flat file formatting, and loading into DB2 using RPGLE or CLLE
· Batch Processing: Proficient in batch job programming, processing logic, and debugging of both programs and batch jobs
· Subfiles on iSeries: Experience working with load-all and page-at-a-time Subfiles for interactive screen programming
· iSeries Data & Message Queues: Hands-on experience with iSeries Data Queues and Message Queues for asynchronous communication and inter-process messaging
· System Connectivity: Proficient in connecting and integrating with remote iSeries systems
· UI Maintenance: Experience with maintenance programs and online screen support (nice to have)
Difference between SQL Index and View.
Steps one would take to modify existing RPGLE interactive program to run in batch mode. How would one pass the screen data back to the caller without the interactions.
Benefits of using SQL vs Native I/O, set based vs record at a time processing.
Lack of display file knowledge in terms of how to manually control opening and closing of the display files. This is crucial for our modernization as we are looking for ways to leverage existing programs