Ho presentato la mia candidatura tramite l'università. La procedura ha richiesto 3 settimane. Ho sostenuto un colloquio presso IDFC FIRST Bank (Mumbai) nel mese di gen 2024
Colloquio
It was on-campus recruitment for us. There were total 3 rounds. First round was aptitude section which was the most competitive one. On the basis of accuracy and speed 14 students were selected out of 150. Then we had 2nd round , technical interview and on the same day the selected ones had the 3rd round which was HR+ Technical. In 2nd round 2 SQL and 2 python questions were asked and some other basic questions.
Domande di colloquio [1]
Domanda 1
reversing a string in python and employee, manager self join SQL question
Ho presentato la mia candidatura tramite l'università. Ho sostenuto un colloquio presso IDFC FIRST Bank (Bengaluru) nel mese di dic 2025
Colloquio
this was on campus interview experience. there were 2 rounds + hr round where in first they asked on resume projects. where as second round they asked some sql related questions and coding question where we can do in any language but prefer python as the role is data engineer.
Domande di colloquio [1]
Domanda 1
assume that there is a raw data where date and time is there but not in correct order. how do you correct data and time order.
Q2) explain star schema ? where to use?
Ho presentato la mia candidatura tramite l'università. La procedura ha richiesto 2 giorni. Ho sostenuto un colloquio presso IDFC FIRST Bank (Dakshina Kannada) nel mese di ott 2024
Colloquio
It was a 20 mins technical interview process. There i had to introduce myself then they asked me about my projects then 2 DSA questions. 2 SQL queries and puzzles were asked.