1. First round - SQL questions on coderpad where a data model was provided. Not so difficult questions that involved concepts like subqueries, joins, window functions, etc. 2. Second - Was given a table and was asked to recommend what metrics to build to solve a high level problem
Its a repeat of all the virtual process you already went through
The first interview was with the hiring manager and one more person. It was great. The 2nd interview was with a larger team. It went well for most part but there was 1 person that was conducting it as an interrogation. Glad to have not received the offer.
Tell me about a time when you were communicating with someone and there was a misunderstanding.
Basic count with Group by. Another included ranking and averaging the groups based on certain criteria
Paraphrasing - Q: Describe a situation where you had to work with a challenging individual and how you handled it Q: How do you approach your relationship with non-technical users when teaching a technical product?
Why do you want to relocate?
How would you join these two tables and summarize?
3 SQL problem. 3python problem.
Talk about background, how you work on a team, how you learn new tools, etc.
Viewing 2101 - 2110 interview questions