Job Title : Data Engineerwith Python DataBricks and Snowflake
Location : Montreal QC or Mississauga ONHybrid
No. of positions : 2
Exp : 814years
willing to relocate toMississauga or Montreal
Responsibilities
Handson development experience with Snowflake featuressuch as Snow SQL; Snow Pipe; Python; Tasks; Streams; Time travel;
Zero Copy Cloning; Optimizer; Metadata Manager; data sharing; andstored procedures.
- Experience in Datawarehousing OLTP OLAP Dimensions Facts and Datamodeling.
- Need to have working knowledge of MSAzure configuration items with respect to Snowflake.
- Developing EL pipelines in and out of data warehouseusing combination of Data bricks Python and Snow SQL.
- Strong understanding or Snowflake on Azure Architecturedesign implementation and operationalization of largescale data andanalytics solutions on Snowflake Cloud Data Warehouse.
- Developing scripts UNIX Python etc. to Extract Load andTransform data as well as other utility functions.
- Provide production support for Data Warehouse issues suchdata load problems transformation translation problems
- Translate mapping specifications to data transformationdesign and development strategies and code incorporating standardsand best practices for optimal execution.
- Understanding data pipelines and modern ways ofautomating data pipeline using cloudbased testing and clearlydocument implementations so others can easily understand therequirements implementation and test conditions.
- Perform code reviews to ensure fit to requirementsoptimal execution patterns and adherence to establishedstandards.
Requirements :
- Minimum 8 yearsof designing and implementing an operational production gradelargescale data solution on Microsoft Azure Snowflake DataWarehouse.
- Including hands on experience withproductionized data ingestion and processing pipelines using PythonData bricks Snow SQL
- Excellent understanding of Snowflake Internals andintegration of Snowflake with other data processing and reportingtechnologies
- Excellent presentation andcommunication skills both written and verbal ability to problemsolve and design in an environment with unclearrequirements.
6 days ago