Overview

SI Systems SQL Developer Contract in Toronto, ON

SI Systems

Branch Toronto ON CA

Position:
SQL Developer
Location:
Toronto, ON

2 Positions to Fill. Our capital markets client in Mississauga is looking for 2 SQL Developers for a year contract. The successful candidate will be…

2 Positions to Fill.
Our capital markets client in Mississauga is looking for 2 SQL Developers for a year contract. The successful candidate will be responsible for developing ETL solutions developed using SSIS, stored procs, T-SQL and other related SQL server technologies. You will be working with the CRM team to develop data flows and ETL processes for our enterprise data warehouse and various data marts throughout the business. We are looking for a developer with strong technical knowledge in the SQL Server platform and data warehousing, with a love for data!

Responsibilities:
Interaction with business and team lead to understand the business requirements

  • Produce high quality Technical & Release documents
  • Design & develop ETL processes, data flows and cubes
  • Produce data outputs/reports/analsys
  • Provide technical walk through to various stake holders (QA Team, UAT Team, etc)

Must Haves:

  • Experience in Analysis, Design, Development, Testing and Implementation (all phase of software development life cycle – SDLC)
  • Very strong working experience in T-SQL, SSIS
  • Expert knowledge of database management systems
  • Good understanding of ETL & data warehousing concepts
  • Have exposure to BI/Reporting platforms such as Business Objects
  • 5-10 years working experience in developing SSIS packages, cubes and stored procs on SQL platform
  • Experience in creating technical design documents, including data modelling and flow diagrams.
  • Expert ability to write SQL queries on MS SQL Server
  • Database performance optimization experience
  • Good understanding of in data modelling (relational, and dimentional)

Specialization and Skills:
DBA
Data Warehousing
8 – 10 years

ETL
8 – 10 years

MS SQL Server
8 – 10 years

Additional Requirements:
Please describe your experience debugging and optimizing stored procedures
(Must-have)

Please describe your experience developing SSIS packages, cubes and stored procedures on MS SQL platform
(Must-have)

Please describe your level (beginner to expert) of writing SQL queries on MS SQL Server
(Must-have)

Work Environment:

or proceed with Standard Application Form.

Employment Type: Freelance
Location: Toronto, ON, CA
Posted on: 2016-12-05
Posted by: