Ho presentato la mia candidatura tramite un selezionatore. La procedura ha richiesto una settimana. Ho sostenuto un colloquio presso TikTok nel mese di set 2023
Colloquio
Recruiter 30min, very thorough explanation of the process, you'll get the low down. Technical Interview 50 min, did 1 SQL medium (was not able to run code as the env was broken for SQL), then moved on to python easy and then python medium/hard
Domande di colloquio [1]
Domanda 1
1st SQL: Condition over a time range 2nd Py: Binary Search Easy 3rd Py: Build largest number less than n (medium/hard)
Ho presentato la mia candidatura tramite segnalazione di un dipendente. La procedura ha richiesto 2 settimane. Ho sostenuto un colloquio presso TikTok (San Jose, CA)
Colloquio
3 rounds in total. Every round will have deep dive on Resume, foundation questions, 2-3 Coding questions, BQ questions... Overall fair enough. Coding on their own platform. Might interview in Chinese sometimes.
First round of tech interview: 3 questions, 1 SQL hard, 1 SQL medium and 1 brain teaser. Interviewer asked to code in a notepad and insist my solution was wrong. As I couldn't run the code in IDE I couldn't prove my code was right. After my interview I ran my code and it is working perfectly well.
Ho presentato la mia candidatura tramite un selezionatore. Ho sostenuto un colloquio presso TikTok
Colloquio
I solved complex SQL problems, discussed Spark architecture, and answered performance optimization questions, including indexing strategies, partitioning, query tuning, and resource management in distributed data processing systems effectively and efficiently.
