Senior BI Developer

Location: Burnaby, BC, Canada
Date Posted: 06-03-2018
Tangentia is a Premier IBM Business Partner & was also awarded as the fastest growing IBM Business Partners for 2012, 2013 & 2014. Our Head office is in Toronto, Canada with offices in US and India as well. You can learn more at

Tangentia is one of the key Implementation partners with IBM and works closely with IBM services groups like GBS, GTS, and ISSW. Tangentia is authorized to sell and implement all IBM software brands across USA, Canada & India. Some of our key strengths are around  Identity & Access Management, IBM security, Sterling Commerce, Cognos, Tivoli, and WebSphere. Tangentia is also a key partner and works closely with the IBM training group.

We are hiring for the following positions, kindly send in your best resources.
Job Title: Senior BI Developer   
Job ID #: 180301
Location:  Burnaby, BC  
Duration: 6 months+
Start Date: ASAP
Interview Type: Phone & Skype

Job Description 
This resource must be a Senior Developer with deep SSIS and integration skills. 
Someone who is a seasoned ETL/data migration leader who can make decisions, be creative in their problem-solving ability, and is responsible 
  • Experience in Database Design, Development and business intelligence using Microsoft SQL Server 2012/2008/2005
  • Expertise in writing T-SQL Queries using joins, Sub queries, stored procedures, views, triggers, functions and Cursors in MS SQL Server 2012/2008/2005.
  • Experience in Extracting, Transforming and Loading (ETL) data from SQL Server, Excel, Flat file to MS SQL Server by using BCP utility, DTS and SSIS services.
  • Expertise in Extraction, Transforming and Loading (ETL) data flows using SSIS 2012/2008/2005
  • Experience with ETL change data capture methodologies and techniques
  • Experience ETL data quality validation for mission critical data migrations
  • Expertise in enhancing and deploying the SSIS Packages from development server to production server.
  • Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions.
  • Experience with Agile development and DevOps will be considered an asset
  • Experience working with law-enforcement related projects, or other highly-sensitive data projects, will be considered an asset.
this job portal is powered by CATS