There were three separate 60 minute remote sessions. A basic live pyspark coding exercise (leetcode style), a systems design exercise (using miro), and a classic Q & A of standard HR behavioral prompts.

SQL Exercise: Involves writing complex queries with tricky joins7 Tests candidates' ability to handle database querying and data manipulation Python/Java/SQL Streaming Exercise: Focuses on data processing and analysis3 May involve implementing MapReduce concepts5

Phone screening - determined eligibility. General questions regarding eligibility. Going over the position, describing the team and responsibilities. As well as opening the floor for questions during the interview. Make sure to ask questions.