2 rounds of interviews.
1. Take home assessment:
Advanced SQL question on BigQuery. Asked to visualize it as well on BQ itself. Was relatively straight forward. 24 hours given to complete.
2. Hiring Manager Round:
1 hour interview. Connected with a Director from Walmart who first went over the resume and digged deep into previous experience. Asked some questions about Spark and how parallelism works. The interview just lasted 25 minutes.