o9 Solutions Interview Questions, Process, and Tips

Round duration - 60 Minutes
Round difficulty - Medium

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.

Q1. Write an SQL query to find students with scores above a particular threshold and sort them according to their scores and then by their names.
Ans. 
SQL query to find and sort students with scores above a threshold
• Use the SELECT statement to retrieve the required data

• Use the WHERE clause to filter students with scores above the threshold

• Use the ORDER BY clause to sort the results by score and then by name
Answered by AI
Add your answer

Round duration - 50 minutes
Round difficulty - Medium

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.

Q1. 
Reverse the String Problem Statement
You are given a string STR which contains alphabets, numbers, and special characters. Your task is to reverse the string.
Example:
Input:
STR = "abcde"
Output:
"e...read more
Ans. 
The task is to reverse a given string that may contain lowercase letters, uppercase letters, digits, and special characters.
• Iterate through the string from the last character to the first character and append each character to a new string.

• Alternatively, you can use built-in string reversal functions or methods available in your programming language.

• To solve the follow-up question with O(1) space complexity, you can us...read more
Answered by AI
View 1 more answer
Q2. How would you fetch data from two given tables with a common column without using the WHERE keyword?
Ans. 
Fetch data from two tables with a common column without using WHERE keyword.
• Use JOIN keyword to combine the two tables based on the common column.

• Specify the common column in the ON clause of the JOIN statement.

• This will retrieve all the rows where the common column values match in both tables.
Answered by AI
Add your answer

Was test containing three sections, Aptitude test, SQL Based questions and Supply Chain domain related questions

Q1. Basic Resume based questions and few Supply chain domain based questions
Add your answer

Q1. This was final interview round where they again asked few functional and resume based questions, and few questions from past work experience
Add your answer

6 parts 10 questions in each part

To create a ppt , 11 topics were give any one to be chosen, time limit 6 hrs to submit

Q1. Present the topic prepared in the earlier round
Add your answer
Q2. Interests in supply chain
Add your answer
Q3. Asked about Job Discription
Add your answer

Online assessment

Q1. One to one round with a Senior Software Engineer. Asked to walk thorough one of the projects from previous work, one coding round. Focus of this interview was on problem solving skills.
Add your answer

Q1. One to one round with product manger. Walk thorough one of the projects, one code to write.
Add your answer

Q1. One to one round with hiring manager. Walk thorugh one of the projects, what are you looking for in new role, why do you want to join O9 , and one puzzle.
Add your answer

Q1. What are your strengths and weaknesses?
Add your answer
Q2. What are your salary expectations?
Add your answer
Q3. Why are you looking for a change?
Add your answer
Q4. Tell me about yourself.
Add your answer