Was initial contacted by a consultant for this role. The first round of interview was a written Aptitude round, after this round few candidates were sent home. The second round was a written sql query round in which some complex queries were asked , after this round also many candidates were eliminated. The third round is Pre-HR round in which discussion with HR takes place about the job role, expected offered salary and basic test of Communication skills. The fourth round is a technical round, in my case this round was taken by a panel of two senior resources from Yardi, the asked questions related to technologies i had used and worked on and also also asked many complex query question. After this round only few candidates are screened out for second technical round. The fifth round is a technical round with the Team Lead, in this round technical as well as managerial questions are asked and depending on their requirement they shortlist a handfull of candidates for the final manager round. This round is with the project manager, here no technical questions are asked, the manager asks basic questions like how you will handel different situation , etc. After the manager gives a heads up, the final HR discussion takes place where an offer is placed to each candidate, this offer is Non-negotiable and if the candidate accepts the offer they are selected. Please note usualy all rounds take place in a single day so better be ready for a tiering day