3 rounds. 1st with HR (simple behavioural). 2nd interview with one team member (behavioural + easy technical question on SQL). 3rd round with division lead (first half motivational on do you use TikTok, why TikTok, what do you think TikTok can improve on, 2nd half behavioural). Did not do well for motivational questions and could already tell i was not getting an offer.

4 rounds, all behavioral questions with some SQL technical competency based questions. 2nd and 3rd round will be with team members and manager, mainly behavioral questions and vibe check. Last round will be with HR to discuss more about the role and vibe check