- Extract and analyze AS/400 data based on business requirements.
- Design/develop RPGLE, CLLE and SQL-based solutions.
- Work with DB2/400, DDS files, stored procedures and complex queries.
- Prepare technical design, estimation and specification documents.
- Analyze application/database performance and perform tuning.
- Work with business stakeholders to understand and resolve requirements.
- Support application enhancements, testing and production issues.
- Contribute to AS/400 modernization initiatives.
- Manufacturing/Supply Chain experience is a plus.
Preferred candidate profile Must-Have Skills:
- AS/400 / IBM i
- RPGLE / RPG IV / Free-Form RPG
- CLLE / CL
- DB2/400
- SQL/400 & QUERY/400
- Data extraction / data retrieval
- DDS Physical & Logical Files
- Stored Procedures & Complex SQL
- ILE Procedures / Service Programs / Modules
- Performance tuning
- Technical design & estimation
- Business stakeholder interaction