Upload Button Icon Add office photos

Filter interviews by

Utsav Fashion Senior Data Analyst Interview Questions and Answers

Updated 3 Apr 2023

Utsav Fashion Senior Data Analyst Interview Experiences

1 interview found

Interview experience
1
Bad
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Recruitment Consulltant and was interviewed in Mar 2023. There were 4 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. Introduction about past work and experience
Round 3 - Technical 

(1 Question)

  • Q1. Google sheets , SQL, Tableau
  • Ans. They don't know how to set questions for a technical round. They are confused itself and not able to convey questions to the interviewee.
  • Answered by Aviram Samanta
Round 4 - HR 

(1 Question)

  • Q1. General introduction

Interview Preparation Tips

Interview preparation tips for other job seekers - They don't know how to take technical round of interview. They are confused and making candidate confused too. Asking VLookup but with no lookup value. Like find VLookup from top 10 month wise product? Like seriously what is the value i want to look from the data using VLookup?
Asking SQL query but not defining the query based on SQL. Asking find the VLookup columns using SQL. It totally doesn't make any sense of their questions.

Interview questions from similar companies

I applied via LinkedIn and was interviewed before Aug 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 - Technical 

(4 Questions)

  • Q1. Advance Excel (Vlookup, Index, Countifs, sumifs and others)
  • Q2. Python Basics (data frame, data types, lamda, series etc)
  • Q3. SQL Functions (joins, limits, partitions, orders by and group by)
  • Q4. 3rd round was managerial round, where mostly non-technicial questions asked.

Interview Preparation Tips

Interview preparation tips for other job seekers - Just be confident, while answering the questions and you don't have to know all the questions rightly. It's okay if you don't know some.
Interview experience
1
Bad
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via LinkedIn and was interviewed in Mar 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 - Technical 

(1 Question)

  • Q1. Excel and SQL based questions
Round 3 - Technical 

(1 Question)

  • Q1. Python and project based questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Took 2 interviews over the course of 2 weeks and then 1 hour before my scheduled final / HR round declined to hire me as they decided that they don't want to.
Utter disregard for a candidate's time and work. The humiliating level of such degraded professionalism that they cannot decide before posting an interview that they don't want to hire.
But they have the audacity to expect 7 days and open-ended work schedule from the candidates.
DO NOT APPLY.
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed in Jun 2024. There were 2 interview rounds.

Round 1 - Aptitude Test 

Excel Formula, Hr related excel formula

Round 2 - HR 

(2 Questions)

  • Q1. Why you want to join over organisation?
  • Q2. Why should we higher you?

Interview Preparation Tips

Interview preparation tips for other job seekers - Na

I applied via Naukri.com and was interviewed before Nov 2019. There was 1 interview round.

Interview Questionnaire 

9 Questions

  • Q1. Why are you selling skills ?
  • Q2. When I were?
  • Q3. U can were any time work were & party were.
  • Q4. It worth for me?
  • Q5. Yes,u can were any time.
  • Q6. How was fitting?
  • Q7. Fitting is perfect for u.
  • Q8. Can I buy?
  • Q9. Yes.

Interview Preparation Tips

Interview preparation tips for other job seekers - Thank you
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Apr 2022. 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 - Coding Test 

SQL queries and basic python codes for data cleaning / general functions

Round 3 - One-on-one 

(2 Questions)

  • Q1. Guesstimates and some questions related to product management.
  • Q2. What is product life cycle?
  • Ans. 

    Product life cycle refers to the stages a product goes through from introduction to decline.

    • Product life cycle consists of four stages: introduction, growth, maturity, and decline.

    • During the introduction stage, the product is launched and sales are low.

    • In the growth stage, sales increase rapidly as the product gains popularity.

    • During the maturity stage, sales level off and may even decline as the market becomes saturat...

  • Answered by AI

Interview Preparation Tips

Topics to prepare for MagicPin Associate Analyst interview:
  • SQL
  • Excel
  • Python
Interview preparation tips for other job seekers - Prepare for SQL queries and basic python functions.

I applied via Referral and was interviewed before Dec 2020. There were 3 interview rounds.

Interview Questionnaire 

5 Questions

  • Q1. Team handles counter handling
  • Q2. Sale proses
  • Q3. How do achieve your target
  • Q4. How can do achieve your monthly target
  • Q5. How can u handle your team

Interview Preparation Tips

Interview preparation tips for other job seekers - Good very good actually
Interview experience
4
Good
Difficulty level
Hard
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Jun 2023. There was 1 interview round.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Basic personal introduction of your
  • Q2. Main topics related questions
Interview experience
2
Poor
Difficulty level
-
Process Duration
-
Result
-
Round 1 - HR 

(2 Questions)

  • Q1. How to handle a big team
  • Q2. How to manage store if store manager on leave
  • Ans. 

    Delegate tasks, communicate with team, ensure smooth operations

    • Delegate tasks to capable team members to ensure all responsibilities are covered

    • Communicate clearly with team about expectations and any changes in procedures

    • Monitor store operations closely to address any issues promptly

    • Ensure inventory management is maintained to avoid stockouts or overstocking

    • Handle customer complaints or issues effectively to maintain

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - all gud
Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Arrays problems
  • Q2. Sliding window problem
  • Ans. 

    Sliding window problem involves finding a subarray of fixed size k with maximum sum.

    • Use a sliding window approach to iterate through the array and calculate the sum of each subarray of size k.

    • Keep track of the maximum sum encountered so far.

    • Move the window by one element at a time and update the sum accordingly.

    • Example: Given array [1, 3, -1, -3, 5, 3, 6, 7] and k = 3, the subarray with maximum sum is [5, 3, 6] with su

  • Answered by AI

Skills evaluated in this interview

Utsav Fashion Interview FAQs

How many rounds are there in Utsav Fashion Senior Data Analyst interview?
Utsav Fashion interview process usually has 4 rounds. The most common rounds in the Utsav Fashion interview process are Resume Shortlist, One-on-one Round and Technical.
What are the top questions asked in Utsav Fashion Senior Data Analyst interview?

Some of the top questions asked at the Utsav Fashion Senior Data Analyst interview -

  1. Google sheets , SQL, Tabl...read more
  2. General introduct...read more

Tell us how to improve this page.

Utsav Fashion Senior Data Analyst Interview Process

based on 1 interview

Interview experience

1
  
Bad
View more

Interview Questions from Similar Companies

Fabindia Interview Questions
4.0
 • 52 Interviews
MagicPin Interview Questions
2.7
 • 50 Interviews
Biba Apparels Interview Questions
3.6
 • 39 Interviews
Shaadi.com Interview Questions
3.3
 • 27 Interviews
Tokopedia Interview Questions
4.0
 • 25 Interviews
HealthKart Interview Questions
4.0
 • 25 Interviews
Meritto Interview Questions
3.6
 • 22 Interviews
Vedant Fashions Interview Questions
4.0
 • 19 Interviews
Droom Interview Questions
3.8
 • 19 Interviews
View all
Senior Executive
18 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Fashion Designer
7 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

SME
7 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Buyer
7 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Developer
5 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Utsav Fashion with

Peachmode

2.6
Compare

Biba Apparels

3.6
Compare

Fabindia

4.0
Compare

Vedant Fashions

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