Remote Role - SSIS ETL Developer with State of Louisiana

Vinsys Information Technology Inc; United States; Remote; USD 90,000 - 120,000; Full time

Job summary

A leading company is seeking an SSIS ETL Application Developer for a remote position with the State of Louisiana. The role involves analyzing data conversion requirements, developing SSIS modules, and providing technical guidance. Candidates should have 3+ years of experience in application development, particularly with SSIS and SQL, and be comfortable working in an Agile/Scrum environment.

Qualifications

• 3+ years of experience in application development focusing on SSIS and ETL tools.
• Experience working in relational database environments and Agile/Scrum.
• Strong problem-solving skills and excellent communication abilities.

Responsibilities

• Analyze and document data conversion requirements and develop SSIS modules.
• Create and execute complex SQL queries for data validation.
• Provide technical knowledge transfer and mentorship to State personnel.

Skills

SSIS

SQL

Data Analysis

Agile/Scrum

Problem-solving

Communication

Tools

GitHub

JIRA

Job description

Remote Role - SSIS ETL Developer with State of Louisiana

Hope you are doing well. We have an open position for a SSIS ETL Application Developer. Please review the description below and let us know your interest. If interested, kindly share your resume at [e-mail] along with your rate/salary expectations and the best time to contact you.

Requisition: SR-5233811

Client: State of Louisiana

Location: Remote

Duration: Long-term

Key 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 independently.
• 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.

Required Skills & Experience

• 3+ years of experience in application development focusing on:
• SSIS (SQL Server Integration Services) and ETL tools
• Complex SQL query development
• SQL Server environments
• Creating and maintaining SQL Server Agents (SSA)
• Experience working in relational database environments
• At least 2 years of experience working in an Agile/Scrum environment

Preferred Skills

• Experience with GitHub version control, including complex branching strategies
• Previous experience with data conversion projects and processes
• Experience identifying and resolving data quality issues
• Experience with large-scale public sector IT projects
• Familiarity with JIRA
• Experience with mainframe systems and Lotus Notes applications
• Strong problem-solving and troubleshooting skills
• Excellent interpersonal, verbal, and written communication skills
• High attention to detail and accuracy
• Ability to articulate complex concepts clearly
• Strong organizational, multi-tasking, and prioritization skills

Additional Details

• Seniority level: Mid-Senior level
• Employment type: Contract
• Job function: Business Development and Sales
• Industries: Software Development, Executive Offices, IT Services, and Consulting

Referrals can increase your chances of interviewing at Vinsys Information Technology Inc. by 2x.

Stay updated on new ETL Developer jobs in United States.