I got an online assessment and I was expected to answer from a bank of questions in a little over an hour. Expect to be asked a lot of general knowledge from the tech stack (SQL, Python, Pyspark) and prep to also answer some leetcode style questions.
Interview questions [1]
Question 1
SQL: Calculate the total annual sales for each employee. Then, find the employee with the highest total sales.