It started of well with basic questions without even an Intro, deep dived into more of database systems and much looking for a candidate who knows everything with 10+ years of experience but the job role says 4+ YOE where the interviewer feels 4+ YOE is Junior role. The role expectations are straight away join the team, do the POC's within 2 months of joining who knows all about Azure Cloud, All Databases with well experienced in. solved a sql query at the end while last 10 mins was how to make a person feel low on confidence with free tips. the questions are from LAST CHAPTER of DATABASE SYSTEMS book. The interviewer doesn't know anything when cross questioned or explained.
Got for Next round but I refused as the interviewer was giving free life advices and tried to made me feel that I'm not well experienced. toxic manager though!!!
Interview questions [1]
Question 1
1) Basic questions with deep diving examples
2) 1 SQL Query [LC Medium]
HR screening, one technical interview with the hiring manager then three interview loop which covered two system design and one dsa round.
System design was intensive and challenging.
It took them 5 weeks to come back with an offer. Background check was completed in a week, got joining date after 3 days.
Interview questions [1]
Question 1
Design a system for a startup company that let users post various types of content and get a unique url which can be shared with others to access the content
Started with a recruiter phone call and a 30 minute phone call with the hiring manager to negotiate a remote role since the job was based in Seattle and the manager agreed. Following up with five rounds of virtual on site. Four of them are coding/design. One of them is behavioral mostly leetcode medium level questions which I finished and I was able to do all the follow up and answer the design and time complexity questions correctly after the interview got ghosted for a whole month and got an automatic rejection email.
Interview questions [1]
Question 1
Leet code medium level questions. DFS, BFS, sliding windows and greedy algorithm. Follow up, asking some design questions and the time complexity of the code.