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.
I applied online. I interviewed at TikTok (Sydney) in Aug 2023
Interview
Initially 30min talk over phone with HR. Then 60min screen share with a team member. This interview include experience talking, technical questions, SQL coding and any language coding. After that, I have not received any update yet for about one week. The organization of the interview was completely chaos. Organizer from US, position was in Australia, Interviewer from Singarpor. And all use different time zone. First HR call was shared with wrong meeting bridge. Interviewer did not show in 2nd Technical call, and then reschedule. Organizer did not even reply my email for several days when the interview no show.
Interview questions [1]
Question 1
Q1: What was Hive External Table. What was Hive UDF.