Ho presentato la mia candidatura tramite segnalazione di un dipendente. La procedura ha richiesto una settimana. Ho sostenuto un colloquio presso TikTok
Colloquio
Asking what are your previous job scope, and testing on SQL on window functions, and views, The interviewer will also ask on your past projects, and a little bit of data pipeline theory, such as kafka, and spark
Domande di colloquio [1]
Domanda 1
They asked how to perform aggregate functions and window functions in a single SQL statement
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.
