I applied through college or university. I interviewed at Yardi Systems (Pune) in Mar 2021
Interview
5 rounds of interviews 2 were technical 2 were managerial and one was with the director or the senior HR. 1st technical interview: 1)Write database schema of final year project 2)Explain the use of tables of the database around 15-20 Queries were asked on that database queries were related to use of group by order by union union all queries were related to 1)recent entries in the database 2)use of having clause 3) multiple conditions in one select statement (eg. use of AND clauses) Theory questions like why we use having clause normalization concept difference between procedure and function Puzzle regarding 9 coins (refer Geeksforgeeks)
The recruitment process began with an online assessment round to evaluate aptitude, technical knowledge, and problem-solving skills. Candidates who cleared this stage were shortlisted for a pre-HR screening round, followed by a detailed technical interview. Finally, the selected candidates attended the HR round, which focused on communication skills, personality, and overall cultural fit within the organization.
Interview questions [1]
Question 1
in pre hr they asked basic hr questions
where do you live?
what was your final year project? etc
The interview process includes four comprehensive rounds, focusing heavily on SQL queries. Candidates must demonstrate strong database fundamentals, hands-on CRUD operations experience, joins, query optimization, and basic performance tuning knowledge.