Upload Button Icon Add office photos

o9 Solutions

Compare button icon Compare button icon Compare

Filter interviews by

o9 Solutions Technical Consultant Interview Questions and Answers

Updated 20 Aug 2024

o9 Solutions Technical Consultant Interview Experiences

2 interviews found

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Based on sql and general aptitude for campus recruitment

Round 2 - Coding Test 

It was based on mostly SQL and database

I applied via Campus Placement and was interviewed in Mar 2021. There were 3 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. SQL questions
  • Q2. Approximate questions
  • Q3. Why do you want to join this company?

Interview Preparation Tips

Interview preparation tips for other job seekers - Not so technical mostly maegerial questions

Technical Consultant Interview Questions Asked at Other Companies

asked in Mastek
Q1. Oops C and java difference Query for selecting all columns from a ... read more
Q2. What are the real time applications of spring concept in java?
asked in HCLTech
Q3. What is difference between family ipv6 route-target and default-r ... read more
asked in PwC
Q4. If I give you a new tool can you cope with it
asked in HCLTech
Q5. Why we received sngl collisions error on port what's the issue an ... read more

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Psa and easy to solve questions

Round 2 - Group Discussion 

Easy gd impact on metros

Round 3 - Coding Test 

Knowledge based question

I applied via Recruitment Consultant and was interviewed in Feb 2021. There were 4 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. Azure Technicals, Partner Management
  • Q2. Customer Service
  • Q3. Shift Flexibility

Interview Preparation Tips

Interview preparation tips for other job seekers - Be yourself, Sonata is very open company and the management who is taking your interview is very cool to hear out your answers.
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-

I applied via campus placement at Parul Institute of Management and Research, Vadodara

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Group Discussion 

Kind of tough but went well

Round 3 - Aptitude Test 

It was pl sql based and some aptitude questions

Round 4 - One-on-one 

(1 Question)

  • Q1. Technical knowledge was examined

I applied via Recruitment Consultant and was interviewed before Dec 2019. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Technical n confidence related stuff.

Interview Preparation Tips

Interview preparation tips for other job seekers - Be very keen and specific about knowing for what kind of positions you are attending for interview with Sonata software, because here in Sonata FTE means Fixed Term Employment not Full Time Employee.
No one will tell you about this untill you see for yourself in offer letter.

I applied via Campus Placement and was interviewed in Jul 2022. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - Group Discussion 

It was a pool campus drive for Mumbai University Affiliated College's. More than 200+ candidates applied for this drive. They divided candidates into 10 number of peoples for GD round.
My topic was India Go Cashless, tell the merits and demerits. You must give atleast 5-6 valid points for selection,listen carefully what other candidates were telling, dont interrurpt them in between(negative sign). This rounds goes around 30-35 mins. After Healthy discussion, results announced after 1 Hour. They select 2-3 people per group(out of 10).

Round 3 - Technical 

(1 Question)

  • Q1. Started with greeting him, He introduced himself and told to introduce myself, after he wants to know my family background. After that he directly jump into my resume, asked alot of questions based on my r...
Round 4 - HR 

(1 Question)

  • Q1. Started with greeting him, He asked me why you want to apply for Technical Role, not functional role. Tell me about your weakness, asked me about where do you see yourself after 5 years and more basic hr q...

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare your Resume as much as you can!!! Dont Mention alots of technologies, Skills like in which you are not sure. as far as my personal experience is concerned, resume plays an important role. Be confident, Dont Nervous. All the best!
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I was interviewed before Feb 2024.

Round 1 - Aptitude Test 

Basic test of aptitude

Round 2 - Coding Test 

Sql and plsql questions

Round 3 - HR 

(1 Question)

  • Q1. All the best for your interview
Round 4 - HR 

(1 Question)

  • Q1. Best wishes give your best

Interview Preparation Tips

Interview preparation tips for other job seekers - All the best! Give your best

I applied via Campus Placement and was interviewed in Jul 2022. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all tips
Round 2 - Group Discussion 

The topic was healthy food vs junk food
Which was pretty simple and there were 3 members noticing us ,we were 13 students speaking about the topic

Round 3 - Level 1 round 

(1 Question)

  • Q1. Oops C and java difference Query for selecting all columns from a table 10 uses of a pen Personal questions like the place we belong to What do you know about our company The interview was not really ...
  • Ans. 

    Interview for Technical Consultant with questions on C and Java differences, SQL queries, and company knowledge.

    • Discuss differences between C and Java programming languages

    • Provide an example of a SQL query to select all columns from a table

    • Research and understand the company's background and values

    • Be prepared for personal questions about your background and experience

    • Emphasize practical experience and problem-solving s

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Evosys merged with mastek ,and they guys were hiring for evosys for sure 😃
The whole process seemed fake to me

I applied via campus placement at KJ Somaiya Institute of Engineering and Information Technology and was interviewed in Jul 2022. There were 2 interview rounds.

Round 1 - Group Discussion 

Topic was should 75 percent aytendance be mandatory in college

Round 2 - One-on-one 

(1 Question)

  • Q1. Question besed on my resume were asked.

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and aware about what you have written on your resume.

o9 Solutions Interview FAQs

How many rounds are there in o9 Solutions Technical Consultant interview?
o9 Solutions interview process usually has 2 rounds. The most common rounds in the o9 Solutions interview process are Aptitude Test and Coding Test.
How to prepare for o9 Solutions Technical Consultant interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at o9 Solutions. The most common topics and skills that interviewers at o9 Solutions expect are ETL, SQL, SSIS, Informatica and ETL Tool.
What are the top questions asked in o9 Solutions Technical Consultant interview?

Some of the top questions asked at the o9 Solutions Technical Consultant interview -

  1. SQL questi...read more
  2. Approximate questi...read more

Tell us how to improve this page.

o9 Solutions Technical Consultant Interview Process

based on 2 interviews

Interview experience

5
  
Excellent
View more
o9 Solutions Technical Consultant Salary
based on 83 salaries
₹7.5 L/yr - ₹13 L/yr
10% less than the average Technical Consultant Salary in India
View more details

o9 Solutions Technical Consultant Reviews and Ratings

based on 8 reviews

4.8/5

Rating in categories

3.8

Skill development

4.3

Work-life balance

4.0

Salary

4.4

Job security

4.8

Company culture

3.7

Promotions

4.0

Work satisfaction

Explore 8 Reviews and Ratings
Senior Consultant
224 salaries
unlock blur

₹10 L/yr - ₹21.1 L/yr

Consultant
173 salaries
unlock blur

₹8 L/yr - ₹14 L/yr

Technical Consultant
83 salaries
unlock blur

₹7.5 L/yr - ₹13 L/yr

Solution Architect
78 salaries
unlock blur

₹21 L/yr - ₹40 L/yr

Senior Technical Consultant
76 salaries
unlock blur

₹11 L/yr - ₹19.5 L/yr

Explore more salaries
Compare o9 Solutions with

Blue Yonder

3.9
Compare

Manhattan Associates

3.8
Compare

Kinaxis

4.0
Compare

Anaplan

1.8
Compare
Did you find this page helpful?
Yes No
write
Share an Interview