Remote Role - SSIS ETL Developer with State of Louisiana

Job title: Remote Role - SSIS ETL Developer with State of Louisiana in USA at Vinsys Information Technology Inc

Company: Vinsys Information Technology Inc

Job description: Hope you are doing well. We have an open position for a SSIS ETL Application Developer. Pl. go through the below description and let me know your interest. If you are interested, kindly share a copy of your resume to hr@vinsysinfo.com along with the rate / salary and best time to reach you.Requisition: SR-5233811

Client: State of Louisiana

Location: Remote

Duration: Long-termKey Responsibilities:

• Analyze and document data conversion requirements, approach, and strategy.


• Map legacy data files and elements to new system tables/columns, including translation and foreign key rules.


• Independently develop program modules using SQL Server Integration Services (SSIS) based on provided designs/storyboards.


• Create and execute complex SQL queries for data validation and analysis.


• Execute and monitor team members' SSIS programs; troubleshoot and resolve runtime issues.


• Resolve SSIS program errors and performance issues without assistance.


• Analyze and troubleshoot data integrity issues and discrepancies.


• Review and test new code and conversion program modules for accuracy.


• Test data conversion results within the system.


• Participate in team meetings and Agile/Scrum ceremonies.


• Provide technical knowledge transfer, training, documentation, mentorship, and guidance to State personnel.

• 3+ years of experience in application development with a focus on:


• SSIS (SQL Server Integration Services) and ETL tools


• Complex SQL query development


• SQL Server environments


• Creating and maintaining SQL Server Agents (SSA)


• Working in relational database environments


• 2+ years of experience working in an Agile/Scrum environment

• Experience with GitHub version control, including complex branching strategies


• Previous work on data conversion projects and processes


• Experience identifying and addressing data quality issues


• Experience with large-scale public sector IT projects


• Experience using JIRA


• Experience with mainframe systems and Lotus Notes applications


• Strong problem-solving and troubleshooting abilities


• Excellent interpersonal, verbal, and written communication skills


• High attention to detail and accuracy


• Ability to clearly articulate complex concepts


• Strong organizational, multi-tasking, and prioritization skills

Expected salary:

Location: USA

Apply for the job now!

Apply for this job