Snowflake Data Engineer with DBT

Mandatory Skills- Snowflake Data Warehouse, Python, data build tools (DBT),Matillion and Snowflakes SNOWSQL.

Job description-

JD: Snowflake Data Engineer with DBT

• Overall, 5+ years of experience in which minimum 3 years of DWH experience. 
• Responsible for architecting and implementing business intelligence solutions around Snowflake Data Warehouse. 
• Able to design, develop, and maintain ELT/ETL pipelines in and out of data warehouse using combination of Python, data build tools (DBT),Matillion and Snowflakes SNOWSQL. 
• Good to have working knowledge on cloud storage technologies like Azure Blob/AWS S3/GCP. 
• Should be worked on multiple on-premises relational databases like MYSQL, Oracle and MS SQL server etc. 
• Design, Develop, and maintain data base objects like tables, views, functions, stored procedures, and scripts in snowflake. 
• Good to have knowledge on Java Script to implement procedures in snowflake. 
• Should load data in snowflake using Snow pipes. 
• Should have knowledge on all newly added functionalities in snowflake. 
• Recent experience in writing and tuning complex SQL queries and debugging to support business intelligence functions. 
• Experience in Python code, shell scripts, and complex SQL.
• Experience building robust data pipelines beyond simple API pulls.
• Able to write complex Python scripts to automate various tasks in our day to day operations.
• Have good knowledge and experience in command line tool DBT.
• Able to do complex Transformations using DBT.
• Should have experience on multiple reporting tools.
• Excellent written and verbal communication skills.