Avatar for Stellar Consulting Solutions
Boutique firm solves tech problems with agile business & tech consulting

AS400 Programmer/Analyst

  • Sparta Township
  • |8 years of exp
  • |Contract
Posted: 1 month ago
Job Location
Sparta Township
Remote Work Policy

In office

Visa Sponsorship

Not Available

RelocationAllowed
Skills
RPG
Stored procedures
DDS
Triggers
CLP
ILE
SQL Query Language
User-Defined Functions
IBM Rational Developer for I (RDI)
AS400/DB2
Object-Oriented Programming & Design
IBM Access Client Solutions (ACS)
RPG with Embedded SQL
Warehouse Management System Software

About the job

Title: AS400 Programmer/Analyst

Location: Monroe Township, NJ 08831 (5 days onsite)

Duration: 06 - 12 months contract

Job Responsibilities:

  • 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.