Job Summary:
We are seeking a skilled Junior System Analyst with 3–5 years of hands-on experience in AS400 (IBM iSeries) systems, application maintenance, and data integration. The ideal candidate will have strong programming knowledge in RPG IV/ILE, COBOL, and Control Language (CL), along with experience working with DB2 for i databases and automating data export processes.
The candidate will be responsible for maintaining and enhancing existing AS400 applications, automating recurring data export jobs, and supporting integrations between AS400 and external systems using IBM Connect:Direct and SFTP. The role requires strong analytical and troubleshooting skills, effective communication, and the ability to collaborate with cross-functional teams.
Key Responsibilities:
- Maintain, support, troubleshoot, and enhance existing AS400 (IBM iSeries) applications.
- Develop, modify, and maintain programs using RPG IV/ILE, COBOL, and Control Language (CL).
- Work with DB2 for i databases to extract, process, and export data to external databases and platforms.
- Automate recurring data extraction, transformation, and export jobs to improve operational efficiency.
- Configure, support, and troubleshoot file transfers and system integrations using IBM Connect: Direct and SFTP.
- Monitor scheduled jobs, batch processes, and data transfer activities to ensure timely and accurate execution.
- Investigate system issues, perform root-cause analysis, and implement appropriate corrective actions.
- Support application enhancements, bug fixes, and production incidents in accordance with operational requirements.
- Use Jenkins, Bitbucket, and Aldon or equivalent change-management tools to support code management, deployment, and release activities.
- Work across AS400, Linux, and Windows environments to support application operations and integration processes.
- Prepare and maintain technical documentation, job schedules, data flow details, and troubleshooting procedures.
- Collaborate with business users, developers, infrastructure teams, and other stakeholders to resolve issues and deliver system improvements.
Required Skills:
- AS400 / IBM iSeries: Proven hands-on experience supporting and maintaining IBM iSeries applications.
- RPG IV / ILE: Strong programming and debugging skills in RPG-based applications.
- COBOL: Experience maintaining and supporting legacy COBOL applications.
- Control Language (CL): Ability to develop and maintain CL programs, batch jobs, job-control scripts, and automation routines.
- DB2 for i: Familiarity with the native AS400 database, including data retrieval and query execution.
- Data Export and Integration: Practical experience exporting data from AS400 to external databases, platforms, or systems.
- IBM Connect: Direct / SFTP: Experience setting up, supporting, or troubleshooting secure file transfers and system integrations.
- Job Scheduling and Automation: Ability to automate recurring data export jobs and monitor scheduled batch processes.
- Development and Change Management Tools: Familiarity with Jenkins, Bitbucket, Aldon, and source-code or release-control processes.
- Operating Systems: Working knowledge of AS400, Linux, and Windows environments.
- Troubleshooting: Strong analytical, debugging, and problem-solving capabilities.
- Communication and Collaboration: Good verbal and written communication skills, with the ability to work effectively within a team.
Nice-to-Have Skills:
- Experience in Global Data Warehouse (GDW) environments or enterprise data management projects.
- Knowledge of data warehousing concepts, ETL processes, and data reconciliation.
- Experience integrating legacy AS400 systems with modern applications and external platforms.
- Familiarity with SQL and advanced DB2 query techniques.
- Experience with batch-job scheduling, production monitoring, and incident management.
- Exposure to CI/CD practices and automated deployment workflows using Jenkins and Bitbucket.
- Experience with change-management and release tools such as Aldon.
- Knowledge of data quality checks, validation, and reconciliation for exported datasets.
- Familiarity with IT service management practices and production support procedures.