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