Etl Developer (Sql, Ssis, Data Model)

*********For a TOP5 Bank in Canada!*********

Job Overview

Title -ETL Developer (SSIS, SQL)

Duration – 3 Months Contract + possible extensions up to 2 years!

Location – *Hybrid - 2 time a week in office, Toronto, ON

Rate: $60-70 per hour INC (Incorporated)

ETL Developer (SSIS, SQL)

Typical Day in Role:

• Conduct source data analysis and profiling to complete source to target mapping

• Perform data wrangling to merge disjointed data sources and implement complex data transformation

• Develop ETL process using MS SQL Server, SSIS package and MS Azure Data Factory to ingest, transform, cleanse and load data into on-prem SQL Server and/or Azure SQL DB

• Investigate data to identify potential issues within ETL pipelines, notify end-users and propose adequate solutions

• Logical and physical data modeling to develop highly optimized data infrastructure for fast querying of large volume of data. Assure data quality, security, and compliance requirements are met

• Prepare documentation for further reference

• Work with Business stakeholders for requirement gathering and collaborate with QA for test cycles

• Conduct performance testing and tuning code for optimization

• Responsible for code deployment to all environments including production

• Provide Production Support for the current environment as requiredCandidate

Requirements/Must-Have skills:

1. 10+ years of experience in working for large projects and have advanced experience with SQL Scripting, ETL architecture, data analysis and profiling, data mapping, data modeling, data lakes, and analytics

2. 5+ years of extensive development experience with SQL Server SSIS, Integration Services Catalog and project deployment

3. 3+ years of experience working with BitBucket or TFS, and creating DevOps pipeline

4. You have experience working with an agile scrum team

Nice-To-Have Skills:

• Experience with Azure ADF and Azure MI

• Experience with static code scans such as Fortify, Blackduck, etc.

• Previous exposure to Banking/Financial Industry backgrounds