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
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
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
General aptitude test of 3 hours on mettle platform
(2 Questions)
- Q1. Tell me about your final year project?
- Ans.
My final year project was a web-based inventory management system.
Developed using HTML, CSS, and JavaScript
Implemented a database to store product information
Designed a user-friendly interface for managing inventory
Included features like adding, updating, and deleting products
Implemented search and filter functionality for easy product retrieval
- Q2. Tell me about your internship experience?
- Ans.
I had a summer internship at a consulting firm where I worked on various client projects.
Worked on market research and analysis for a client in the retail industry
Assisted in developing a strategic plan for a healthcare organization
Collaborated with a team to create a financial model for a technology startup
Conducted data analysis and prepared reports for client presentations
Participated in client meetings and contribu...
Interview Preparation Tips
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
(1 Question)
- Q1. Tell me about yourself
(1 Question)
- Q1. Testing process
(1 Question)
- Q1. Salary expectation
(2 Questions)
- Q1. Describe yourself in 5 words
- Q2. What do you think about managing?
Interview Preparation Tips
(1 Question)
- Q1. General
Interview Preparation Tips
I applied via Company Website and was interviewed in Apr 2022. There were 3 interview rounds.
Money , Health and Education which is important
(1 Question)
- Q1. SQL Queries OOPs Conecpt
(1 Question)
- Q1. Why we should hire you?
- Ans.
I have the necessary skills, experience, and passion to excel in this role.
I have a strong academic background in the relevant field.
I have successfully completed internships and projects related to consulting.
I possess excellent analytical and problem-solving skills.
I am a quick learner and adapt well to new environments.
I have exceptional communication and interpersonal skills.
I am highly motivated and have a strong ...
Interview Preparation Tips
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
- Senior Consultant Interview Questions
- Senior Associate Consultant Interview Questions
- Lead Consultant Interview Questions
- Technical Consultant Interview Questions
- Consultant Interview Questions
- Associate Technical Consultant Interview Questions
- Principal Consultant Interview Questions
- Technology Consultant Interview Questions
- Show more
Associate Consultant Interview Questions from Similar Companies
Fast track your campus placements
|
Senior Consultant
224
salaries
|  ₹10 L/yr - ₹21.1 L/yr |
|
Consultant
173
salaries
| ₹8 L/yr - ₹14 L/yr |
|
Technical Consultant
83
salaries
| ₹7.5 L/yr - ₹13 L/yr |
|
Solution Architect
78
salaries
| ₹21 L/yr - ₹40 L/yr |
|
Senior Technical Consultant
76
salaries
| ₹11 L/yr - ₹19.5 L/yr |
Blue Yonder
Manhattan Associates
Kinaxis
Anaplan
- Home >
- Interviews >
- o9 Solutions Interview Questions >
- o9 Solutions Associate Consultant Interview Questions
