Phone screening 15 minutes with one of hr representatives then next week hr called back to invite you to attend the
Face to face interview with 4 interviewers which includes manager and other dell employees
Interview questions [1]
Question 1
Introduce yourself and your previous work experience
I applied through an employee referral. The process took 3 weeks. I interviewed at Dell Technologies (Kolkata) in Nov 2021
Interview
Had 3 rounds of interviews in total. First two were with senior manager and director. Last round was with HR.
Interview consisted of SQL, Advanced Excel, case studies and statistical questions.
Interview questions [1]
Question 1
Advanced Excel question using text functions, pivot
SQL questions were mostly based on joins and duplication in the primary key
Case studies based on Machine Learning techniques
it was normal and general interview process
HR - normal 1 hour interview
Technical- mostly discussion around various ETL related technologies.
challenge - take away challenge to build spark solution
Line manager - discussions about your previous work