Yardi Systems SQL Developer interview questions

Fisrst is Aptitude which is so simple.Consist reasoning and English 10 qsn on quant 10on english and 20 on English After that there is technical round which simple on your basics java,sql and asp After that there is a pre hr round I that they ask about basic hr questions and project mostly checks your communication After that there is technical round in that they ask all about sql gives query to write like joins union and other sql If you give 100% then you will get definitely offer After that there is a manager round..

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