Experience in data integration activities including: architecting, designing, coding, and testing phases
Architect the data warehouse and provide guidance to the team in implementation using Snowflake SnowSQL and other big data technologies
Hands-on experience with Snowflake utilities, SnowSQL, SnowPipe, Big Data model techniques using Python
Experience in performance tuning of the snow pipelines and should be able to trouble shoot the issue quickly
Extensive experience in relational as well as NoSQL data stores, methods and approaches (star and snowflake, dimensional modeling)
Understanding data pipelines and modern ways of automating data pipeline using cloud based implementation and Testing and clearly document the requirements to create technical and functions specs
Should be able to demonstrate the proposed solution, with excellent communication and presentation skill
Requirements
Experience in designing and implementing a fully operational solution on Snowflake Data Warehouse
Experience with Python and a major relational database.
Excellent understanding of Snowflake Internals and integration of Snowflake with other data processing and reporting technologies
Should be having good presentation and communication skills, both written and verbal
Ability to problem solve and able to convert the requirements to design
Ability to troubleshooting issues as and when arisen.
Work Experience on optimizing the performance of the Spark job
Tech Stack
Cloud
NoSQL
Python
Spark
Benefits
Paid time off based on employee grade (A-F), defined by policy: Vacation: 12-25 days, depending on grade
Company paid holidays
Personal Days
Sick Leave
Medical, dental, and vision coverage (or provincial healthcare coordination in Canada)
Retirement savings plans (e.g., 401(k) in the U.S., RRSP in Canada)
Life and disability insurance
Employee assistance programs
Other benefits as provided by local policy and eligibility