I applied through college or university. The process took 4 weeks. I interviewed at Yardi Systems (Pune) in Mar 2021
Interview
There are 1 Round of Aptitude test.
Then there will be 3 rounds of interview
first round : Pre HR round:(Telephonic round and also elimination round)
- They just check a basic communication skills here.
-they will just ask you about your hobbies and a your final year project name and general questions.
second round : Technical round:
-first of all they will ask you about your project.
-then they ask you about project's database and about table structure or to draw er diagram.
-they will ask you to write queries related to the table you drawn. you should be very excellent in DBMS queries.
third round:(HR round):
unfortunately I didn't get selected for it.
Interview questions [2]
Question 1
Introduce yourself
projects you did till date
queries on joins, LIKE operator, having and group by clause, aggregate functions, update
Difference between primary key and unique key
write a query for email validation.
The hiring process includes an online aptitude test, followed by an in-person pre-HR screening, then one or two technical interviews, and finally a Business Unit Head round for final evaluation.
4 rounds, 2 technical and 2 hr. Depends on per hr round either you go to csd or Dev. First round is pre hr they ask about projects, second about tech stack
Sql question
Schema creation
Then query question on it
Make sure sql is strong for technical round
Business round includes combination of technical + hr + logic reasoning
Also for technical round u may be asked about ur projects on resume
Including backend and frontend