I was interviewed at J.P. Morgan.

First interview was comparatively easy, all basics of SQL and Spark were asked. The few questions were:

1. Spark architecture
2. Difference between bucketing and partitioning and a few easy SQLs.

The second interview was mostly SQL.

I was given 5-6 tough SQLs from recursion, window functions, to solve in half an hour, and I gave answers to most of the questions. But the interviewer was very grumpy; he was taking calls in between, not listening, and not discussing much with me. He just asked me to share my screen, and I was just writing my queries while sharing.

At last, they did not notify me for many days about my candidature. I followed up with them and came to know that I was not selected.

That's fine, but I think it was sometimes pre-decided about whom to select internally. Otherwise, I do not see any reason.

Sad that such a big organization does such gambling.

1. Recursion
2. Window function
3. Difference between RANK and ROW_NUMBER
4. SQL with LEAD and LAG functions