In any campus /off-campus recruitment/interview process, online or offline technical tests serve as an elimination round, typically consisting of two Types aptitude & technical round.
At Yardi Software Limited, the recruitment stages are :
- Resume/CV Screening
- Group Discussion
- Online Aptitude Test (Level 1)
- Technical Round (Level 2)
- Offline Technical or Other Rounds (if applicable)
After I cleared the offline Group Discussion round, I received an email notification confirming my successful advancement to the next stage of the recruitment process. The email congratulated me on being shortlisted and provided a link for the upcoming online test. This test is scheduled for specific dates, during which I am required to attempt two levels:
- Aptitude Test
- Technical Test
After receiving the email containing the link for the online test, I spent some time refreshing my basic concepts in Java, DBMS, C, C++, SQL, and other fundamental programming concepts. The next day, I felt a bit nervous and stressed, so I went over the concepts again to reassure myself. Then, I prepared my laptop, ensuring a stable internet connection, a fully charged battery, closing all unnecessary tabs, and grabbing a pen and paper. Finally, I was ready to begin my test.
Upon successful completion of the aptitude test, I will have the opportunity to proceed to the technical test on the same date.
- The aptitude test lasts for 45 minutes and comprises 20 questions, with no negative marking. Each question carries one mark.
- Similarly, the technical round consists of 25 questions to be completed within 45 minutes. There is also no negative marking, with each question worth one mark.
After successfully completing the aptitude test, I gained some confidence and took a break for an hour before starting my second technical round. During this break, I revisited some key points, drank enough water, had a snack, and took a short nap. I made sure my laptop was in the same rested state, fully charged, and checked the connectivity once again. Armed with pen and paper, I was ready to begin my next technical round.
Technical Round: The Technical Round includes questions related to various topics, such as:
- DBMS (Database Management System)
- JAVA programs, which may include programs with given inputs and expected outputs
- Inheritance
- Normalization forms in DBMS
- Operator overloading
- DDL (Data Definition Language)
- SQL queries
- .NET
Before attempting the technical round, make sure you to prepare this concepts:
- Reviewing and brushing up on basic Java concepts.
- Ensuring knowledge about Database Management System (DBMS).
- Understanding normalization forms such as 1NF, 2NF, 3NF, and BCNF.
- Grasping key concepts like Primary Key and Foreign Key.
- Understanding the Java code execution flow sequence.
- Familiarizing oneself with concepts like pre-increment and post-increment in programming.
- Practicing SQL queries execution, including operations like Delete, Create, Update, Drop, etc.
Some question which I remember:
- Where the JAVA program start from?
- For operator overloading we use?
- Given SQL query output?
- Multivalued attribute removed in which normal form?
- DDL commands?
- Which type of inheritance use?
For Example: Class C:public A,public B
The question in the test might not be exactly like this, but it's similar in nature. Overall, my experience with the technical round was positive. It wasn't overly challenging, especially if you have a solid grasp of the basic concepts in the topics covered and after successfully clearing the technical round, I received an email notification confirming my achievement.