I applied online. I interviewed at Yardi Systems (Sat home) in Aug 2021
Interview
Aptitude
1 Grammer base online
2 Technical base online
Telephonic interview
Basic question ask intro n basic sql
Technical interview
Average que ask in sql and project explain and write sql queries
HR
Interview questions [1]
Question 1
SQL base questions
Difference between primary key and unique key foreign key, join, query
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.
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