AS/400 Technical Lead Data Extraction

Key Roles & Responsibilities:

• 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

Nice to Have: Manufacturing / Supply Chain experience

Shift: 1:00 PM 10:30 PM