Ho presentato la mia candidatura tramite segnalazione di un dipendente. Ho sostenuto un colloquio presso TikTok (Seattle, WA) nel mese di mar 2025
Colloquio
The coding assessment consisted of medium-level LeetCode problems and highly challenging SQL questions. The SQL section was based on a complex real-world business case, requiring multiple joins, aggregations, window functions, and careful handling of edge cases.
Domande di colloquio [1]
Domanda 1
Just leetcode and sql problem solving. And some JAVA basic questions.
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.
