Role: SQL Developer

Location: Toronto, ON

Duration: Contract

Job Description:

Desirable Skills:

Undergraduate Degree or Technical Certificate.

A minimum of 7 years' experience with large SQL data marts. Expert relational database experience, Candidate should demonstrate ability to navigate through massive volumes of data to deliver effective and efficient data extraction, design, load, and reporting solutions to business partners,

Strong knowledge of Extraction Transformation and Loading (ETL) processes using frameworks like Azure Data Factory or Synapse or Data bricks; establishing the cloud connectivity between different system like ADLS, ADF, Synapse, Data bricks etc.

Minimum 7 years of troubleshooting and Supporting large databases and testing activities; Identifying reporting, and managing database security issues, user access/management; Designing database backup, archiving and storage, performance tuning, ETL importing large volume of data extracted from multiple systems, capacity planning

Experience in TSQL programming along with Azure Data Factory framework and Python scripting;

Financial institution data mart experience is an asset.

Experience in .net application is an asset

Experience and expertise in Tableau driven dashboard design is an asset

Work well independently as well as within a team

Proactive, organized, excellent analytical and problem-solving skills

Flexible and willing to learn, can-do attitude is key

Strong verbal and written communication skills