SQL/SSIS Developer

Evolver Commercial•Sf, CA

2d•Remote

About The Position

Evolver is seeking a SQL/SSIS Developer to work in San Francisco Bay Area or remote. This role involves the development and migration of ETL processes using SSIS, batch automation, building pipelines with Azure Data Factory, data integration with Snowflake, coding and optimization of SQL Server stored procedures, triggers, and functions, and development of SQL Server Reporting Services and custom reports. The position also includes database testing and implementation of SQL Server security best practices.

Requirements

7 years development production support of ETL integration with at least 2 years in a senior role.
7 years of writing and implementing codes in SQL from scratch.
7 years of development experience with data integration toolsets and writing and maintaining ETL jobs
7 years of experience with SQL Server Integration Services
7 years of experience with SQL Server 2018 and later.
Bachelor's degree in Computer Science, Computer Engineering, Computer Information Systems, Information Technology or related field.

Nice To Haves

Azure Data Factory is highly preferred
Snowflake is nice to have but not a must
Solid experience with SQL Server Integration Services (SSIS).
Senior level experience with SQL/TSQL and ability to create and tune queries.
Solid experience writing SQL code and implementing same.
Experience with Azure Data Factory is desired
Solid experience with optimizing database systems.
Experience with database administration skills like backup and recovery, mirroring/high availability, replication, table partitioning, and index tuning.
Strong attention to detail with excellent analytical, problem solving, and communication skills.
Financial services experience is a plus.

Responsibilities

Development of ETL processes with SQL Server Integration Services (SSIS).
Migration and upgrades of SSIS packages.
Batch automation of ETL Processes.
Build pipelines with Azure Data Factory.
Data integration using Snowflake databases
Coding and optimization of SQL server stored procedures, triggers and functions.
Development of SQL Server Reporting Services and custom coded reports.
Database testing to ensure programming changes are functional and meet client requirements.
Implementation of SQL Server security best practices.