- 1 SQL question
- A few Experience related questions based on resume
- Spark and big data related questions - how it works and how to optimize
- One Leet code question
I applied online. I interviewed at ByteDance in Nov 2024
Interview
The interview process includes three rounds of technical interviews:
1. A senior technical engineer in China focuses on core technical skills and problem-solving data warehouse.
2. A technical leader in the USA dwh design and coding sql
3. Another technical leader evaluates advanced dwh design and coding sql
Interview questions [1]
Question 1
1. How do you build your data warehouse?
2. coding sums, sorts, window functions, and related sql questions.
3. Spark memory problems, data skew problems, how to troubleshoot problems, etc.
I applied through a recruiter. The process took 1 week. I interviewed at ByteDance in Sep 2024
Interview
normal interview process. did live coding on leetcode questions and asked some data engineering concepts like spark and kafka and other data engineering topics. asked some sql questions as well
