The HR contacted me for a basic screening process and helped me understand the interview process which was A design round, Coding round and a HM round. Now the first round was database and system design round. I was asked to design a movie booking system and handle concurrent users trying to book the same seat at the same time. I explained the whole db design and schema in a whiteboard. The interviewer did not allow me to explain any of the design or even ask questions what kind of database i'm going to use. When I volunteered to explain he abrubtly said please stop i'll understand myself then I could have done this as a homework, He clearly did not want to understand my thought process. He was satisfied with the design as I did not leave any holes. Next he was posing the question how will I handle the concurrent reads. I explained three solutions one is acquiring table row lock, using for update with postgres and optimistic update approach with having a version number column to the table. But he was way too rude and interrupted me everytime I tried to explain the solution. I even wrote all three queries and showed him but he was looking for a particular answer. I even asked him what solution did he have in his mind but he was rude and said that you have 5 years of experience and you should have known it when he still did not explain the solution. With this mindset I'm glad i did not go through with the process. Now the glassdoor negative reviews are all making sense
