RPG Programmer

Serves as a hands-on programmer/analyst for the organization’s core business systems (IBM i/AS400), developing, maintaining, and modernizing the RPG applications that power the critical retirement administration platforms used by UBG. Translates business requirements into reliable technical solutions and supports the stability of mission-critical systems. Participates in a structured knowledge-transfer program with UBG’s senior systems analyst to build deep familiarity with existing applications, data structures, and business rules, with the expectation of assuming primary development responsibility for the platform over time. Demonstrates a proactive willingness to learn and adapt to new technologies, methodologies, and industry best practices to ensure continuous improvement and future-proofing of business systems. Principal Duties: RPG Development & Maintenance (45%): Develop, maintain, modernize, and extend core applications using RPG (ILE/Free), CL, and SQL. Implement fixes and enhancements to existing programs, and design database structures (DB2 for i) to support evolving business administration needs. Business Analysis & Process Support (20%): Translate business requirements into technical specifications. Analyze existing workflows to recommend and build automated solutions that reduce manual processing time for retirement plan administration. Support user acceptance testing (UAT) for system changes. Knowledge Transfer & Documentation (20%): Absorb and document institutional knowledge of existing systems through structured knowledge transfer. Maintain and expand system documentation in the company’s documentation repository, including program documentation, data flows, integrations, and business rules, so that systems knowledge remains current and transferable. Operational Support & Stability (15%): Support the day-to-day operation of the IBM i environment, including scheduled jobs, file exchanges with external partners, and interfaces with non-IBM i systems. Troubleshoot and resolve production issues, and support backup, restore testing, and security procedures for mission-critical systems.

Core Development: Strong proficiency in RPG (RPGLE and Free Format required; able to read and maintain fixed-format RPG III/IV), CL (Control Language), and DDS. Database Skills: Solid SQL skills, ideally within the DB2 for i environment, including embedded SQL, query construction, and indexing; performance tuning experience is a plus. Integration Skills: Ability to integrate legacy systems with modern applications via APIs, XML, JSON, or secure file transfer. Troubleshooting: Strong debugging and problem-solving skills, including the ability to reverse-engineer undocumented legacy code to implement fixes or enhancements. Communication & Collaboration: Excellent verbal and written communication skills. Works effectively as part of a team with the IT Manager, business analysts, senior technical staff, and external vendors, and documents work so that others can understand and support it.