The coding assessment on the HackerRank platform -> technical round -> managerial round
The cosing assessment was related to a data science problem. We were asked to solve the problem using any ML model and then explain our approach.
I applied through an employee referral. The process took 6 weeks. I interviewed at Snowflake (San Mateo, CA) in Mar 2024
Interview
There were total 3 rounds.
1st Senior Data Engineer, 2 leetcode, 1 easy , 1 medium, questions on ETL cycle.
2nd was a Manger from India, mainly questions regarding my project and resume, he really liked me
3rd - Hiring manager, 15 mins only, asked 1 sql query, I fumbled.
Interview questions [1]
Question 1
EtL Cycles, SQL Queries, Resume based, flatten an array, string match