Yardi Systems interview question

1. Online Assessment Aptitude and coding MCQS on C++, Java , .NET , SQL 2. Pre-HR Basic screening and resume discussion. Family background, programming languages I know, and discussion on projects. 3. 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. 4. Technical-2 Advanced technical evaluation. Asked to write user flows for both projects. How I would improve and sell them. How I use ChatGPT in daily life. What I understood from the Yardi website. 5. Managerial Scenario-based and team-fit questions. Introduction and deep discussion on each project. Emphasis on my role, development process, and improvements. ( He wrote everything in his notebook ) Given a task: prioritize these – stability, salary, designation, technology, long-term goals, training I gave him the priority List .Asked what my top three would be if God guaranteed them – I answered in the same order (Tip: be yourself). Situation-based question on handling repetitive tasks like in a customer support role. This was the most fun round for me. 6. Final HR Salary, relocation, and final confirmation. Congratulated me. Discussed salary breakdown. Asked if I had other offers. Talked about previous rounds. Discussed training period and structure.