I applied through an employee referral. The process took 1 week. I interviewed at TikTok
Interview
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
Interview questions [1]
Question 1
They asked how to perform aggregate functions and window functions in a single SQL statement
I applied through an employee referral. The process took 2 weeks. I interviewed at TikTok (San Jose, CA)
Interview
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.
I applied through a recruiter. I interviewed at TikTok
Interview
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.