Role
- 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.
- 5+ years work experience in application support or equivalent using problem resolution and root cause analysis techniques. In depth knowledge of Wintel application and troubleshooting methods.
- 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.