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.
two round interviews. Both two lc question for sql and python. Very easy. Also include some basic bq questions like asking your resume for research and projects. And test whether you are suitable for this position.
Why should we hire you? What are your key skill set? How long do you work everyday? Weaknesses? Are you easy to manage?
Are you a drone who can blindly follow upper management directives despite the fact that you know they are immoral? Do you mind if we don't give you a raise year after year? Are you happy with no bonuses.