Round III ( Offline Technical Interview)

This is a face-to-face interview with a software engineer. It was my 1st offline interview experience. I met the interview panel, and they were really friendly. They started by asking about my background, technical skills and why I was interested in the SQL Developer role. They seemed genuinely curious about how my skills could fit their needs

Following interview questions they were asked in this interview:

• What is SQL & DBMS?
• What are the different types of joins in SQL & explain with the help of a diagram?
• They gave me 2 tables & asked me to write all join queries & their results on blank paper.
• Write a query to replace all NULL values with 0 as the result of joining two tables.
• How do you write a query to print a table in decreasing order of marks in student table statement?
• What are triggers and stored procedures?
• What is the GROUP BY & HAVING clause?
• What are your experiences with other object-oriented programming languages and technologies?
• Then they asked me about OOP paradigms, abstract classes, virtual keywords, inheritance & its type in detail,
• They me about a team project you’ve worked on & what was my role in this project.

They asked me only one easy DSA-based question about string reversal.

Why are you interested in working at Yardi Software?

The interview got a bit more technical when asked lots of questions on real-life data, and SQL queries. Unfortunately, I wasn’t able to answer some of SQL related questions. That is why I was not able to continue further interview process.

Hi all, Yardi Software India Private Limited, Pune visited our campus for SQL Developers in the month of December 2023, the whole recruitment process took only 4-5 days to complete. The first two rounds were in online mode while the other two were completed in offline mode. It was an insightful experience that gave me a deeper understanding of both the company and the role.