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 referencesCopies 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!!!
