Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Amber Team. If you also belong to the team, you can get access from here

Amber Verified Tick

Compare button icon Compare button icon Compare

Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards

zig zag pattern zig zag pattern

Filter interviews by

Amber Junior Data Analyst Interview Questions and Answers

Updated 21 May 2024

Amber Junior Data Analyst Interview Experiences

1 interview found

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Referral and was interviewed in Apr 2024. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. The question was given based on join. Join two tables how will the no. of rows will differ with different joins.

Interview Preparation Tips

Topics to prepare for Amber Junior Data Analyst interview:
  • SQL
  • Excel

Interview questions from similar companies

I applied via Referral and was interviewed before May 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. How can you understand the supply of restaurant in a particular area of a city ?
  • Ans. 

    To understand the supply of restaurants in a particular area of a city, we can use various methods.

    • Collect data from online directories like Yelp, Zomato, etc.

    • Conduct surveys to gather information about the number of restaurants in the area.

    • Analyze the population density and demographics of the area to estimate the demand for restaurants.

    • Check the number of restaurant permits issued by the local government.

    • Use GIS mapp...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Understand any city's demographics for instance. Take most busy road and assume that 70% supply will be on food -tech (MArket Standard). Open Sw / Zo and see the supply available in that area in peak time. There can be more than one way to solve for these question

I applied via LinkedIn and was interviewed before May 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Questions were from SQL, Python, Statistics & Business Case Studies/Metrics in the form of 4-5 rounds.

Interview Preparation Tips

Interview preparation tips for other job seekers - So Key Takeaway is You have to be good with your Technical Knowledge (SQL Expert, Python, Overall Stats Knowledge) and That is not really enough. What differs a Business Analyst from other Developers/Statisticians etc. is Business acumen, Problem Solving Skills etc. To have a Business Knowledge and Understanding such that you find the problems/solutions/ Metrics and then solve them using the Technology.

I appeared for an interview in Nov 2020.

Interview Questionnaire 

1 Question

  • Q1. Mainly about sql, previous job role

I applied via Walk-in and was interviewed before Feb 2021. 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 - Aptitude Test 
Round 3 - HR 

(1 Question)

  • Q1. Tell me about yourself.

Interview Preparation Tips

Interview preparation tips for other job seekers - easy to crack they will ask qestions
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Internshala and was interviewed in Sep 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 - Aptitude Test 

Medium difficultty on pandas SQL

Round 3 - One-on-one 

(1 Question)

  • Q1. Coding interview python pandas medium difficulty
  • Ans. Solved it and had to discuss with manager
  • Answered by govind goel

Interview Preparation Tips

Topics to prepare for Paisabazaar.com Business Analyst interview:
  • Python
Interview preparation tips for other job seekers - Prepare pandas
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-

I applied via Job Portal

Round 1 - Coding Test 

SQL and Python data analysis questions

Round 2 - Technical 

(1 Question)

  • Q1. How do you match the data in different columns.
  • Ans. 

    Matching data in different columns involves comparing the values in the columns and identifying similarities or patterns.

    • Use string matching techniques like exact match, partial match, or fuzzy matching.

    • Apply data cleaning and preprocessing techniques to standardize the data before matching.

    • Utilize advanced algorithms like Levenshtein distance or Jaccard similarity for more complex matching.

    • Consider using database join...

  • Answered by AI
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
More than 8 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed in Apr 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 - One-on-one 

(1 Question)

  • Q1. DBMS? Questions from Graduation Project
Round 3 - Technical 

(1 Question)

  • Q1. SQL RDBMS Situational based questions
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

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

Round 1 - Technical 

(1 Question)

  • Q1. More about your role and insurance based questions
Round 2 - Technical 

(1 Question)

  • Q1. More about insurance based and brd, requirements gathering, sdlc
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Recruitment Consulltant and was interviewed in Jan 2024. There was 1 interview round.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Explain about your work as BA in the insurance project
  • Ans. 

    As a BA in the insurance project, I analyzed business requirements, facilitated communication between stakeholders, and ensured project goals were met.

    • Analyzed business requirements to identify gaps and opportunities for improvement

    • Facilitated communication between stakeholders including business users, IT teams, and management

    • Ensured project goals were met by tracking progress, identifying risks, and proposing solutio...

  • Answered by AI
  • Q2. Agile methodologies, SQL knowledge , Insurance domain knowledge

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare Insurance terms .

Amber Interview FAQs

How many rounds are there in Amber Junior Data Analyst interview?
Amber interview process usually has 1 rounds. The most common rounds in the Amber interview process are Technical.

Tell us how to improve this page.

Amber Junior Data Analyst Interview Process

based on 1 interview

Interview experience

3
  
Average
View more

Interview Questions from Similar Companies

Swiggy Interview Questions
3.8
 • 431 Interviews
Udaan Interview Questions
4.0
 • 334 Interviews
Meesho Interview Questions
3.7
 • 329 Interviews
Zepto Interview Questions
3.5
 • 226 Interviews
BlackBuck Interview Questions
3.8
 • 179 Interviews
Tata 1mg Interview Questions
3.6
 • 147 Interviews
Digit Insurance Interview Questions
3.9
 • 142 Interviews
Paisabazaar.com Interview Questions
3.4
 • 139 Interviews
Urban Company Interview Questions
3.4
 • 135 Interviews
Tracxn Interview Questions
3.2
 • 101 Interviews
View all
Sales Associate
12 salaries
unlock blur

₹3 L/yr - ₹4.8 L/yr

Operations Associate
10 salaries
unlock blur

₹3.6 L/yr - ₹8 L/yr

Senior Sales Manager
8 salaries
unlock blur

₹5.5 L/yr - ₹17.6 L/yr

Sales Manager
7 salaries
unlock blur

₹5 L/yr - ₹7.2 L/yr

Senior Associate Operations
7 salaries
unlock blur

₹4.4 L/yr - ₹9 L/yr

Explore more salaries
Compare Amber with

Udaan

3.9
Compare

Swiggy

3.8
Compare

BlackBuck

3.8
Compare

Ninjacart

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