Status : Recently graduated from Masters, 1.5 years of experience

1. Recruiter Phone call : understand your background, why join tiktok, your relocation and visa needs
2. Technical Interview 1 : 60 mins : Coding Screen round with a data engineer at ByteDance, China - 2 Python LC Medium Questions 2 SQL easy questions
3. Technical Interview 2 : 60 mins : Senior Data Engineer from Mountain View office interviewed :
   • Background/Resume questions
   • 1 Data engineering system design question - A MySQL Table that's collecting transactions data has the capacity of collecting only 3 days' data. Design a system to handle this.
   • 2 easy SQL qns on an ER diagram : be prepared with group by, joins, case statements and window functions

The ending of the process was wierd. I was supposed to have another 60 minutes final interview with the hiring manager. But they later inform me that the requirements of the role changed and they required more experience. They should have identified that in Step 1, very unorganised. So yeah no offer finally.