three rounds technical interviews and one round HM interview. Coding questions and BQ and questions about resume. Final round is system design, not hard but didnt expect it for this position
Interview questions [1]
Question 1
1. experience as DE
2. questions about hive, spark
3. optimization
I applied through a recruiter. The process took 1 week. I interviewed at TikTok in Sep 2023
Interview
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
Interview questions [1]
Question 1
1st SQL: Condition over a time range 2nd Py: Binary Search Easy 3rd Py: Build largest number less than n (medium/hard)
I applied online. The process took 3 weeks. I interviewed at TikTok (San Francisco, CA) in Aug 2023
Interview
Initial HR call where questions are around your resume. After that I got a phone screen with a Data Engineer at Tiktok which was ok, there were questions about my previous experience, data modelling and spark architecture. The interviewer's english was not great, so I couldn't get any hint even though they were trying to help.