AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
o9 Solutions Associate Consultant Interview Questions and Answers
o9 Solutions Associate Consultant Interview Experiences
1 interview found
Anonymous
I was interviewed before Dec 2020.
(1 Question)
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
(2 Questions)
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
STRwhich contains alphabets, numbers, and special characters. Your task is to reverse the string.Example:
Input:
STR = "abcde"
Output:
"e...
- 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...
- 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.
Interview Preparation Tips
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
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
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
Selected
Was given online and the topic was cryptocurrency
(1 Question)
- Q1. SQL JAVA and basic HR QUESTIONS
A topic of given and we had discuss the topic like debate
(2 Questions)
- Q1. Give an elevator pitch to the director of ITC about the company’s product
- Q2. How does distribution channel works
- Ans.
Distribution channels are pathways through which products or services are delivered from the manufacturer to the end consumer.
Distribution channels can include wholesalers, retailers, e-commerce platforms, and direct sales.
They help in reaching a wider customer base and increasing product availability.
Efficient distribution channels can lead to faster delivery times and lower costs.
Examples include Amazon as an e-comme...
(2 Questions)
- Q1. How would handle your customers
- Ans.
I would handle my customers with empathy, active listening, and prompt resolution of their issues.
Practice active listening to understand customer needs and concerns
Show empathy and understanding towards customer frustrations
Provide prompt and effective solutions to customer problems
Maintain a positive and professional attitude at all times
- Q2. Are you ready for relocation
Interview Preparation Tips
Coding roung plus technical questions were asked
(2 Questions)
- Q1. Previous experiences
- Q2. Job and responsibilities
(2 Questions)
- Q1. Salary discussion
- Q2. Previous employment details and document sumbission
Selected
I applied via Naukri.com and was interviewed before Oct 2023. There were 4 interview rounds.
(2 Questions)
- Q1. Banking domain questions
- Q2. Sanction procedure
(2 Questions)
- Q1. Financial ratios
- Q2. Sanction procedure, banking domain and many related to banking domain corporate and retail
(1 Question)
- Q1. Simple about your thinking procedure
(1 Question)
- Q1. As usual pay discussion
Proper communication skills
60 question maximum of the questions are sum
Interview Preparation Tips
Amiksha g
Does travelling helps in healing
Selected
I applied via campus placement at Praxis Business School, Kolkata and was interviewed before Sep 2022. There were 4 interview rounds.
Simple test based on Cat questions
Was given topic and asked to discuss. Was of 10mins with 6 candidates
(4 Questions)
- Q1. Difference between sales and marketing?
- Ans.
Sales focuses on selling products or services to customers, while marketing involves creating awareness and interest in those products or services.
Sales involves direct interaction with customers to close deals
Marketing involves creating strategies to attract and retain customers
Sales is more focused on immediate revenue generation
Marketing is more focused on long-term brand building and customer relationships
Sales is ...
- Q2. About nihilent?
- Q3. Product of nihilent?
- Ans.
Nihilent is a global consulting and solutions integration company.
Nihilent provides services in the areas of digital transformation, business process outsourcing, and technology solutions.
They offer consulting services to help organizations improve their business processes and achieve their goals.
Nihilent has worked with clients in various industries such as healthcare, financial services, and telecommunications.
- Q4. Why join nihilent?
Interview Preparation Tips
- Sales
- mar
- market research
Selected
(1 Question)
- Q1. Interview questions based on angular topics And one coding question in JavaScript using array methods
(1 Question)
- Q1. It's a manager round asked about last project business scope and some behaviour questions
Interview Preparation Tips
(1 Question)
- Q1. Tell me about yourself
(1 Question)
- Q1. Testing process
(1 Question)
- Q1. Salary expectation
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 Functional Consultant Interview Questions
- o9 Solutions QA Engineer Interview Questions
- o9 Solutions Technical Consultant Interview Questions
- o9 Solutions Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
- Associate Software Engineer Interview Questions
- Senior Associate Consultant Interview Questions
- Project Associate Interview Questions
- Associate Systems Engineer Interview Questions
- Associate Interview Questions
- Associate Technical Consultant Interview Questions
- Senior Associate Interview Questions
- Application Development Associate Interview Questions
- Show more
Associate Consultant Interview Questions from Similar Companies
Fast track your campus placements
|
Senior Consultant
223
salaries
|  ₹10 L/yr - ₹21.1 L/yr |
|
Consultant
175
salaries
| ₹7.7 L/yr - ₹14 L/yr |
|
Technical Consultant
84
salaries
| ₹7.5 L/yr - ₹13 L/yr |
|
Solution Architect
79
salaries
| ₹21 L/yr - ₹40 L/yr |
|
Senior Functional Consultant
76
salaries
| ₹10 L/yr - ₹21.7 L/yr |
Blue Yonder
Manhattan Associates
Kinaxis
Anaplan
- Home >
- Interviews >
- o9 Solutions Interview Questions >
- o9 Solutions Associate Consultant Interview Questions
