The Interview process was very smooth. Recruiter reached out on Linkedin, applied. Set up an initial phone screen; live coding, Advanced sql and python questions. Prepare basics well and you are all good to go. After a week got a call to meet the team in person in Newark, NJ office set up. Had 5 1:1 in person interviews with Senior Data engineers/ hiring managers and Director. Mix of behavioral and Technical. Very structured interview process. Prepare sql , Python and some system design question related to Big data architecture. Got an offer within the next two days. Good luck!

Initial discussion with recruiter followed by technical phone interview. The question was on datawarehouse and SQL. Foucs was on query optimization and data ware house scenario. Interviewer was very cool . I could answer most of the question