I applied online. The process took 1 week. I interviewed at TikTok
Interview
After the recruiter call, there are 4 rounds. 2 rounds per day. Questions are around SQL, python and big data proficiency. Working knowledge of big data technologies such has hive, spark, etc. is a must.
Interview questions [1]
Question 1
SQL: leetcode medium to hard. Schema/data sample is provided. Queries will require revisions based on interviewer follow ups. Python: leetcode easy to medium. It is important to clarify all the details before attempting to write any code. Additionally, space and time complexity analysis is required. Big Data: basic knowledge and project experience.
In your interviews, you will usually speak with your potential teammates, cross-functional colleagues, and your hiring manager. Each interview will typically last between 30 minutes to an hour. Be prepared for behavioral, hypothetical, and case-based questions related to the role you are interviewing for.
Interview questions [1]
Question 1
You should expect typical behavioral and resume questions like, "Tell me about yourself," "Why TikTok?" or, "Tell me about a product you launched from start to finish."
self description - ask about projects - going into details - tech problems - SQL clarification - write SQL. Problems are not very difficult, but really deep in this field.
Interview questions [1]
Question 1
Talk about your recent project. What's the most challenging part?