SSIS ETL Developer

EDI Specialists - Jacksonville, FL

Full-time

Onsite - Jacksonville, FL

Professional, Scientific, and Technical Services

About the position

The SSIS ETL Developer will be responsible for developing SQL Server Integration Services (SSIS) programs to facilitate data integration across multiple applications. This role requires expertise in SSIS to create efficient data extraction, transformation, and loading (ETL) processes. The position is primarily onsite, with a focus on direct hire, although it can be a contract-to-hire opportunity.

Responsibilities

• Develop SQL Server Integration Services (SSIS) programs for data integration.
• Create data extraction-transformation-load (ETL) functions using SSIS.
• Design and develop data transformation solutions using various SSIS components.
• Write performant SQL queries, stored procedures, views, and sub-queries.
• Tune queries for optimal performance.
• Collaborate with team members and communicate effectively to solve problems.

Requirements

• Expertise in SSIS, including Merge, Joins, Expressions, and Error Handling.
• Familiarity with project deployment models and Integration Services Catalog.
• Experience in scripting within SSIS using C# or VBA.
• Proficient in writing complex SQL queries and stored procedures.
• Experience with query tuning and performance optimization.
• Strong self-starter with problem-solving skills.
• Excellent communication and interpersonal skills.

Nice-to-haves

• Experience with big data technologies.
• Familiarity with NetSuite.