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.
