I applied through a staffing agency. The process took 2 days. I interviewed at Yardi Systems (Pune City) in Feb 2020
Interview
Aptitude : Cocubes Platform
The interview process was dependent upon the panel you are interviewed by, I had to go through
1. Pre HR interview (where they test your communication skills and knowledge regarding the company)
2 . Technical rounds (SQL, OOPS concepts, Projects, Pseudo code {for me i was asked to write pseudo code for Movies ticket booking system})
3. Managerial round (similar to pre HR round)
Suggestions : Go through the company website, get to know about the products the company is being working on.
Interview questions [1]
Question 1
select * from table xyz where 1=2 (is the query correct)?
select max(10, 20) from xyz (is the query correct)?
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