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 [email protected] 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