Job Description
Required Skills:
Overall, 5-8 years of experience in which minimum 5 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) and Snowflakes SNOWSQL.
Experience in one of ELT/ETL tools DBT, Fivetran, Stitch, Matilion
Good to have working knowledge on cloud storage technologies like Azure Blob/AWS S3/GCP, Redshift.
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 is an additional advantage.
Able to do complex Transformations using ETL tools.
Should have experience with multiple reporting tools.
Excellent written and verbal communication skills.
Employement Category:
Employement Type: Full time
Industry: IT
Functional Area: IT
Role Category: Software Engineer
Role/Responsibilies: Snowflake Developer
Contact Details:
Company: Smart Search Solutions
Location(s): Hyderabad