Interviews were well organized. 30mins recruiter --> 30mins Hiring Manage --> Takehome Assessment(90mins) --> Technical(1 hr). This is where I stopped.
As I recall, there could be a few reasons:
1. The technical interview organized through Zoom includes live SQL scripting, I felt a bit stuck and searched Google(didn't even cross my mind to ask for permission since I do it all the time in production environment, I even said it out like"I'm gonna Google XXX" and I wasn't stopped). I answered all questions correctly but probably should've asked for permission of using online resources.
2. I realize different interviewer has different perspective about the same project, the job description makes it sounds like a big data system and I got echoes from first 2 interviewers, then the 3rd interviewer don't think so. I suggest not to sit on a certain perspective from just one interviewer, ask the same question every time, make sure your mind is always aligned with the person you are talking to. Also different interviewer may ask same questions, don't gloss over, answer it like you were asked the first time.
3. I feel this company has a fast growing startup style that prefers someone able to handle wild initiatives from scratch and challenge status quo, think I’m still in a stage of seeking mentorship.
Hope this is helpful and good luck to everyone!