As400 Programmer

**Job Information**:
Industry

**Banking***

State/Province

**Alexandra Road***

City

**Singapore***

Zip/Postal Code

**119954***

Country

**Singapore***
- Performed analysis and development on new features and enhancements related to Core Retail Banking.
- Provided support on system testing and its environment stability in SIT & UAT.
- Perform analysis related to files routing from main system to AS/400.
- Perform analysis and documentation on reports generated by AS/400 system where data is coming from the main system.
- Developing scripts for loading data from all files/tables of the primary system into the new system (Hadoop platform).
- Create technical specification documents that meet user requirements, including reports and data view based on core tables and views.
- Create SQL queries using FSDs and user requirement specifications to enable users to perform self-service queries and generate reports.
- Develop scripts, reports, job scheduling for online payments project.
- Develop in-house tools to aid in the analysis of the AS/400 system.
- Format printed query definition to Excel file for quick reference (VBA).
- Transform data dictionary html files into single Excel file for quick search of table details such as column name, data type, description (VBA).
- Source Indention for RPG/RPGLE sources downloaded as text file to easily read nested conditions (VBScript).

**Requirements**:

- Bachelor's degree or equivalent the field of computer science, information systems, or equivalent.
- SQL Knowledge is required and mandatory
- Experience in iSeries development and support using RPG, RPGLE, CL and CLLE
- Experience in banking online payment domain is highly preferred.
- Software development/ programming skills in ASP.NET, VB.NET, VB6, Javascript, HTML5, Json, Batch scripting, XML,.NET Framework 3.5 and above, Java.
- Experience with setup, managing and troubleshooting IIS web services and Windows services is a MUST.