iSeries / AS400 Developer jobs in United States
cer-icon
Apply on Employer Site
company-logo

Saransh Inc ยท 7 hours ago

iSeries / AS400 Developer

positionIssaquah, WA
timeContract
remoteHybrid
seniorityMid Level

Saransh Inc is seeking a talented and creative iSeries/AS400 Developer for Application Development and Solutions support. The role involves analyzing and creating new programs using RPG, SQLRPGLE, and Control Language, along with modifying complex SQL queries and managing database concepts.

EmploymentInformation TechnologyStaffing Agency
check
H1B Sponsor Likelynote

Responsibilities

Excellent programming skills on the iSeries platform - Analyze and Create new programs using RPG, RPG ILE, SQLRPGLE, and Control Language (CLP/CLLE)
Very good knowledge of SQL concepts - Analyze and modify complex SQL queries, embedded SQL in SQLRPGLE, Cursor programming, SQL Sprocs
Database Concepts - Create and Analyze Physical files, Logical Files, SQL tables, Indexes, Views, Stored procedures
Good working knowledge in screen programming - Display Files, Subfiles, and Printer files
Document business rules effectively and should be able to create data mapping documents after analyzing program flows and data flows
ILE Programming - Analyze and Create program modules, binding directories, service programs
Working knowledge of Message Queue (MQ), MQ Trigger, and embedding XML tags in RPG Programs

Qualification

AS400RPGLSQLISeriesILE ProgrammingDatabase ConceptsScreen ProgrammingMessage QueueTurnoverX-AnalysisTriggersROBOT job schedulerRetail DomainISeries Navigator

Required

AS400
RPGL
SQL
iSeries
Excellent programming skills on the iSeries platform - Analyze and Create new programs using RPG, RPG ILE, SQLRPGLE, and Control Language (CLP/CLLE)
Very good knowledge of SQL concepts - Analyze and modify complex SQL queries, embedded SQL in SQLRPGLE, Cursor programming, SQL Sprocs
Database Concepts - Create and Analyze Physical files, Logical Files, SQL tables, Indexes, Views, Stored procedures
Good working knowledge in screen programming - Display Files, Subfiles, and Printer files
Document business rules effectively and should be able to create data mapping documents after analyzing program flows and data flows
ILE Programming - Analyze and Create program modules, binding directories, service programs
Working knowledge of Message Queue (MQ), MQ Trigger, and embedding XML tags in RPG Programs

Preferred

Good working knowledge in Turnover - the code configuration management tool
Good working knowledge in X- Analysis - cross-reference tool for iSeries
Knowledge of Triggers, Message Queuing for inter-program/ inter-system communication
ROBOT job scheduler - knowledge in creating and setting up scheduled jobs in the iSeries
Knowledge of normalized, denormalized tables, Star Schema databases
Working knowledge on iSeries Navigator - to run queries and analyze the performance of SQL queries
Knowledge in the Retail Domain especially in areas like Merchandising, Warehouse Management, Distribution,etc

Company

Saransh Inc

twittertwittertwitter
company-logo
We provide recruitment, consulting and IT services for our clients, which focus on maximizing their revenue generation, enhancing business productivity and improving cost management.
dateFounded in 2008
location
Plainsboro, New Jersey, USA
people-size51-200 employees
web-link
https://saranshinc.com

H1B Sponsorship

Saransh Inc has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (35)
2024 (51)
2023 (45)
2022 (30)
2021 (22)
2020 (39)

Funding

Current Stage
Growth Stage

Leadership Team

leader-logo
Sridhar Chimaladinne
FOUNDER & CEO
linkedin
Company data provided by crunchbase