HR call for 30 minutes. Questions from background, bq, to basic sql concepts. Everything is easy, HR will question back some of the resume detail. But HR says whether to move forward depends on the hiring manager.
Interview questions [1]
Question 1
1. Explain the function of having in sql
2. What's the substitution of subquery in sql
I applied online. I interviewed at Capital One (McLean, VA)
Interview
One round of HR screen, one round of mini case that will last for an hour, and a superday that lasts for 3-4hours, superday case is more complex than practiced and if you meet a strict interviewer it will put in too much pressure and make people nervous. But overall its ok.
I interviewed last year - the interview process was fair. A bunch of behavioral questions and case interviews. The power day was intense - need to get familiar with the product interview as well.