Mississauga, Ontario, Canada, Canada
August 24, 2024
Apply NowJob description
- Undergraduate Degree or Technical Certificate.
- A minimum of 5 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 Databricks; establishing the cloud connectivity between different systems like ADLS, ADF, Synapse, Databricks etc.
- Minimum 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 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
- Undergraduate Degree or Technical Certificate.
- A minimum of 5 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 Databricks; establishing the cloud connectivity between different systems like ADLS, ADF, Synapse, Databricks etc.
- Minimum 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 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
