HR call, Phone screen, and VO almost 4 loops. signed NDA so cant tell detail, but this role mostly request you have a great fundation of sql and python. and they are not requiring you to know fancy algo but they want you to extremly knowing data structure and how you can use SQL to calculate metrics.
Interview questions [1]
Question 1
LC M Questions but cant use window function to solve.
Wen through standard screening call then the TA. The TA was a much higher difficulty then the prep guide. Not so much the difficulty of the question from a technical perspective, but understanding what the question was actually asking for. Example would be a problem like bookstore checkout system, but the explanation of it was sort of vague and the interviewer didn't really help me clear it up.
Starts with a screen, followed by leetcode style SQL+Python questions, Full loop of SQL, Python, SQL plus Python and lastly behavioural round. Every round is also an architecture round in some sense.
Begins with an application review and recruiter screening, followed by a technical phone interview that assesses SQL, data modeling, data warehousing, ETL processes, and coding skills in languages such as Python or Java. Successful candidates then proceed to onsite or virtual interviews, which include multiple rounds covering coding, system design, data architecture, problem solving, and behavioral questions.
Interview questions [1]
Question 1
Tell us about yourself and why you want to work for us