o9 Solutions Consultant Interview Questions
& Process
Real candidates share what happened, how many rounds they had,
and how the experience turned out.
Based on 51 interview experiences · FREE TO READ
Candidate interview experiences
First-hand accounts from people who interviewed at o9 Solutions.
o9 Solutions
Technical Consultant
Senior Average Neutral experience No offer 4 rounds
Interview process
Technical screen Technical screen Technical screen Recruiter call
Interview formats
Technical Coding Technical Behavioral
Started with an online assessment, then had a technical interview with a Sr consultant. After that, a second technical interview with the Hiring manager which was more in depth. Then an interview with the VP, followed by HR for salary negotiation.
Confirmed questions1 question
- Mostly SQL related problems and 1 algorithm problem
o9 Solutions
Functional Consultant
Entry Average Positive experience Accept offer 3 rounds
Interview process
Recruiter call Technical screen Presentation
Interview formats
Case Technical Presentation
The interview process was good. They mostly check your problem solving skills and basics of SQL. If you have knowledge of supply chain it will be an edge for you. They asked questions related to extra curricular activities, a case study, and basics of SQL.
Confirmed questions2 questions
- Can you elaborate on a case study?
- Explain the Profit and Loss concept.
o9 Solutions
Senior Consultant
Senior Difficult Positive experience Accept offer 3 rounds
Interview process
Recruiter call Phone screen Technical screen Onsite
Interview formats
Behavioral Technical Case
After applying, I went through three interview rounds within two weeks, with about a week separating each. A consultant was my first interviewer, then the hiring manager, and finally a director for the last one. The interviews were tough, covering supply chain planning, analytics, and digital transformation, and mostly focused on my past experience, technical abilities, and solving case studies.
Confirmed questions2 questions
- Could you explain what demand planning entails, outline the methodologies and steps involved, and describe the forecasting models used? Additionally, share an example of how you've leveraged these in a past role to achieve significant results.
- Tell me about your experience with demand planning, including the methods and steps you've followed, and the forecasting models you've utilized. How have you applied this knowledge to make an impact in a previous position?
o9 Solutions Consultant Interview Questions
Quoted word for word from o9 Solutions interview reports.
“How would you write an SQL query to determine if a given number is prime?”
Read reports →“How can you measure exactly half a glass of water if you start with a full one?”
Read reports →“How would you display numbers 1 through 100 with SQL?”
Read reports →“Can you explain what Indexing is and its different types?”
Read reports →“Can you list the different types of SQL JOINs and explain the use cases for self joins and inner joins, providing examples to differentiate them?”
Read report →“Can you describe the differences and uses of Cross join, Inner join, Keys, Group by, and the Like clause?”
Read report →“What are the basics of Database Management Systems, and can you explain SQL and the ETL Process?”
Read report →“Could you explain a scenario using JOINs where you'd retrieve data from two tables based on a specific condition?”
Read report →“Could you write SQL queries for selecting certain items from a database?”
Read report →Formats, difficulty and experience
Across all 51 o9 Solutions interview reports.