Udaan.com Analytics Interview Questions & Experience Guide

Interview Preparation
,
1

Udaan.com Analytics Interview Questions & Experience Guide

2

Company Name: Udaan.com

Position: Analytics

Location: [Not specified]

Application Process: [Not specified]

Interview Rounds:

  • Round 1 - Technical Round:

  • Questions Asked:

    • How to sort ararat?

  • Your Approach: [Not specified]

  • Outcome: [Not specified]

Preparation Tips:

  • Focus on SQL, Analytics, Excel, Operations, customer support, Tableau, Business Intelligence, and Macros as these are the top skills recommended for the role.

Conclusion:

[Not specified]

3

Company Name: Udaan.com

Position: Analytics

Location: Not specified

Application Process: Applied via Naukri.com in July 2021.

Interview Rounds:

  • Round 1 - Technical:

  • Questions Asked: Probability, coding, and other technical questions.

  • Your Approach: Focused on solving problems methodically and explaining my thought process clearly.

  • Outcome: Passed to the next round.

  • Round 2 - HR:

  • Questions Asked: General HR questions about my background, experience, and fit for the role.

  • Your Approach: Answered honestly and highlighted my analytical skills and enthusiasm for the role.

  • Outcome: Successfully cleared the round.

  • Round 3 - Aptitude Test:

  • Questions Asked: Aptitude-based questions to assess problem-solving skills.

  • Your Approach: Practiced beforehand and managed time efficiently during the test.

  • Outcome: Cleared the aptitude round.

  • Round 4 - Interview:

  • Questions Asked: Further technical and situational questions.

  • Your Approach: Stayed calm, structured my answers, and provided examples where relevant.

  • Outcome: Final round cleared successfully.

Preparation Tips:

  • Keep your basics strong, especially in probability and coding.
  • Maintain good communication throughout the interview process.

Conclusion:
Overall, the interview process was thorough but fair. I felt well-prepared, but practicing more coding problems could have made me even more confident. For future candidates, focus on clarity in communication and a strong grasp of fundamentals.

4

Company Name: Udaan.com

Position: Analytics

Application Process: Applied through an online job portal.

Interview Rounds:

  • Round 1 - One-on-One Interview:
    • Questions Asked:
      • Tell me about a project you have worked on.
    • Your Approach:
      • I described a recent analytics project I had completed, focusing on the problem statement, methodology, tools used, and the impact of the project. I emphasized my role and the skills I applied.
    • Outcome:
      • The interviewer seemed satisfied with my explanation and asked follow-up questions about the tools and techniques I used.

Preparation Tips:

  • Brush up on your project details, including the problem, approach, and outcomes.
  • Be ready to explain the tools and technologies you used in your projects.
  • Practice articulating your thoughts clearly and concisely.

Conclusion:
The interview was straightforward, and I felt prepared to discuss my project. However, I could have been more detailed about the challenges faced and how I overcame them. For future candidates, I recommend thoroughly reviewing your projects and being ready to dive deep into any aspect of them.

5

Company Name: Udaan.com

Position: Analytics

Application Process: The application process involved a combination of online application and possibly campus placement (details not specified).

Interview Rounds:

  • Round 1 - Technical Screening:

    • Questions Asked:
      • Basic Excel and SQL knowledge.
      • Quantitative screening questions.
    • Your Approach: I brushed up on Excel functions and SQL queries beforehand. For the quant screening, I relied on logical reasoning and basic math skills.
    • Outcome: Cleared the round successfully.

  • Round 2 - Work Experience & Introduction:

    • Questions Asked:
      • Basic introduction about myself.
      • Questions about my work experience.
    • Your Approach: I kept my introduction concise and focused on relevant experiences. For work-related questions, I highlighted projects and skills that aligned with the role.
    • Outcome: Advanced to the next stage.

Preparation Tips:

  • Brush up on Excel and SQL basics.
  • Practice logical and quantitative questions.
  • Be prepared to discuss your work experience clearly and concisely.

Conclusion:
The interview process was straightforward, with a focus on technical skills and work experience. Preparing well for Excel, SQL, and logical questions helped me perform confidently. For future candidates, I’d recommend focusing on these areas and ensuring you can articulate your work experience effectively.

6

Company Name: Udaan.com

Position: Analytics

Application Process: The application process began with a resume shortlist round, followed by technical interviews.

Interview Rounds:

  • Round 1 - Resume Shortlist:

    • Details: The first round was a resume screening. The key here was to ensure the resume was concise and impactful, as recruiters typically spend only a few seconds reviewing it.
    • Outcome: Successfully cleared this round.

  • Round 2 - Technical Round:

    • Questions Asked:
      1. SQL HackerRank test with 10 questions to be completed in 1 hour.
      2. Questions focused on SQL, with some additional topics like Python and Excel.
    • Your Approach: Prepared thoroughly for SQL, especially advanced functions like joins, lag, lead, and row_number.
    • Outcome: Performed well in this round.

Preparation Tips:

  • Focus on mastering SQL, particularly advanced functions such as joins, lag, lead, and row_number.
  • Practice coding challenges on platforms like HackerRank to improve speed and accuracy.
  • Brush up on Python and Excel basics as they might be part of the technical round.

Conclusion:
The interview process was smooth, and the key to success was a strong grasp of SQL. For future candidates, I’d recommend dedicating ample time to SQL practice and ensuring your resume is polished and to the point.

7

Company Name: Udaan.com

Position: Analytics

Location: Not specified

Application Process: Applied via the company website in May 2022.

Interview Rounds:

  • Round 1 - Resume Shortlist:

  • Questions Asked: Resume screening to assess qualifications and experience.

  • Your Approach: Ensured my resume was concise and highlighted relevant skills for the role.

  • Outcome: Successfully shortlisted for the next round.

  • Round 2 - Assignment Round:

  • Questions Asked: Case study on how to improve app traffic.

  • Your Approach: Analyzed the problem, identified key areas for improvement, and proposed actionable solutions.

  • Outcome: Cleared the assignment round.

  • Round 3 - Technical Round:

  • Questions Asked:

    1. SQL and Advanced Excel.
    2. Business Intelligence tools.

  • Your Approach: Demonstrated proficiency in SQL and Excel, and discussed my experience with BI tools.

  • Outcome: Successfully cleared the round.

Preparation Tips:

  • Focus on understanding the B2B model as it is central to Udaan’s operations.
  • Brush up on SQL, Advanced Excel, and Business Intelligence tools.
  • Practice case studies related to app traffic and user engagement.

Conclusion:
The interview process was structured and focused on both technical and analytical skills. Preparing for the B2B model and case studies was crucial. Overall, it was a great learning experience, and I would advise future candidates to thoroughly understand the company’s business model and practice relevant technical skills.

8

Company Name: Udaan.com

Position: Analytics

Location: [Not specified]

Application Process: Applied via the company website in March 2024.

Interview Rounds:

  • Round 1 - Aptitude Test:
    • Questions Asked: 1-hour test covering maths, reasoning, and English.
    • Your Approach: Focused on solving problems efficiently within the time limit.
    • Outcome: [Not specified]

Preparation Tips:

  • Prepare thoroughly for aptitude tests, especially in maths, reasoning, and English.
  • Practice time management to ensure all sections are completed within the allotted time.

Conclusion:
The interview process was straightforward, with a focus on aptitude testing. Preparing well for such tests is crucial to perform effectively.

9

Company Name: Udaan.com

Position: Analytics

Application Process: I applied via LinkedIn and was interviewed before March 2023.

Interview Rounds:

  • Round 1 - Technical Round:

  • Questions Asked:

    • Basic SQL question.

  • Your Approach: I tackled the SQL question by breaking it down into smaller parts and ensuring I understood the logic before writing the query.

  • Outcome: Passed this round.

  • Round 2 - Case Study Round:

  • Questions Asked:

    • How to extend Amazon cloud services?

  • Your Approach: I analyzed the scalability and integration aspects of Amazon cloud services, focusing on cost-efficiency and performance.

  • Outcome: Advanced to the next round.

  • Round 3 - One-on-one Round:

  • Questions Asked:

    • Discussion with the manager about the role and my fit for it.

  • Your Approach: I highlighted my analytical skills and experience, aligning them with the company’s needs.

  • Outcome: Successful interview.

Preparation Tips:

  • Brush up on SQL basics and practice case studies related to cloud services and scalability.
  • Be ready to discuss your analytical approach and problem-solving skills in detail.

Conclusion:
The interview process was smooth, and the questions were aligned with the role. I could have prepared more case studies beforehand, but overall, it was a great learning experience. For future candidates, focus on SQL and case studies, and be confident in discussing your analytical skills!

10

Company Name: Udaan.com

Position: Analytics

Application Process: The application process details were not provided, but it likely involved an online application or campus placement.

Interview Rounds:

  • Round 1 - One-on-one Round:
    • Questions Asked:
      1. Guesstimators and puzzle-related questions.
      2. Additional puzzle and guesstimators questions.
    • Your Approach: The candidate was asked to solve guesstimators and puzzles, which likely tested their analytical and problem-solving skills. The approach involved logical reasoning and structured thinking to arrive at solutions.
    • Outcome: The result of this round was not specified.

Top Skills Recommended for Udaan Analyst Interview:

  • SQL
  • Analytics
  • Financial Analysis
  • Financial Planning
  • E-commerce
  • Financial Modelling
  • Process Excellence

Preparation Tips:

  • Focus on guesstimators and puzzles to improve problem-solving skills.
  • Brush up on SQL and financial analysis concepts.
  • Practice logical reasoning and structured thinking for case studies.

Conclusion:
The interview focused heavily on analytical and problem-solving skills, particularly through guesstimators and puzzles. Candidates should prepare thoroughly for these types of questions and ensure they have a strong foundation in SQL and financial analysis.