Upload Button Icon Add office photos

Filter interviews by

Othain Group Lead Analyst Interview Questions and Answers

Updated 17 Mar 2024

Othain Group Lead Analyst Interview Experiences

1 interview found

Lead Analyst Interview Questions & Answers

user image Anonymous

posted on 17 Mar 2024

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(1 Question)

  • Q1. All about the past experience

Interview questions from similar companies

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. What is the pivot table in Excel
  • Ans. 

    A pivot table in Excel is a data summarization tool that allows you to reorganize and summarize selected columns and rows of data.

    • Allows users to summarize and analyze large datasets

    • Can easily reorganize data by dragging and dropping fields

    • Provides options to calculate sums, averages, counts, etc. for data

    • Helps in creating interactive reports and charts

    • Useful for identifying trends and patterns in data

  • Answered by AI
  • Q2. A pivot table is used to summarize...........etc.

Interview Preparation Tips

Interview preparation tips for other job seekers - "tailor your resume for each job application."

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Aug 2024. There was 1 interview round.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Tell me about yourself?
  • Ans. 

    I am a dedicated and detail-oriented business analyst with a strong background in data analysis and problem-solving.

    • I have a Bachelor's degree in Business Administration

    • I have experience in conducting market research and analyzing data to identify trends

    • I am proficient in using tools like Excel, SQL, and Tableau for data analysis

    • I have excellent communication skills and can effectively collaborate with cross-functional

  • Answered by AI
  • Q2. Some questions on project
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
6-8 weeks
Result
Not Selected

I applied via LinkedIn and was interviewed in Apr 2024. There were 3 interview rounds.

Round 1 - Assignment 

Case study analysis and on spot requirements documentation

Round 2 - Technical 

(1 Question)

  • Q1. What are your achievements?
Round 3 - One-on-one 

(1 Question)

  • Q1. Explain your responsibilities in your previous role in your company
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. Normal question about past experience
  • Q2. When you can join and all
Round 2 - Assignment 

SQL test on Select query, insert, create

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(1 Question)

  • Q1. How many swift cars in mumbai?
  • Ans. 

    The exact number of Swift cars in Mumbai is not available, but it is a popular choice among car owners in the city.

    • Swift cars are a common sight on the roads of Mumbai.

    • Maruti Suzuki, the manufacturer of Swift cars, has a strong presence in the city.

    • The number of Swift cars in Mumbai is constantly changing due to sales and purchases.

    • One can see multiple Swift cars in popular areas like Bandra, Andheri, and South Mumbai.

  • Answered by AI

Skills evaluated in this interview

Interview experience
2
Poor
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Aug 2023. There were 3 interview rounds.

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 - Case Study 

They will give you to study Abode Magento to study.

Round 3 - Assignment 

They will ask you create a presentation and to present it.
Even after getting the job offer and joining the company please don't think that they will confirm your position. Anytime the higher management will ask you to give test and if you don't perform they will ask you to leave.

Interview Preparation Tips

Interview preparation tips for other job seekers - Even after getting the job offer and joining the company please don't think that they will confirm your position. You will ask to give 2-3 test every month on the course they will tell you to study. If you don't clear the test they will ask you to leave.

And if you are a new joinee they expect you to do their whole work immediately.
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
-

I applied via Campus Placement and was interviewed in Aug 2023. There were 3 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 - Aptitude Test 

It was good. We were given two situation for which we have to find the solutions.

Round 3 - Group Discussion 

In this round companies offical started asking about the happening around us and their reasons.

I applied via Campus Placement and was interviewed in Sep 2022. There were 4 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 - Case Study 

There was 2 Case Study Questions

Round 3 - Group Discussion 

The Group Discussion round was basically to analyze the analytical skills .
Firstly , They asked to Introduce
Then some situational questions were asked.

Round 4 - One-on-one 

(2 Questions)

  • Q1. This was final round to check confidence and basic general knowledge.
  • Q2. Questions based on key skills candidate have.

Interview Preparation Tips

Interview preparation tips for other job seekers - If you are not good in programming skills
You can go for QA- BA and also Content Writting if it interests you.
All the Best !!

Othain Group Interview FAQs

How many rounds are there in Othain Group Lead Analyst interview?
Othain Group interview process usually has 1 rounds. The most common rounds in the Othain Group interview process are One-on-one Round.

Tell us how to improve this page.

Othain Group Lead Analyst Interview Process

based on 2 interviews

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.4k Interviews
Accenture Interview Questions
3.8
 • 8.2k Interviews
Infosys Interview Questions
3.6
 • 7.6k Interviews
Wipro Interview Questions
3.7
 • 5.6k Interviews
Cognizant Interview Questions
3.8
 • 5.6k Interviews
Capgemini Interview Questions
3.7
 • 4.8k Interviews
Tech Mahindra Interview Questions
3.5
 • 3.8k Interviews
HCLTech Interview Questions
3.5
 • 3.8k Interviews
LTIMindtree Interview Questions
3.8
 • 3k Interviews
IBM Interview Questions
4.0
 • 2.4k Interviews
View all
Othain Group Lead Analyst Salary
based on 73 salaries
₹3.3 L/yr - ₹8.3 L/yr
59% less than the average Lead Analyst Salary in India
View more details

Othain Group Lead Analyst Reviews and Ratings

based on 10 reviews

2.5/5

Rating in categories

2.5

Skill development

2.3

Work-life balance

3.4

Salary

2.0

Job security

2.3

Company culture

2.0

Promotions

2.3

Work satisfaction

Explore 10 Reviews and Ratings
Lead Analyst
73 salaries
unlock blur

₹3.3 L/yr - ₹8.3 L/yr

Support Analyst Lead
39 salaries
unlock blur

₹2.7 L/yr - ₹5.3 L/yr

Team Lead
34 salaries
unlock blur

₹6.2 L/yr - ₹13.2 L/yr

Senior Analyst
24 salaries
unlock blur

₹2.8 L/yr - ₹6.1 L/yr

SME
17 salaries
unlock blur

₹5.7 L/yr - ₹9 L/yr

Explore more salaries
Compare Othain Group with

Infosys

3.6
Compare

TCS

3.7
Compare

Wipro

3.7
Compare

HCLTech

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