Upload Button Icon Add office photos

Filter interviews by

Clear (1)

FreshToHome Data Analyst Interview Questions and Answers

Updated 22 May 2024

FreshToHome Data Analyst Interview Experiences

2 interviews found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 22 May 2024

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

(2 Questions)

  • Q1. Basic questions on our previous work experince
  • Q2. What are the charters you have worked on
Round 2 - One-on-one 

(1 Question)

  • Q1. Some technical questions on excel and sql

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview is pretty easy

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 27 Nov 2023

Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Selected Selected

I applied via Instahyre and was interviewed before Nov 2022. There were 5 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Be truthful in your resume. It is very easy to catch false or lies during the interview by asking basic questions.
View all Resume tips
Round 2 - Coding Test 

Sql Coding round questions were asked

Round 3 - Technical 

(1 Question)

  • Q1. SQL coding round
Round 4 - Technical 

(1 Question)

  • Q1. Sql Coding round
Round 5 - HR 

(1 Question)

  • Q1. Basic questions salary expectations

Interview Preparation Tips

Interview preparation tips for other job seekers - Pls don’t join this company until it’s a last option

Data Analyst Interview Questions Asked at Other Companies

asked in Deloitte
Q1. Suppose there is a room in the office and X people enter room thr ... read more
asked in Wipro
Q2. Chocolate Distribution Problem You are given an array/list CHOCOL ... read more
asked in Wipro
Q3. Ninja and Substrings Problem Statement Ninja has to determine all ... read more
asked in Capgemini
Q4. Ninja and His Secret Information Encoding Problem Ninja, a new me ... read more
Q5. Sliding Window Maximum Problem Statement You are given an array/l ... read more

Interview questions from similar companies

I was interviewed in May 2021.

Round 1 - Telephonic Call 

Round duration - 20 minutes
Round difficulty - Easy

Received a sudden call from one of the interviewers (Came to know this later as first round interview was with the same person). No background disturbances, but they took me by surprise.

Round 2 - Video Call 

Round duration - 90 minutes
Round difficulty - Easy

Evening time
Virtual interview from home, so choose a calm place
Interviewer really helpful and was giving ample time to solve

Round 3 - Video Call 

Round duration - 90 minutes
Round difficulty - Easy

Afternoon

Round 4 - Video Call 

(1 Question)

Round duration - 60 minutes
Round difficulty - Easy

Evening

  • Q1. 

    Find the Third Greatest Element

    Given an array 'ARR' of 'N' distinct integers, determine the third largest element in the array.

    Input:

    The first line contains a single integer 'T' representing the numb...
  • Ans. 

    Find the third largest element in an array of distinct integers.

    • Sort the array in descending order

    • Return the element at index 2 as the third largest element

  • Answered by AI
Round 5 - HR 

Round duration - 90 Minutes
Round difficulty - Easy

Evening.
This round is with the co-founder as he acts as the hiring manager as well. 
This round is the most tricky one and you really need to be very careful in what you answer in this interview.

Interview Preparation Tips

Professional and academic backgroundI applied for the job as Data Analyst in BangaloreEligibility criteriaNo CriteriaJumbotail interview preparation:Topics to prepare for the interview - SQL - Basics and Advanced, Guesstimates, Puzzles, Problem Solving, Case Studies, Basic statistics knowledge, Company related informationsTime required to prepare for the interview - 1.5 monthsInterview preparation tips for other job seekers

Tip 1 : Extensively practice on SQL, SQL queries, extracting data, different types of joins as I had to solve and extract specified data from a dataset in front of the interviewer during the interview. Also, there is a telephonic pre-interview round that is focussed on SQL and Statistics basics. You need to clear that to move to the interviews.
Tip 2 : Practice lots of guesstimates, puzzles, problem solving and Case studies. Guesstimates may include questions like estimating the total area under warehouses in a specific region (I was asked something similar to this). 
Tip 3 : Extensively read about the company, JD and the core values of the company. They seem to focus extensively on these values and you need to prove that you fit within them.
Tip 4 : Be really cool, confident and you need to know even the tiniest details of your project work. Grinding on projects and tech skills are a part of all interview rounds.

Application resume tips for other job seekers

Tip 1 : Clean and Concise, only put things that you are very much comfortable in answering even to the tiniest details.
Tip 2 : Heavy focus on technical Skills. Mention the exact tech skills and project work/tech you used on those projects because they really pay attention to every nook and corner of your resume. Include you extra-curriculars as this is extremely important during the interview process. They will ask you to mention/describe situations where you showcased a particular skill (for hints related to these, refer to the core values section of their website.)

Final outcome of the interviewSelected

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

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

Round 1 - Coding Test 

SQL based questions wer asked on joins , rank function,

Interview Questionnaire 

2 Questions

  • Q1. Explain Normal distribution
  • Ans. 

    Normal distribution is a probability distribution that is symmetric and bell-shaped.

    • It is also known as Gaussian distribution.

    • It is characterized by mean and standard deviation.

    • Many natural phenomena follow normal distribution, such as height and weight of individuals.

    • 68% of the data falls within one standard deviation of the mean, 95% within two standard deviations, and 99.7% within three standard deviations.

    • It is wid...

  • Answered by AI
  • Q2. Types of jobs in sql
  • Ans. 

    SQL jobs include database administrator, data analyst, data scientist, business intelligence analyst, and software developer.

    • Database Administrator

    • Data Analyst

    • Data Scientist

    • Business Intelligence Analyst

    • Software Developer

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - prepare for MySql thoroughly

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Instahyre and was interviewed in May 2024. There were 2 interview rounds.

Round 1 - Coding Test 

Asked to write different SQL queries.
1. Moving average of lf previous 10 days
2. For a data which records in and out time of an employee. How many employees were present in the office at a given time
3. A/B testing vs pre-post testing

Round 2 - Case Study 

1. Had to come up with a method to give a score to each user based on FRM(frequency, recency, monetory)
2. Guesstimate: how many burgers does McD sells in a day

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

I applied via Referral and was interviewed before Aug 2022. 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 Resume tips
Round 2 - One-on-one 

(4 Questions)

  • Q1. How do you setup a Dark Store?
  • Ans. 

    Setting up a Dark Store involves converting a retail store into a fulfillment center for online orders.

    • Select a suitable location for the Dark Store, preferably in a centralized area with good access to transportation.

    • Optimize the layout of the store for efficient picking, packing, and shipping of orders.

    • Implement inventory management systems to track stock levels accurately and prevent stockouts.

    • Train staff on order f...

  • Answered by AI
  • Q2. How do joins work in the simplest manner?
  • Ans. 

    Joins combine data from two or more tables based on a related column.

    • Joins are used to retrieve data from multiple tables based on a related column

    • Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

    • Example: SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.id

  • Answered by AI
  • Q3. Write a basic query explaining the order of execution?
  • Ans. 

    The order of execution in a query determines the sequence in which operations are performed.

    • 1. The order of execution in a query typically follows the sequence: FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY.

    • 2. The FROM clause specifies the tables involved in the query.

    • 3. The WHERE clause filters the rows based on specified conditions.

    • 4. The GROUP BY clause groups the rows that have the same values into summary rows.

    • 5...

  • Answered by AI
  • Q4. Difference between Group By and Distinct?
  • Ans. 

    Group By is used to aggregate data based on a specific column, while Distinct is used to remove duplicate rows from a result set.

    • Group By is used with aggregate functions like COUNT, SUM, AVG, etc.

    • Distinct is used to retrieve unique values from a column or set of columns.

    • Group By can be used to group data based on multiple columns, while Distinct operates on individual columns only.

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Blinkit Data Analyst interview:
  • SQL
  • joins
  • window functions

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

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

Round 1 - One-on-one 

(2 Questions)

  • Q1. About previous experience situation based questions excel problem solving
  • Q2. Tell me about yourself difference between data quality and data validity

Interview Preparation Tips

Interview preparation tips for other job seekers - excel skills and data analysis basics

I applied via Naukri.com and was interviewed in Oct 2020. There was 1 interview round.

Interview Questionnaire 

3 Questions

  • Q1. Online Aptitude Test
  • Q2. Questions from my resume/previous employment
  • Q3. Scenario based question/Business case study

Interview Preparation Tips

Interview preparation tips for other job seekers - This interview was for Data analyst role at Reliance Retail. First , I had online aptitude test-50 questions 12 minutes. You need to at least solve 20 correctly. Post this I had online technical interview which lasted for about 40minutes. Initially the interviewer asked me about few accomplishments from my previous employment which had impacted business. I took him through few major projects that I worked and how these impacted business. I made sure to keep everything aligned to data analyst role. I spoke about what Data visualization tools (Domo/tableau) and languages(SQL) I had used previously to analyze data. He had follow up questions and I again made sure to explain clearly by highlighting my role. Next , there was one scenario based question asked.
Q: There are a couple of reliance stores that are bleeding(doing really bad) in one region. You have all the necessary data related to these stores. What would be those factors that you will consider first ? What will you do to ensure these stores do well.
Since I had retail background it was easier for me to understand the scenario based question. The interviewer wanted to understand how I would approach the problem.
Last, I had few questions to the interviewer based on the role.
On the same day I received call from HR saying that I have cleared the interview and offered the role.

I applied via Recruitment Consulltant and was interviewed in Jun 2022. 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 Resume tips
Round 2 - Technical 

(2 Questions)

  • Q1. Difference between where and having clause?.
  • Ans. 

    WHERE clause filters rows before grouping while HAVING clause filters groups after grouping.

    • WHERE clause is used to filter rows based on a condition before grouping them.

    • HAVING clause is used to filter groups based on a condition after grouping them.

    • WHERE clause is used with SELECT, UPDATE, DELETE statements while HAVING clause is used with GROUP BY clause.

    • WHERE clause is faster than HAVING clause as it filters rows be...

  • Answered by AI
  • Q2. Lead lag questions . Explain windows functions and stored procedure

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare SQL in detail. Prepare one machine learning project

Skills evaluated in this interview

Contribute & help others!
anonymous
You can choose to be anonymous

FreshToHome Interview FAQs

How many rounds are there in FreshToHome Data Analyst interview?
FreshToHome interview process usually has 3-4 rounds. The most common rounds in the FreshToHome interview process are Technical, One-on-one Round and Resume Shortlist.
How to prepare for FreshToHome Data Analyst 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 FreshToHome. The most common topics and skills that interviewers at FreshToHome expect are Data Analysis, Python, SQL, Data Analytics and Analytical.
What are the top questions asked in FreshToHome Data Analyst interview?

Some of the top questions asked at the FreshToHome Data Analyst interview -

  1. Some technical questions on excel and ...read more
  2. SQL coding ro...read more

Recently Viewed

INTERVIEWS

Hy-Vee

No Interviews

SALARIES

Online Instruments

SALARIES

Online Instruments

DESIGNATION

DESIGNATION

LIST OF COMPANIES

Online Instruments

Overview

INTERVIEWS

Osource Global

No Interviews

DESIGNATION

INTERVIEWS

IIGM

No Interviews

INTERVIEWS

Abk Imports

No Interviews

Tell us how to improve this page.

FreshToHome Data Analyst Interview Process

based on 3 interviews

Interview experience

2
  
Poor
View more
FreshToHome Data Analyst Salary
based on 6 salaries
₹4.7 L/yr - ₹17 L/yr
87% more than the average Data Analyst Salary in India
View more details
Hub Lead
19 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Customer Support Executive
19 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Store Manager
19 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Cluster Manager
17 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Customer Service Executive
16 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare FreshToHome with

Licious

3.7
Compare

ZappFresh.com

3.0
Compare

BigBasket

3.9
Compare

Blinkit

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