AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
i
o9
Solutions
Work with us 
Compare
Filter interviews by
o9 Solutions Interview Questions and Answers
16 Interview questions
Monolith architecture is a single, unified system, while microservices architecture breaks down the system into smaller, independent services.
Monolith architecture is a single, unified system where all components are interconnected and interdependent.
Microservices architecture breaks down the system into smaller, independent services that communicate through APIs.
Monoliths are easier to develop and deploy initiall...
Use a hashmap to track duplicates in a list of values
Iterate through the list and store each value in a hashmap with its count
Identify values with count greater than 1 as duplicates
Return the list of values that have duplicates
o9 solutions offers cutting-edge technology and expertise in supply chain planning and digital transformation.
o9 solutions provides advanced AI and machine learning capabilities for optimized decision-making.
Their platform enables real-time visibility and collaboration across the supply chain.
o9 solutions has a proven track record of successful implementations with global companies like Walmart and Nestle.
Trim is used in SQL to remove leading and trailing spaces from a string.
Trim function is used to remove leading and trailing spaces from a string
It is commonly used to clean up data before performing comparisons or concatenations
Syntax: TRIM([LEADING | TRAILING | BOTH] [characters] FROM [string])
Example: SELECT TRIM(' hello ') as trimmed_string
Supply Chain is the process of managing the flow of goods and services from the point of origin to the point of consumption.
Involves planning, sourcing, producing, delivering, and returning goods and services
Focuses on efficiency, cost-effectiveness, and customer satisfaction
Examples include inventory management, transportation logistics, and supplier relationships
Cannibalization is the negative impact on sales of a company's own products due to the introduction of a new product.
Occurs when a new product reduces sales of an existing product within the same company
Can lead to decreased overall revenue and market share
Companies must carefully manage product launches to minimize cannibalization
Example: Apple releasing a new iPhone model that causes a decrease in sales of older...
SQL commands are used to interact with databases and perform various operations.
SELECT: retrieves data from a database
INSERT: inserts new data into a database
UPDATE: modifies existing data in a database
DELETE: deletes data from a database
CREATE: creates a new database, table, or view
ALTER: modifies the structure of a database object
DROP: deletes a database object
JOIN: combines rows from two or more tables based on...
The angle between the hour hand and minute hand at 3:15 is 7.5 degrees.
At 3:00, the hour hand is at the 3 o'clock position, which is 90 degrees.
In 15 minutes, the minute hand moves 90 degrees (360 degrees divided by 4).
The hour hand also moves slightly in 15 minutes, covering 7.5 degrees (30 degrees divided by 4).
Therefore, the angle between the hour hand and minute hand at 3:15 is 7.5 degrees.
Deep learning in supply chain can optimize operations, improve forecasting accuracy, and enhance decision-making.
Deep learning can be used in supply chain for demand forecasting, inventory optimization, and route optimization.
It can help in identifying patterns and trends in data to make more accurate predictions.
Deep learning models can analyze large volumes of data quickly and efficiently, leading to better deci...
Machine learning algorithms commonly used in sales prediction include linear regression, decision trees, random forests, and neural networks.
Linear regression: used to establish a relationship between independent and dependent variables
Decision trees: used to make decisions based on a series of questions and answers
Random forests: ensemble method combining multiple decision trees for improved accuracy
Neural networ...
o9 Solutions Interview Experiences
46 interviews found
Anonymous
I applied via Campus Placement
Aptitude followed by sql based technical test
(2 Questions)
- Q1. Machine learning algos used in sales prediction
- Ans.
Machine learning algorithms commonly used in sales prediction include linear regression, decision trees, random forests, and neural networks.
Linear regression: used to establish a relationship between independent and dependent variables
Decision trees: used to make decisions based on a series of questions and answers
Random forests: ensemble method combining multiple decision trees for improved accuracy
Neural networks: d...
- Q2. Supply chain and use of deep learning instead of ml in it
- Ans.
Deep learning in supply chain can optimize operations, improve forecasting accuracy, and enhance decision-making.
Deep learning can be used in supply chain for demand forecasting, inventory optimization, and route optimization.
It can help in identifying patterns and trends in data to make more accurate predictions.
Deep learning models can analyze large volumes of data quickly and efficiently, leading to better decision-...
(2 Questions)
- Q1. Resume projects
- Q2. Basic hr questions
Skills evaluated in this interview
Selected
I applied via Campus Placement and was interviewed in Sep 2024. There was 1 interview round.
(4 Questions)
- Q1. What is normalisation
- Q2. About the project done in final year
- Q3. Demand planning process
- Q4. Supply planning process
Interview Preparation Tips
Simple Python and SQL questions coding questions. 50 MCQs
(3 Questions)
- Q1. Spark Architecture and all basics of Spark
- Q2. Find the the values in a list that have duplicates
- Ans.
Use a hashmap to track duplicates in a list of values
Iterate through the list and store each value in a hashmap with its count
Identify values with count greater than 1 as duplicates
Return the list of values that have duplicates
- Q3. PySpark Questions on Aggregations
Skills evaluated in this interview
I applied via Campus Placement and was interviewed in Sep 2024. There were 3 interview rounds.
40 apptitide and 10 Sql questions to be solved in 55 min
(2 Questions)
- Q1. About the projects
- Q2. Behavioral questions
(1 Question)
- Q1. Why o9 solutions ?
- Ans.
o9 solutions offers cutting-edge technology and expertise in supply chain planning and digital transformation.
o9 solutions provides advanced AI and machine learning capabilities for optimized decision-making.
Their platform enables real-time visibility and collaboration across the supply chain.
o9 solutions has a proven track record of successful implementations with global companies like Walmart and Nestle.
Interview Preparation Tips
Selected
I appeared for an interview in Mar 2025, where I was asked the following questions.
- Q1. There was some dsa question, based on string. I can’t rembeber it but it was easy to medium
- Q2. SQL easy to medium
I applied via Referral and was interviewed in Dec 2024. There was 1 interview round.
(1 Question)
- Q1. Monolith architecture vs microservices?
- Ans.
Monolith architecture is a single, unified system, while microservices architecture breaks down the system into smaller, independent services.
Monolith architecture is a single, unified system where all components are interconnected and interdependent.
Microservices architecture breaks down the system into smaller, independent services that communicate through APIs.
Monoliths are easier to develop and deploy initially, bu...
Siddhant Priyadarshi
1.5hr SQL, verbal reasoning, statistics and probability
(1 Question)
- Q1. For what purpose trim used in sql?
- Ans.
Trim is used in SQL to remove leading and trailing spaces from a string.
Trim function is used to remove leading and trailing spaces from a string
It is commonly used to clean up data before performing comparisons or concatenations
Syntax: TRIM([LEADING | TRAILING | BOTH] [characters] FROM [string])
Example: SELECT TRIM(' hello ') as trimmed_string
Skills evaluated in this interview
I applied via Campus Placement and was interviewed in Jan 2024. There were 2 interview rounds.
Easy to medium level aptitude and basic SQL questions.
(5 Questions)
- Q1. SQL basic questions
- Q2. DDL,DCl commands
- Q3. Write down SQL commands
- Q4. OOPS concepts and applications
- Ans.
OOPS concepts and applications
OOPS stands for Object-Oriented Programming System
It is a programming paradigm that uses objects to represent and manipulate data
Key concepts include encapsulation, inheritance, and polymorphism
OOPS allows for modular and reusable code
Examples of OOPS languages include Java, C++, and Python
- Q5. About project and explain in detail
Interview Preparation Tips
Skills evaluated in this interview
Based on sql and general aptitude for campus recruitment
It was based on mostly SQL and database
Selected
I applied via Campus Placement and was interviewed in Oct 2023. There were 2 interview rounds.
The round consisted of 2 sections.
The first section was on Aptitude and the second round was on SQL queries.
Someone with good practice on both of this topic can easily crack the 1st round.
Bt u need to have a good cgpa atleast 8.5 to sit for the exam
(1 Question)
- Q1. 1.Various questions on supply chain 2.Then some case studies 3.Some technical questions on my projects (basic to moderate) 4.Moderate level of data analytics knowledge 5.The hard part of the interview was ...
Interview Preparation Tips
2.Good communication and confidence
3.practice SQL queries as much as u can
Top trending discussions
o9 Solutions Interview FAQs
The duration of o9 Solutions interview process can vary, but typically it takes about less than 2 weeks to complete.
Tell us how to improve this page.
o9 Solutions Interviews By Designations
- o9 Solutions Consultant Interview Questions
- o9 Solutions Presales Consultant Interview Questions
- o9 Solutions Senior Consultant Interview Questions
- o9 Solutions Senior Functional Consultant Interview Questions
- o9 Solutions Technical Consultant Interview Questions
- o9 Solutions Functional Consultant Interview Questions
- o9 Solutions QA Engineer Interview Questions
- o9 Solutions Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
- Consultant Interview Questions
- Team Lead Interview Questions
- Software Engineer Interview Questions
- Business Analyst Interview Questions
- Sales Executive Interview Questions
- Senior Engineer Interview Questions
- Graduate Engineer Trainee (Get) Interview Questions
- Accountant Interview Questions
- Show more
Overall Interview Experience Rating
based on 30 interview experiences
Difficulty level
Duration
Interview Questions from Similar Companies
o9 Solutions Reviews and Ratings
based on 261 reviews
Rating in categories
|
Senior Consultant
308
salaries
|  ₹11.5 L/yr - ₹20 L/yr |
|
Consultant
220
salaries
| ₹7.7 L/yr - ₹14.2 L/yr |
|
Senior Functional Consultant
126
salaries
| ₹11.5 L/yr - ₹23.5 L/yr |
|
Senior Technical Consultant
94
salaries
| ₹10.1 L/yr - ₹16.9 L/yr |
|
Solution Architect
89
salaries
| ₹19 L/yr - ₹44 L/yr |
Thomson Reuters
Oracle Cerner
Chetu
R Systems International
- Home >
- Interviews >
- o9 Solutions Interview Questions
