First Republic Data Warehouse Engineer interview questions

After a disappointing first attempt (read my earlier review), I applied once again and got a call for 2 rounds of interview. Both rounds went well (as per the interviewers, not me) and in fact, once of the interviewers told me that I am the perfect fit for this position. However, later, I got an email from HR saying that they are moving forward with another candidate. So, didn't really understand the point of the whole process.