Generally 3-4 rounds. First round is HR screen (1 hr) to understand interests, past work, salary expectations. Second round is with Engineering managers to know about the role and your pay experience and tech stack. Third is a 1 hour technical and behavioural round to know your past experience with snowflake and AWS followed by two small SQL questions.
Interview questions [1]
Question 1
When do you spin up additional clusters for snowflake? When do you use AWS Glue and Kinesis Kafka? How do u optimize PySpark code or diagnose slow jobs? What is difference between Hadoop/Hive and Snowflake?
Given three relational SQL tables, provide the SQL code to find the user with the highest X amount of something. Follow up question is using Window Functions but cal also solve with CTEs.
Third party/Vendor call for intial details > HR screening round with more on background details > Tech Level 1 round (coding)> Tech Level 2 round > Manager round ( Techincal and behavioral)> HR round
Interview questions [1]
Question 1
There is car table (brand, model,version,year of manufacturing,performace catogery) ,in a file( csv) there is details of performace of each brand in a given year .Find out 3 top performing car in a given year