
Yardi Systems Software Engineer Interview Questions
& Process
Real candidates share what happened, how many rounds they had,
and how the experience turned out.
Based on 180 interview experiences · FREE TO READ
Candidate interview experiences
First-hand accounts from people who interviewed at Yardi Systems.
Software Engineer Trainee
So the hiring process involves an online aptitude test first, then an in-person pre-HR screening. After that, there are one or two technical interviews. Finally, there's a Business Unit Head round for the final decision.
- Can you explain SQL and its uses?
- What are joins in SQL and how do they work?
- Describe views in SQL.
Software Engineer Trainee
The interview process started with an online assessment that included aptitude and coding tests. After that, there was a Pre-HR round for basic screening and to discuss my resume. Then came two technical rounds, Technical-1 focusing on core concepts and problem-solving, and Technical-2 for more advanced technical evaluation. A Managerial round followed, with scenario-based and team-fit questions. Finally, there was a Final HR round to discuss salary, relocation, and confirm the offer. They mentioned 55 were shortlisted from CS/IT and 77 from ENTC, with 10 selected from CS/IT and 16 from ENTC.
- Online Assessment: Aptitude and coding MCQS on C++, Java , .NET , SQL
- Pre-HR: Basic screening and resume discussion. Family background, programming languages I know, and discussion on projects.
- Technical-1: Core concepts and problem-solving. Project-based SQL questions: table structure and their relation. How to store multiple mobile numbers. Concepts: normalization, GROUP BY, difference between UNIQUE and PRIMARY KEY, WHERE vs HAVING, UNION vs UNION ALL. Definitions and queries on: subquery, foreign key, LIKE, joins, IS NULL, composite primary key, ON DELETE CASCADE, view, window function. Puzzle: Given 3, 5, and 10-liter mugs, fill exactly 10 liters using 4-liter increments.
Software Engineer
The interview process had 5 rounds. Two of them were technical interviews, two were managerial interviews, and one was with the director or senior HR. The first technical interview involved writing the database schema for my final year project and explaining the use of its tables. Around 15-20 queries were asked on that database, focusing on concepts like using `group by`, `order by`, `union`, and `union all`. Queries were also asked about recent entries in the database, the use of the `having` clause, and multiple conditions in a select statement using `AND` clauses. There were also theory questions covering why we use the `having` clause, the concept of normalization, and the difference between a procedure and a function. A puzzle about 9 coins (referencing Geeksforgeeks) was also part of the interview.
- Can you write some SQL queries concerning joins?
- Could you elaborate on some SQL queries regarding joins?
Yardi Systems Software Engineer Interview Questions
Quoted word for word from Yardi Systems interview reports.
“What is the difference between a primary key and a unique key?”
Read reports →“What is the difference between a primary key and a foreign key?”
Read reports →“Given a string with words, how would you extract the last word?”
Read reports →“Is 'select * from table xyz where 1=2' a correct SQL query?”
Read reports →“Is 'select max(10, 20) from xyz' a correct SQL query?”
Read report →“How should CSS and Javascript files be included in an HTML file (Syntax)?”
Read report →“What is the procedure for deleting a record that has a foreign key constraint in another table?”
Read report →“What is the outcome if exceptional code is placed within a Catch Block?”
Read report →“Find the department name for employees who have a department assigned, and also for those with a NULL department ID.”
Read report →Formats, difficulty and experience
Across all 180 Yardi Systems interview reports.