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: 2 weeks ago• Recruiter recently active
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.