AS/400 Technical Lead Data Extraction

Bankai Informatics; Hyderabad; On-site; INR 700,000 - 1,250,000; Full time

Job summary

Bankai Informatics in Hyderabad, India, seeks an AS/400 developer to extract and analyze data and design RPGLE/CLLE/SQL-based solutions for business requirements.

You will work with DB2/400, DDS files, stored procedures, and complex queries, and prepare technical design, estimations, and specifications while coordinating with stakeholders and supporting production issues. Shift: 1:00 PM to 10:30 PM.

Qualifications

• Must have AS/400 / IBM i expertise and hands-on RPGLE/RPG IV development.
• Proficient in CLLE/CL and DB2/400 with strong SQL skills (SQL/400, QUERY/400).
• Experience in data extraction, DDS files, and stored procedures.
• Knowledge of ILE, Service Programs, modules and performance tuning.
• Ability to engage with business stakeholders and provide estimations.
• Nice to have: Manufacturing / Supply Chain domain exposure.

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.

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 / M?

Performance tuning

Technical design & estimation

Business stakeholder interaction

Job description

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