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 Associate Consultant Interview Questions and Answers
o9 Solutions Associate Consultant Interview Experiences
1 interview found
Anonymous
I appeared for an interview 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
Interview Questionnaire
3 Questions
- Q1. Mostly around client management, handling and collaboration.
- Q2. Puzzles and Guesstimates
- Q3. Case study- Simple one
Interview Preparation Tips
The questions were good and conceptual based.
English was also asked in the first round
paragraph questions were also there
(1 Question)
- Q1. Was given a case study to solve
Interview Preparation Tips
Selected
I applied via Referral and was interviewed before May 2023. There were 3 interview rounds.
Easy aptitude question
(1 Question)
- Q1. Very friendly interaction
(1 Question)
- Q1. Case study question
(1 Question)
- Q1. Based on experience and some technical scripting best practice question
(1 Question)
- Q1. Virtual agent presentation to a client and demo, followed by questions related to VA
(1 Question)
- Q1. Around experience
Nirban Chatterjee
I applied via Naukri.com and was interviewed before Oct 2019. There was 1 interview round.
Interview Questionnaire
2 Questions
- Q1. Normal php questions like overriding,overloading,traits,interface,abstarct class nothing else.. It was online but in 2016.
- Q2. Go though those topic as they are very important and asked in most companies.
Interview Preparation Tips
Interview Questionnaire
2 Questions
- Q1. Algorithm and Trick questions on Java
- Q2. Your future interest, interaction capabilities
Interview Preparation Tips
Experience: Mention only those projects/works which you feel fully confident on, let any question be thrown your way.
Believe me, a simple project explained in a good way is better than a complex project that scares you going into the details.
Tips: A little bit of extra activities (sports/music) helps them picture you as not a total nerd, which might help in front of some interviewers.
Round: Interview
Experience: They will mostly try to trick you here, even if you are right, they will make you doubt yourself. It's just about believing oneself and answering in one go.
Tips: Stick to your answers if you feel it's right, changing it again and again won't do you much good.
Round: Interview
Experience: This is where you have to be most careful, what they seek is just your interest in the company or infact passion for their work and not leaving them mid-way for higher studies or startup plans.
Tips: Diverting talks to some extra-currics might help a lot here specially if they have interest in that too, like the one, I was giving interview to, was wearing a Barcelona cap and I had mentioned that I played football at Inter-Hostel level. So we talked about the recent Premier league for like 10 minutes and the mood was really lightened, thanks to that.
General Tips: It is never too late to be what you might have been.
Skills: Algorithms, Java, Interaction Skills, coding, C, C++
College Name: IIT DELHI
Motivation: The technology (Social-Media Management) they are working on is really interesting to know more about and can be a future pioneer in the coming days.
Funny Moments: One of the interviewer I became so friendly with, mid-way through the interview that we added each other right there on facebook.
Interview Preparation Tips
Experience: They asked to write 2 codes on recursion. Then some questions on resume. I asked them about the job profile and after knowing that they were hiring candidates for frontend programming, about which they didn’t mention in JAF. I told them that I was not interested in frontend development. And didn’t even answer any question after that. Unfortunately, I was selected.
General Tips: Plan your schedule judiciously keeping your capacity in mind. There is no point of making ideal plans and then not able to do even 50% of it.
Don’t get into unnecessary arguments or debate with people.
Don’t think about what others are doing. Focus on your preparation.
How you carry yourself matters. So, make sure you portray yourself in the way you want the other person to perceive you.
Be selective while applying for companies.
College Name: IIT Kanpur
Varun Thopucherla
Interview Questionnaire
10 Questions
- Q1. Tell about yourself?
- Ans.
I am a software engineer with experience in developing web applications and mobile apps.
Proficient in programming languages such as Java, Python, and JavaScript
Experience in developing RESTful APIs and integrating third-party APIs
Familiarity with front-end frameworks such as React and Angular
Strong understanding of database management systems such as MySQL and MongoDB
Passionate about learning new technologies and keepi...
- Q2. Why Software industry? why not core?
- Ans.
Software industry offers endless opportunities for innovation and growth.
Software industry is constantly evolving and offers opportunities to work on cutting-edge technologies.
It provides a platform to solve complex problems and create innovative solutions.
The demand for software engineers is high and the industry offers competitive salaries.
Core industries may have limited scope for growth and innovation compared to s...
- Q3. Write a program to print the given string in reverse
- Ans.
Program to print a given string in reverse
Create a character array of the given string
Loop through the array from end to start and print each character
- Q4. Some questions about computer networks and Digital electronics
- Q5. What is Mux? what are its real life applications?
- Ans.
Mux is a device that selects one of several input signals and forwards the selected input into a single output line.
Mux stands for Multiplexer.
It is used in digital circuits to select one of several input signals and forward the selected input into a single output line.
It is used in communication systems to combine multiple signals into a single channel for transmission.
It is used in video and audio systems to switch b...
- Q6. What is DeMux? what are its real life applications?
- Ans.
DeMux is short for Demultiplexer. It is a digital circuit that takes one input and directs it to multiple outputs.
DeMux is used in digital communication systems to separate signals that have been combined for transmission.
It is also used in computer memory systems to select a specific memory location.
DeMux is used in video and audio systems to separate different channels of information.
It is used in automation systems ...
- Q7. Difference between decoder and Demux
- Ans.
Decoder converts encoded data into a readable format while Demux separates a single input into multiple outputs.
Decoder is used to decode encoded data such as binary data into a readable format.
Demux is used to separate a single input into multiple outputs based on the control signals.
Decoder is a combinational circuit while Demux is a sequential circuit.
Decoder is used in applications such as remote controls, computer...
- Q8. Why amadeus labs?
- Ans.
Amadeus Labs is a leading technology company in the travel industry.
Amadeus Labs provides opportunities to work on cutting-edge technologies.
The company has a strong focus on innovation and research.
Amadeus Labs has a global presence and offers a diverse and inclusive work environment.
Working at Amadeus Labs provides the opportunity to make a real impact on the travel industry.
The company values work-life balance and o...
- Q9. Are you comfortable in working for Testing?
- Ans.
Yes, I am comfortable working for Testing.
I have experience in testing and understand its importance in software development.
I am willing to learn new testing techniques and tools.
I am comfortable working with testing teams and collaborating with them to ensure quality software.
I understand the importance of testing in ensuring customer satisfaction and reducing costs.
Examples: I have experience in manual and automated...
- Q10. Why do you consider yourself suitable for developer role?
- Ans.
I have the necessary skills and experience to excel in the developer role.
I have a degree in computer science and have completed multiple coding projects.
I am proficient in programming languages such as Java, Python, and C++.
I have experience working with databases and web development frameworks.
I am a quick learner and enjoy solving complex problems.
I am a team player and have collaborated with other developers on var...
Interview Preparation Tips
Experience: The test was conducted online. All the questions were of medium standard and easy to crack if we have patience for thinking.
English comprehension level is slightly below the standard of CAT. Those who have the habit of reading English news paper can easily crack the test.
Data analysis questions were also of medium standard. Those who have knowledge about graphs, bar & pie charts can easily crack the exam.
Tips: Practice Aptitude questions from R S Agarwaal book and CAT material.
Round: Technical Interview
Experience: Over all interview experience is cool. Interviewers never grilled on anything. In many cases they have helped me to arrive at answers.
Tips: Read C++ and Oops concepts from E Balaguruswamy text book.
For Data structures and algorithms read 'Data structures' by Yeshwant kanethkar.
Minimum knowledge about all the courses of your department will be an added advantage. This will help you to depict you are sincere in your studies and don't have any personal constraints in learning a new thing.
General Tips: Just be confident and believe in yourself. You will get through.
Skills: Programming skill in C++
College Name: NIT Warangal
Motivation: No special motivation. It is a rapidly growing company offering good package.
Skills evaluated in this interview
I appeared for an interview in Aug 2016.
Interview Preparation Tips
Experience: The questions were tricky. We were given a paragraph and after reading it, a statement was given to us and we were asked to say if it is true, false or cannot say. The structure of the statement put us into a a tough place. So practice of such kind of questions is necessary.
For data interpretation questions a good hand on basic statistical mathematics is needed. One has to be quick because of the time crunch. The questions were approachable
Round: Technical Interview
Experience: In this round my resume was scanned and I was required to speak about myself, my projects and explain certain areas of my resume. The interviewer picked up one of my basic project, surprisingly, and asked me to elaborate on it. He asked me how I can improve the project. And I had to write a code to make that change. Basically, one should have a good idea about the projects they've done/ mentioned in their resume. And know it in detail.
Few questions on data structures. Prepare well for coding type questions and data structures.
Round: Puzzle Interview
Experience: The interviewer asked me two puzzles. They were moderate level. And also luckily he was helpful whenever I got stuck.
Round: HR Interview
Experience: HR round was good. Basic questions like " tell me more about yourself", brief information about my past history, college life, extra curricular activities. In the end she asked me, "should we hire you?" And I lightly answered " why not!" So it was a good interview overall.
Skills: Coding Skills, Team Working Ability, Project management
College Name: Visvesvaraya National Institute Of Technology
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
- Software Developer Interview Questions
- Software Engineer Interview Questions
- Consultant Interview Questions
- System Engineer Interview Questions
- Associate Software Engineer Interview Questions
- Associate Interview Questions
- Senior Associate Interview Questions
- Project Engineer Interview Questions
- Show more
Interview Questions from Similar Companies
|
Senior Consultant
308
salaries
|  ₹10.2 L/yr - ₹25 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
| ₹7.6 L/yr - ₹20 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
