Online Test Experience: We were given an option to select which test we wanted to take, the options being: BA/both and PA. I took the former one.
The BA/both test contained three sections: Quant and LR, RDBMS (SQL Query), Technical MCQ.
The quant and LR questions were mostly basic, the primary constraint being time management.
The SQL query section contained three questions. You need to be thorough with SQL to solve all the three.
The technical MCQ section contained questions on Python, R and SQL. Basic knowledge of all the three was tested in this section.
Conclusion: You need to have a thorough knowledge of SQL and basic knowledge of Python and R to clear the BA test. Moreover, if you score well in the Quant LR section, you may be shortlisted for the PA profile.
49 students were shortlisted for the GD and PI for BA profile.
GD experience: A group of 10 students were called at a time for GD. To my group, an abstract topic was given. The GD continued for 20 minutes. Out of the 10, 4 students were called for Personal Interview.
Personal Interview experience: The first round of the interview was around 30 minutes long. I was asked some HR questions and questions about the company. I was asked to explain my summer internship in an elaborated fashion, cross-questioning was also done. A guesstimate as well as a case study, was asked. I was asked to write some SQL queries.
The second round of the interview was around 30 minutes long as well. Two case studies were discussed. Four guesstimates were asked.
6 students were finally selected for BA.
Tips: Do not lie on your resume. You should be comfortable with everything you've written on your resume. Practise writing SQL queries. Practise solving guesstimates before you go for PI.
I applied through a recruiter. The process took 1 week. I interviewed at OYO (Gurgaon, Haryana) in Jan 2021
Interview
The HR contacted through my naukri profile for business analyst position in Gurgaon,India .
The next day i gave my 1st stage of technical round. It went for 30 minutes. I was told that, if selected, i would've to give one more round of technical stage. The interviewer was helpful wherever i stuck and was frequently asking if i need some hint.
Interview questions [4]
Question 1
The interviewer showed be two tables. Asked to perform LEFT JOIN and RIGHT JOIN. Then find the number of rows in the resulting tables.
I applied through college or university. I interviewed at OYO
Interview
The hiring process was as follows:
1) Resume-based Shortlist
2) Aptitude Test
3) Group Discussion
4) Interview (Technical and HR)
I was able to clear the first three rounds and got selected for the final interview process. But was not able to clear the technical interview
Interview questions [1]
Question 1
Case studies were asked based on the role and some puzzle and riddles