Interview Process involved 4 rounds:-
Round 1 & 2 were technical rounds and were mainly SQL, resume grilling and follow up questions of 4-5 question set like year on year, month on month sales and a mix of Tableau reporting.
3rd Round was on Banking and financial services domain knowledge like what all products bank offer and those calculations used.
4th Round was taken by the VP or BU head and was purely on guesstimate and calculations and followup.
Interview questions [1]
Question 1
SQL set of followup question and solve in real time with walking through approach how to solve.
I applied online. The process took 4 weeks. I interviewed at J.P. Morgan
Interview
Invited to participate in quiz and interview. Interview was conducted in stages and was invited for more then one round. Did not expect to be interviewed so was happy with my offer
The interview was easy regarding questions like capital market, repo rate and derivative products. Any internship exp and certification did in past. Subject taught in your education and project you undertake