was contacted by HR, basic screening call happened, followed by a virtual interview. It was mostly around SQL & MS Excel & was easy honestly, though didn't get the offer. The interviewer friendly & professional.
Interview questions [1]
Question 1
Excel basic vlookup, sql queries were asked, quite basic
The interview process was smooth.
I was to give a brief introduction about myself then they moved to some assessment questions of sql. Sql problems mainly related to concept of SQL joins.
I applied online. The process took 5 days. I interviewed at Allo Health (Bengaluru) in May 2024
Interview
Resume Shortlisting
Purpose: Filter candidates based on qualifications and experience.
Criteria: Educational background, relevant work experience, technical skills.
2. Case Study
Purpose: Assess analytical skills.
Process: Analyze a given dataset and provide insights.
Evaluation: Quality of analysis and relevance of insights.
3. Technical Interview
Purpose: Evaluate technical expertise.
Format: Questions on technical skills, problem-solving scenarios, and possibly a live coding test.
Focus: Depth of knowledge, practical skills, logical thinking.
Interview questions [1]
Question 1
sql based ( joins, windows functions - rank,dense rank,row_number
