HireVue assessment, one technical and one HR interview. Technical interview is very easy with simple questions and HR interview is based on CV. The last interview was with the HOD, which was also easy and was aimed at judging if u are a good fit for the company
Interview questions [1]
Question 1
What is the difference between data lake and data warehouse
Easy questions, simple, friendly team. It was all nice, and it was good overall. I had two interviews. It was very professional as well. I was asked a couple of technical questions.
I applied through an employee referral. The process took 2 months. I interviewed at Jazz (Islamabad) in Jul 2023
Interview
3 rounds of interviews:
1 online hire view assessment where you have to record video.
1 interview with intermediate SQL, DWH architecture questions, general data modelling questions, culture fit
1 final interview round with head of department that is about general industry knowledge and behavioral skills
Interview questions [1]
Question 1
If a dwh table has some data and you have a csv file, how will you load it? Can you can use fastload, why not?