Upload Button Icon Add office photos

Filter interviews by

Otto Clothing MIS Executive and Analyst Interview Questions and Answers

Updated 23 Jun 2024

Otto Clothing MIS Executive and Analyst Interview Experiences

1 interview found

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

(2 Questions)

  • Q1. Related sales and FMCg
  • Q2. Calculation markdown

Interview questions from similar companies

I applied via IIM Jobs and was interviewed in Nov 2020. There were 3 interview rounds.

Interview Questionnaire 

7 Questions

  • Q1. Advance SQL Questions.
  • Q2. Multiple Approaches in the SQL questions were seen. Some unconventional SQL Syntax was also asked.
  • Q3. Metrics Driven Case studies.
  • Q4. More number of solutions were seen instead of in depth implementation of 1 solution. Good Communication skills is judged.
  • Q5. Tell me something about yourself.
  • Ans. 

    I am a highly motivated and detail-oriented Business Analyst with a strong background in data analysis and problem-solving.

    • I have a Bachelor's degree in Business Administration with a focus on analytics.

    • I have experience working with cross-functional teams to gather and analyze business requirements.

    • I am proficient in using tools such as Excel, SQL, and Tableau for data analysis and visualization.

    • I have successfully im...

  • Answered by AI
  • Q6. Why quit last job.
  • Ans. 

    Seeking better growth opportunities and work-life balance.

    • Limited growth prospects in previous role

    • Lack of work-life balance

    • Desire for new challenges and learning opportunities

    • Company culture misalignment

    • Relocation or commute issues

    • Better compensation or benefits elsewhere

  • Answered by AI
  • Q7. Why Meesho.
  • Ans. 

    Meesho is a leading e-commerce platform that empowers individuals to start their own online businesses.

    • Meesho provides a user-friendly platform for individuals to sell products online without any investment.

    • It offers a wide range of products from various categories, allowing sellers to cater to different customer preferences.

    • Meesho provides extensive training and support to its sellers, helping them succeed in their on...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be calm, It's very similar to any other business analyst interview in industry.

I applied via LinkedIn and was interviewed before Jul 2021. There were 2 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 - One-on-one 

(1 Question)

  • Q1. Knowledge about data summarisation.and some tools like Power bi and advance excel.

Interview Preparation Tips

Interview preparation tips for other job seekers - Always speak first answer like perfect and effective answer without any hesitation...

I applied via Job Portal

Interview Questionnaire 

1 Question

  • Q1. Tell me about your self?

Interview Preparation Tips

Interview preparation tips for other job seekers - Good

I applied via Naukri.com and was interviewed before Aug 2020. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. Tell about yourself
  • Q2. What is your salary expectation

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview wa easy and can crack it

Data Analyst Interview Questions & Answers

Meesho user image Abhilasa Barman

posted on 26 Dec 2024

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

I was asked a medium-level SQL question that involved the RANK function.

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
No response

I applied via Approached by Company and was interviewed in Oct 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Output of joins
  • Ans. 

    Output of joins is a combination of data from two or more tables based on a common column.

    • Joins are used to combine rows from two or more tables based on a related column between them

    • Types of joins include inner join, outer join, left join, and right join

    • The output of a join will include columns from both tables, with rows that meet the join condition

  • Answered by AI
  • Q2. Rank dense rank cte

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via LinkedIn and was interviewed before Dec 2023. There were 3 interview rounds.

Round 1 - Coding Test 

SQL, Hackerank,CTEs, Window functions , mcq

Round 2 - Coding Test 

SQL,Probability,Python

Round 3 - Case Study 

Orders at amazon down, find the root cause analysis

Analyst Interview Questions & Answers

Dell user image Anonymous

posted on 15 Jul 2022

Round 1 - Aptitude Test 

Easy 30 questions mcqs

Round 2 - Technical 

(1 Question)

  • Q1. One on one technical questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Study CN , DBMS and basics of Data Structure

Interview Questionnaire 

5 Questions

  • Q1.  I hevn't Got a callback Frm u yet
  • Q2. When will I get the call
  • Q3.  Y r u planing attent to my cv
  • Ans. 

    I am planning to attend to your CV to evaluate your qualifications and experience for the Business Analyst role.

    • To assess your skills and knowledge relevant to the job

    • To understand your work experience and achievements

    • To determine if you are a good fit for the company culture

    • To compare your qualifications with other candidates

    • To make an informed decision on whether to invite you for an interview

  • Answered by AI
  • Q4.  Plz is no XXXXX cllback
  • Q5.  Plz infom me this job

Otto Clothing Interview FAQs

How many rounds are there in Otto Clothing MIS Executive and Analyst interview?
Otto Clothing interview process usually has 1 rounds. The most common rounds in the Otto Clothing interview process are HR.
What are the top questions asked in Otto Clothing MIS Executive and Analyst interview?

Some of the top questions asked at the Otto Clothing MIS Executive and Analyst interview -

  1. Related sales and F...read more
  2. Calculation markd...read more

Tell us how to improve this page.

Otto Clothing MIS Executive and Analyst Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more

Interview Questions from Similar Companies

Reliance Retail Interview Questions
3.9
 • 1.6k Interviews
UST Interview Questions
3.8
 • 517 Interviews
Dell Interview Questions
3.9
 • 390 Interviews
CARS24 Interview Questions
3.5
 • 337 Interviews
Meesho Interview Questions
3.7
 • 335 Interviews
Lenskart Interview Questions
3.2
 • 317 Interviews
Nokia Interview Questions
4.1
 • 267 Interviews
John Deere Interview Questions
4.1
 • 235 Interviews
View all
Account Assistant
8 salaries
unlock blur

₹1.8 L/yr - ₹2.4 L/yr

Data Entry Operator
8 salaries
unlock blur

₹1.2 L/yr - ₹3 L/yr

Retail Store Manager
7 salaries
unlock blur

₹1.1 L/yr - ₹3.8 L/yr

Store Manager
7 salaries
unlock blur

₹1.8 L/yr - ₹4 L/yr

Assistant Manager
6 salaries
unlock blur

₹3 L/yr - ₹4.2 L/yr

Explore more salaries
Compare Otto Clothing with

Reliance Retail

3.9
Compare

UST

3.8
Compare

Vivo

4.1
Compare

Dell

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