• RPG SQL Microsoft Data Transformation Trouble…

    COOLSOFT (Bismarck, ND)


    RPG SQL Microsoft Data Transformation Trouble Shooting PC Analyst

     

    (Jobs in Bisma

     

    Requirement id 156249

     

    Job title Analyst

     

    Job location in Bismark, ND

     

    Skills required Hands-On Development, IBM AS/400, RPG, SQL Microsoft Data Transformation Troubl

     

    Open Date 09-Dec-2025

     

    Close Date

     

    Job type Contract

     

    Duration 6 Months

     

    Compensation DOE

     

    Status requirement ---

     

    Job interview type ---

     

    Email Recruiter:coolsoft

     

    Job Description Analyst: Hands-On Development, IBM AS/400, RPG, SQL Microsoft Data Transformation Troubl

     

    Start date : 02/02/2026

     

    End Date : At least 6 Months from projected start date

     

    Submission deadline : 12/15/2025 3:00:00 PM

     

    Client Info : ITS

    Note:

    * Interview Process: Virtual Teams with camera on

    * Duration of the Contract: approximately 6 months

    * Onsite or Remote?

     

    Local candidates for flexible hybrid schedule preferred, but open to remote

    Description :

    Estimated Duration: 6 months

     

    Estimated Start Date: February or March 2026

     

    Position place: Preferably Hybrid, are open to remote.

     

    Years of Experience: Minimum of three (3) years of experience

    Summary:

    The Application Systems Analyst / Programmer will analyze and enhance data exports from an IBM AS400 (iSeries) system to support operational needs. This role requires strong AS400 expertise, data analysis skills, and the ability to develop new export processes if existing files are insufficient.

    Responsibilities:

    • Review and analyze flat files exported from AS400 systems for usability in operational workflows.

    • Identify gaps or issues in current export structure and recommend solutions.

    • Design and develop replacement export files if necessary, ensuring compatibility with downstream systems.

    • Collaborate with business stakeholders to understand operational requirements and data needs.

    • Perform testing and validation of new or modified export processes.

    • Document technical specifications and procedures for future reference.

    • Compliance with any related state IT standards and requirements.

    • Participate in project work, as directed by the program manager, and as assigned by the project management team, the approved project plans, and the approved project schedules.

    Required Skills:

    • Hands-on experience with IBM AS400 (iSeries) systems and data export processes.

    • Proficiency in RPG, SQL, CL, and other AS400 programming languages (required).

    • Strong understanding of flat file structures and data transformation.

    • Ability to troubleshoot and optimize data workflows.

    • Excellent communication and documentation skills.

     

    Call502-379-4456 Ext 100for more details. Please provide Requirement id: 156249 while calling.

     

    EOE Protected Veterans/Disability