Application Programmer- SQL Position Available In East Baton Rouge, Louisiana

Application Programmer- SQL [Baton Rouge, LA] | 2025-05-07 18:06:15

Job Description Job Title:

Sr.

Application Programmer- SQL Location:

Baton Rouge, LA 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: o 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 o Working in a SQL server environment o Creating and maintaining SQL server agents (SSA) o 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 Application Programmer- SQL1SQL, Agile, etl, Version Control, Documentation, Scrum, Data Quality, jira, Database, Mainframe, Problem-Solving, GitHub, Data Integrity, SQL Queries, SSA, Application Development, Relational Database, Articulate, Data Conversion, Mapping, Lotus Notes C2CUnited States