AS400 Developer

Stellar Consulting Solutions, LLC; Monroe (NJ); On-site; USD 90,000 - 130,000; Full time

Job summary

Stellar Consulting Solutions, LLC seeks an AS400 Developer in Monroe Township, NJ for a contract role. The Sr Programmer/Analyst will design and develop new applications and maintain existing ones, collaborating with Operations and business partners.

The role focuses on modernizing brownfield systems, improving productivity in the distribution center, and delivering reliable IT solutions within budget and timeline constraints.

Qualifications

• 8+ years hands-on RPG development on iSeries and AS/400 systems.
• Experience with DB2 on IBM i and relational databases.
• Proficiency with SQL, stored procedures, triggers, and user-defined functions.
• Knowledge of logistics/fulfillment processes and warehouse systems is a plus.

Responsibilities

• Works with DC Operations to identify improvements that boost productivity and reduce costs.
• Modernizes brownfield applications to align with current industry patterns and practices.
• Analyzes system data with DC Operations to define issues and enhancements and provide solutions.
• Delivers business solution design across a wide range of technologies.
• Provides technical input to the development team and IT management while supporting end users.
• Ensures applications and processes are well-documented, tested, and reliable.
• Designs solutions meeting business requirements and constraints of time and budget.
• Works independently with minimal supervision.

Skills

iSeries RPG

RPG with embedded SQL

CLP

ILE

DDS

DB2 on AS/400

SQL Server

Oracle

Stored procedures

Triggers

User-defined functions

AC S & RDi tools

.NET / C# / ASP.NET

Java J2SE/J2EE

HTML/XML web tech

Tools

Visual Studio Code

Code for i

IBM Rational Developer for i (RDi)

IBM Access Client Solutions (ACS)

Job description

AS400 Developer - Monroe Township, NJ - Contract

Address: 1 Barnes and Noble Way, Monroe Township, NJ 08831

Contract

Sr Programmer/Analyst

Applications Development Manager

N/A

The Sr. Programmer/Analyst is responsible for the design and development of new applications as well as providing support and maintenance of existing applications and interfaces. The Sr. Programmer/Analyst also interacts regularly with members of operations and external business partners. Modernization of brownfield applications to bring them up to current standards and practices is a key part of this role as well. The Sr. Programmer/Analyst seeks a deep knowledge of the business and its IT systems as these are fundamental to the design of the enterprise applications necessary to keep the business running.

• Works directly with the distribution center Operations team to identify, recommend and implement initiatives and solutions that improve productivity and reduce costs in all distribution center processes.


• Modernizes brownfield applications as needed to make them comply with more recent industry patterns, practices, and development methods.


• Analyze the data gathered from the system or working with the DC Operations team, define issues and/or needed enhancements; provide recommendations and solutions that need to be addressed.


• Provides business solution design and implementation in a wide array of technologies.


• Offers technical input and advice to the development team and IT management, while also providing support and input to the end user community towards the solution of business problems within the constraints of time and budget provided by management.


• Ensures that applications and processes are well-documented, thoroughly tested, and operate reliably.


• Designs solutions that meet the requirements as detailed by business users.


• Works and resolves issues independently and with minimal supervision.

• Minimum of 8 years of hands‑on programming experience on the iSeries using fixed and free format RPG, RPG with imbedded SQL, IBM Control Language Programming (CLP), ILE, and DDS.


• Minimum of 8 years of hands‑on experience with Relational Database Management System (specifically AS400/DB2; Microsoft SQL Server or Oracle a plus)


• Candidate should have a deep understanding on the theory and workings of Relational Database systems


• Advanced knowledge of the SQL query language, including query tuning and performance optimization


• Experience in the development of stored procedures, triggers, and user-defined functions.


• Knowledge of logistics or fulfillment processes and techniques, warehouse management system software.


• Experience using IBM Access Client Solutions (ACS) and IBM Rational Developer for i (RDi) Software as development debugging tools.


• Experience in Object-Oriented Programming & Design concepts and methodologies.


• Experience in one of the following a plus:


• Microsoft.NET platform (Microsoft Visual Studio, C# programming language, .NET Framework Base Class Libraries and CLR), plus experience in two or more ancillary.NET technologies such as: ADO.NET, ASP.NET, WCF, WPF, Silverlight, Microsoft Enterprise Library, ADO.NET Entity Framework, or LINQ.)


• Java Development Platform 5.0 or later: J2SE required, J2EE a plus.


• Experience with web- and SOA-related technologies: HTML, XML, XML Schema, XPath, XQuery, WS-* standards (especially WSDL) a plus.


• Experience with Visual Studio Code (and Code for i extension) a plus.


• Strong troubleshooting, problem solving and analytical skills with the ability to clearly communicate and share solutions with fellow team members.


• Experience with the full software development life cycle, including design, testing, deployment, and documentation activities (including detailed process flows).


• Proven experience of refactoring software and databases.


• Sound knowledge of unit testing and load testing.


• Ability to organize and prioritize task assignments.


• Excellent verbal and written skills with the ability to communicate effectively and clearly.


• Exposure to the following system applications a plus: warehouse management, order management, inventory control.