o9 Solutions, Inc interview experience Real time questions & tips from candidates to crack your interview
Associate Consultant
o9 Solutions, Inc
2 rounds | 3 Coding
problems
Selected Interview preparation journey
Preparation
Duration: 4 months
Topics: SQL, DATA SCIENCE, DATA ANALYTICS, PYTHON, Arduino programming
Tip 1 : Prepare each topic rigrously
Tip 2 : do not move on without fully understanding one topic
Tip 3 : Think creatively rather than mugging up
Tip 4 : Do multiple projects and be ready to explain them
Application process
Where: Campus
Eligibility: above 7 cgpa
Tip 1 : Must have multiple extra-curricular activities
Tip 2 : Must have multiple projects in your domain
Tip 3 : Everything on resume must be true
Interview rounds
01
Round
Medium
Online Coding Interview
Duration60 Minutes
Interview date26 Aug 2020
Coding problem1
Mostly questions were of aptitude and verbal reasoning including some 5-10 questions on basics of programming and sql queries. Time was the important factor for clearing the test as questions were somewhat easy but time was limited.
1. SQL Question
SQL query to find students with score above a particular threshold and sorth them acc to their score and then names
02
Round
Medium
Video Call
Duration50 minutes
Interview date28 Aug 2020
Coding problem2
I was having just the second slot at 9:30 am.
Video call was done via google meet. Most of the interview went around my resume and my introduction. Interviewer was fairly impressed by my projects and discussed it in detail with me. After that he gave me a simple coding question to reverse a string and asked me to write it within 3 minutes. after that 2 questions on sql and 1 puzzle was asked.
1. Reverse the String
Easy
15m average time
85% success
0/40
Asked in companies
You are given a string 'STR'. The string contains [a-z] [A-Z] [0-9] [special characters]. You have to find the reverse of the string.
For example:
If the given string is: STR = "abcde". You have to print the string "edcba".
follow up:
Try to solve the problem in O(1) space complexity.
2. SQL Question
Fetch data from given two tables with a common column without using where keyword.
Here's your problem of the day 
Solving this problem will increase your chance to get selected in this company
Skill covered: Programming
How do you create a function in JavaScript?
Choose another skill to practice
Start a Discussion
Similar interview experiences
Software Consultant
2 rounds | 2 problems
Interviewed by o9 Solutions, Inc
Rejected
737 views
0 comments
0 upvotes
SDE - 1
3 rounds | 7 problems
Interviewed by OYO
Selected 980 views
0 comments
0 upvotes
SDE - 1
3 rounds | 9 problems
Interviewed by Salesforce
Selected 592 views
0 comments
0 upvotes
System Engineer
2 rounds | 2 problems
Interviewed by Tata Consultancy Services (TCS)
Selected 412 views
0 comments
0 upvotes