Job Description :
Title: Data Engineer Location: Toronto, ON Mode: Contract Knowledge on SQL server database tables, SQL scripts and relationships. Knowledge on workflow ETLs using SQL SSIS and related addition SharePoint etc. Knowledge on various data source like excel file SharePoint file list etc. Knowledge on data modelling data warehousing and best practice. Understanding a ETLs written in python using framework like pandas NumPy, Jupiter, notebook. Able to write a python script using pandas/NumPy to clean the input data. Able to write a PowerShell /python script to move the data to from SharePoint to manage input output files . Basic skills of agile methodology and Azure Boards. Basic knowledge of a power BI/DAX will be useful as ETL output will be using in power BI dashboard.