Upload Button Icon Add office photos

Filter interviews by

FreshToHome Data Analyst Interview Questions and Answers for Experienced

Updated 22 May 2024

FreshToHome Data Analyst Interview Experiences for Experienced

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 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 for Experienced

asked in Samsung
Q1. How to Work with dynamic data, how to remove duplicate data or fi ... read more
asked in Morningstar
Q2. What are the elements which are present in all the financial stat ... read more
Q3. What is a Brownian motion? Properties of Brownian motion?
Q4. What is a Martingale? What are Markov Processes? Is Martingale a ... read more
asked in PhonePe
Q5. Different types of Joins in SQL and what are the outputs when you ... read more

Interview questions from similar companies

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

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.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Not Selected

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

Round 1 - Case Study 

Road daily revenue collection

Round 2 - Technical 

(2 Questions)

  • Q1. SQL question, Python coding
  • Q2. Highest salary in a table
Round 3 - HR 

(1 Question)

  • Q1. Salary Negotiation
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

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

Round 1 - Coding Test 

It was Python based basic questions only

Round 2 - HR 

(1 Question)

  • Q1. Basic question, strength, weakness

Interview Preparation Tips

Interview preparation tips for other job seekers - read your resume content
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. The difference between union and union all
  • Ans. 

    Union combines and removes duplicates, while Union All combines without removing duplicates.

    • Union combines two result sets and removes duplicates

    • Union All combines two result sets without removing duplicates

    • Union is slower than Union All as it involves removing duplicates

    • Union requires both result sets to have the same number of columns and compatible data types

  • Answered by AI
  • Q2. SQL query execution order

Skills evaluated in this interview

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

I applied via Company Website and was interviewed before Oct 2023. There were 2 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. SQL basic questions
Round 2 - Case Study 

Business Thinking Case studies

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

10 sql and 10 python questions

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
-

I applied via Job Portal

Round 1 - Technical 

(1 Question)

  • Q1. Round 1: This is an initial screening round. You will be tested on the foundation of multiple technologies. SQL (Majority), Python, Visualization skillset and some basic statistics. Round 2 : Advance t...

Interview Preparation Tips

Topics to prepare for Target Data Analyst interview:
  • SQL

FreshToHome Interview FAQs

How many rounds are there in FreshToHome Data Analyst interview for experienced candidates?
FreshToHome interview process for experienced candidates usually has 3-4 rounds. The most common rounds in the FreshToHome interview process for experienced candidates are Technical, One-on-one Round and Resume Shortlist.
How to prepare for FreshToHome Data Analyst interview for experienced candidates?
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 for experienced candidates?

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

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

Tell us how to improve this page.

FreshToHome Data Analyst Interview Process for Experienced

based on 2 interviews

Interview experience

2.5
  
Poor
View more
FreshToHome Data Analyst Salary
based on 6 salaries
₹4.7 L/yr - ₹17 L/yr
81% more than the average Data Analyst Salary in India
View more details
Customer Support Executive
20 salaries
unlock blur

₹1.7 L/yr - ₹3.8 L/yr

Hub Lead
19 salaries
unlock blur

₹2.2 L/yr - ₹4.2 L/yr

HUB Manager
18 salaries
unlock blur

₹2 L/yr - ₹5 L/yr

Cluster Manager
17 salaries
unlock blur

₹1.8 L/yr - ₹6.1 L/yr

Customer Service Executive
16 salaries
unlock blur

₹1.5 L/yr - ₹3 L/yr

Explore more salaries
Compare FreshToHome with

Reliance Retail

3.9
Compare

Walmart

3.7
Compare

DMart

3.9
Compare

Future Group

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