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