Master information

Cloud Azure Engineer - ETL, SQL data marts, Python

Position: Not specified

Start: As soon as possible

End: Not specified

Location: Toronto, Canada

Method of collaboration: Project only

Hourly rate: Not specified

Latest update: Jun 19, 2024

Task description and requirements

Role: Azure Developer 

Location: Toronto 




Undergraduate Degree or Technical Certificate.

 • A minimum of 5 years experience with large SQL data marts. 

 • Expert relational database experience.

 • Canditate should demonstrat 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 Databricks; establishing the cloud connectivity between different system like ADLS ,ADF, Synapse, Databricks etc.

 • Minumum 5 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 tunning, 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

Category

Engineering science