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