The position is for CIB Data Products - Product Development. Their HR contacted me. Had the first round with two vps. The interview focused on resume and work experience. No response yet.
Preguntas de entrevista [1]
Pregunta 1
Based on resume. What is A/B testing? And your experience
Me postulé en línea. El proceso tomó 2 semanas. Acudí a una entrevista en J.P. Morgan (Hyderabad)
Entrevista
I was interviewed at J.P. Morgan. First interview was comparatively easy, all basics of SQL and spark was asked . The few questions are
1.spark architecture , 2. difference between bucketing and partitioning
and few easy SQLs
the second interview was mostly SQL
I was given 5-6 tough SQLs from recursion, window function to solve in half an hour and I gave answer to most of the questions . But the interviewer was very grumpy, he was taking calls in between , not listening and discussing much with me 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 at came to know that I was not selected.
Thats fine, but I think it was sometimes pre - decided about whom to select internally . Other wise I do not see any reason .
Sad that such a big organisation do such gambling .
Preguntas de entrevista [1]
Pregunta 1
1. Recursion
2.window function
3 difference between rank and row_number
4. sql with lead and lag function
Me postulé en línea. Acudí a una entrevista en J.P. Morgan (Chicago, IL) en may 2022
Entrevista
Very straightforward. Two interviews with two VPs. One very technical in nature and walked thru some simple coding questions while the interviewer shared their screen. Next one was more abstract data engineering questions. Behavioral questions were sprinkled in throughout both.
Team moved very quickly and always very responsive. Very positive experience overall
Preguntas de entrevista [1]
Pregunta 1
What would you in a situation where a business user asks you to add a data element to the reporting output that you know provides no value and will slow down performance ? Even though you know this is the wrong thing to do, they are insistent on it. How would you approach this situation ?
