SQL/SSIS Developer

Evolver Inc.
San Francisco, United States of America
10 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior
Compensation
$ 160K

Job location

San Francisco, United States of America

Tech stack

Computer Programming
Databases
Computer Engineering
Data Integration
ETL
Database Testing
Microsoft SQL Server
Standard Sql
SQL Stored Procedures
SQL Databases
SQL Server Reporting Services
SQL Server Integration Services
T-SQL
Azure
System Availability
Delivery Pipeline
Snowflake
Database Optimization
Information Technology

Job description

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

Requirements

Do you have experience in Production systems?, Do you have a Bachelor's degree?, * 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.

Preferred Qualifications

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

Benefits & conditions

3.93.9 out of 5 stars San Francisco, CA Hybrid work $150,000 - $160,000 a year - Full-time, Pulled from the full job description

  • Parental leave
  • 401(k)
  • Health insurance
  • Paid time off
  • Vision insurance
  • Dental insurance
  • Flexible spending account, Actual salary will depend on factors such as skills, qualifications, experience, market and work location. The client offers benefits, including health, dental and vision insurance, 401(k), flexible spending account, and paid leave (including PTO and parental leave) in accordance with our applicable plans and policies. The salary for this position in San Francisco Bay Area is $150,000 - $160,000 USD.

Apply for this position