Skip to contentSkip to footer
  • Community
  • Jobs
  • Companies
  • Salaries
  • For employers
      Notifications

      Loading...

      Elevate your career

      Discover your earning potential, land dream jobs, and share work-life insights anonymously.

      employer cover photo
      employer logo
      employer logo

      Amber

      Is this your company?

      About
      Reviews
      Pay and benefits
      Jobs
      Interviews
      Interviews
      Related searches: Amber reviews | Amber jobs | Amber salaries | Amber benefits
      Amber interviewsAmber Data Analyst Intern interviewsAmber interview


      Glassdoor

      • About / Press
      • Awards
      • Blog
      • Research
      • Contact Us
      • Guides

      Employers

      • Free Employer Account
      • Employer Centre
      • Employers Blog

      Information

      • Help
      • Guidelines
      • Terms of Use
      • Privacy and Ad Choices
      • Do Not Sell Or Share My Information
      • Cookie Consent Tool
      • Security

      Work With Us

      • Advertisers
      • Careers
      Download the App

      • Browse by:
      • Companies
      • Jobs
      • Locations
      • Communities
      • Recent posts

      Copyright © 2008-2026. Glassdoor LLC. "Glassdoor," "Worklife Pro," "Bowls" and logo are proprietary trademarks of Glassdoor LLC.

      Followed companies

      Stay ahead in opportunities and insider tips by following your dream companies.

      Job searches

      Get personalised job recommendations and updates by starting your searches.

      Data Analyst Intern Interview

      8 May 2025
      Anonymous interview candidate
      Pune
      No offer
      Positive experience
      Average interview

      Application

      I applied through an employee referral. The process took 2 days. I interviewed at Amber (Pune) in May 2025

      Interview

      Team was helpful and were responding to all my doubts. Interview Process was also smooth and on time. The Requirement was Python, Google Sheets, SQL, tableau. But in my interview they only asked for SQL Questions, not vey difficult which i had to do on Google Sheets, ie, i don't have to execute it anywhere, i just had to write solutions for the questions. These are the following questions: 1) You have a table employees (emp_id, name, department_id, salary). Q: Write a query to find employees who earn more than the average salary of their department. 2) You have a table orders (order_id, order_status, amount). Q: Write a query to categorize orders as ‘High Value’ (>1000), ‘Medium’ (500–1000), and ‘Low’ (<500). 3)You have two tables: orders(order_id, customer_id, order_date, total_amount), customers(customer_id, name, country) Q: Write a query to find the total amount spent by each customer, along with their name and country. Then, show only the top 3 highest-spending customers overall (regardless of country). There were few more questions

      Interview questions [1]

      Question 1

      1) You have a table employees (emp_id, name, department_id, salary). Q: Write a query to find employees who earn more than the average salary of their department. 2) You have a table orders (order_id, order_status, amount). Q: Write a query to categorize orders as ‘High Value’ (>1000), ‘Medium’ (500–1000), and ‘Low’ (<500). 3)You have two tables: orders(order_id, customer_id, order_date, total_amount), customers(customer_id, name, country) Q: Write a query to find the total amount spent by each customer, along with their name and country. Then, show only the top 3 highest-spending customers overall (regardless of country). There were few more questions
      Answer question

      Top companies for "Compensation and Benefits" near you

      avatar
      AtkinsRéalis
      3.5★Compensation and benefits
      avatar
      Balfour Beatty
      3.6★Compensation and benefits
      avatar
      Kier Group
      4.2★Compensation and benefits
      avatar
      Saint-Gobain
      3.7★Compensation and benefits

      Bowls

      Get actionable career advice tailored to you by joining more bowls.

      Company Bowl sample

      Want the inside scoop on your own company?

      Check out your Company Bowl for anonymous work chats.