Ho presentato la mia candidatura tramite un'altra fonte. La procedura ha richiesto 2 settimane. Ho sostenuto un colloquio presso ByteDance (Singapore) nel mese di gen 2022
Colloquio
Short and quick interview. Only looking for specific talents and skills in candidates. However, interviewer is very frank and willing to answer your questions. Had a good discussion to understanding more about the role.
Domande di colloquio [1]
Domanda 1
Difference between star and snowflake schema, pros and cons
Ho presentato la mia candidatura online. Ho sostenuto un colloquio presso ByteDance nel mese di nov 2024
Colloquio
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
Domande di colloquio [1]
Domanda 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.
Ho presentato la mia candidatura tramite un selezionatore. La procedura ha richiesto una settimana. Ho sostenuto un colloquio presso ByteDance nel mese di set 2024
Colloquio
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
Ho sostenuto un colloquio presso ByteDance (Singapore)
Colloquio
- 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
