Senior Application Programmers

TriTech Enterprise Systems, Inc.; Baton Rouge (LA); Remote; USD 80,000 - 120,000; Full time

Job summary

TriTech Enterprise Systems, Inc. is seeking a Senior Application Programmer to support the State of Louisiana contract. This remote position requires expertise in ETL tools, SQL, and Agile methodologies. The role involves analyzing data conversion, developing modules, and providing technical guidance. Candidates should have strong problem-solving skills and experience in application development.

Qualifications

• 3+ years experience in application development with ETL tools.
• Experience in SQL server environments and Agile/Scrum.
• Strong problem-solving and communication skills.

Responsibilities

• Analyze and document data conversion requirements.
• Develop program modules using SSIS and SQL.
• Participate in Scrum ceremonies and provide knowledge transfer.

Skills

SQL

ETL

SSIS

Agile

Problem-solving

Communication

Tools

GitHub

JIRA

Job description

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 aSenior Application Programmerto support the State of Louisianacontract.

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

1. Resume(Word Format)
2. Salary expectation, and
3. Three professional references
4. 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

TriTechEnterprise Systems is an equal opportunity employer!!!