• Senior Application Programmers

    TriTech Enterprise Systems, Inc. (Baton Rouge, LA)


    TriTech Enterprise Systems, Inc. (TriTech) is always looking for exceptionally bright and motivated success-driven professionals who strive for excellence and are committed to quality performance to join our team. We currently are seeking a Senior Application Programmer to support the State of Louisiana contract.

     

    In addition, this is a remote position.  Please provide the following information, if you are applying for this opportunity:

     

    + Resume (Word Format)

    + Salary expectation, and

    + Three professional references

    + Copies of any IT certification

    * Please Note that all resumes are due by May 23, 2025, by noon. *

    The scope of the proposed services will include the following:

    + Analyze and document the data conversion scope, approach, validated requirements, and the strategy for how the conversion will be performed.

    + Map legacy data files and elements to the new system table(s) and columns. Mapping should include translation rules, foreign key rules, among other pertinent information.

    + Work independently in developing program modules using SSIS ETL tool (SQL Server Integration Services) based on designs/storyboards

    + Create and execute SQL Queries validating and analyzing data directly from various databases

    + Execute team members’ SSIS programs and monitor runtimes

    + Resolve SSIS program errors and program performance issues without assistance from team members

    + Analyze/troubleshoot data integrity issue and data discrepancies

    + Perform code reviews and testing on new code.

    + Test conversion program modules to ensure accuracy

    + Test how the converted data performs within the system

    + Participates in all necessary team meetings and design sessions in accordance with Scrum ceremonies.

    + Provide technical knowledge transfer, training, documentation, mentorship, and guidance to State personnel for all requested work.

    Expertise and/or relevant experience in the following areas are mandatory:

    + Three (3) plus years of expertise and/or relevant experience in the following areas:

    + Working in the application development field with experience using Extract Transform and Load (ETL) tools, development experience using SSIS and writing complex database SQL queries

    + Working in a SQL server environment

    + Creating and maintaining SQL server agents (SSA)

    + Working in a relational database environment

    + Two (2) plus years of experience working in an Agile / Scrum environment

    Expertise and/or relevant experience in the following areas are desirable but not mandatory:

    + Experience with the GitHub Version Control System, including branching strategies for complex systems

    + Experience with conversion projects and processes strongly preferred

    + Experience in identifying and addressing data quality issues

    + Experience with large scale public sector IT projects

    + Experience with JIRA

    + Experience with mainframe systems and lotus notes applications

    + Strong problem-solving, troubleshooting and interpersonal skills

    + Strong verbal and written communication skills

    + Strong attention to detail and accuracy

    + Ability to articulate complex concepts in a clear manner

    + Strong organizational, multi-tasking, and prioritizing skills

     

    TriTech Enterprise Systems is an equal opportunity employer!!!

     

    Powered by JazzHR