Interview BD

Appearance

ShopUp ​

Founding year2017
Company Websitehttps://www.shopup.org
Career Websitehttps://www.shopup.org/career
Technologies Used

Introduction ​

ShopUp is a B2B e-commerce platform connecting small retailers to manufacturers and suppliers, digitizing supply chain.

Interview Stages: ​

These are the steps for the ShopUp Fast track launchpad

  1. Aptitude Test: Online aptitude test
  2. SQL Test: Online SQL test
  3. In Person Interviews: One technical and one behavioral in person interview
  4. Final on-site Test and Interview: Final on-site test short informal interview

Aptitude Test: ​

The first round was an online aptitude test consisting of 23 questions to be solved within 1 hour. The questions covered topics like pattern matching, profit and interest calculations, and age-related math problems (e.g., father and children age problems).

SQL Test: ​

There were three SQL problems to solve and record a video explaining the thought process, and submit via a Google Form. Two of the problems were very challenging—comparable to the "Hard" category on HackerRank.

In Person Interviews: ​

First Interview ​


  • During internships, you often face challenging tasks with no existing resources. Have you faced such a situation in your previous projects? How did you solve it?
  • Internship tasks can sometimes be boring or unglamorous. Have you encountered this before? How did you handle it?
  • Internships can present problems outside your knowledge area. Have you experienced this? How did you deal with it?

Second Interview ​


  • Tell us about yourself.
  • In many e-commerce sites, customers provide incorrect addresses. For example, they list Dinajpur when their actual delivery location is Rangpur. The parcel goes to Dinajpur, and then the customer says they are in Rangpur. You have 2 minutes to come up with both technical and non-technical solutions.
  • Would you run a business or software company in the future if given the opportunity?

Final on-site Test and Interview: ​

Exam (conducted while on a live Google Meet) ​


String Frequency Problem:

Given a string, find the character with the highest frequency and print both the character and its count.

  • Input: aaabccd
  • Output: a 3

Cluster Detection Problem:

Given a 2D axis with n circles, where each circle has a center (x, y) and a radius R, determine the number of clusters (groups of intersecting circles). Only a diagram was provided; no test cases.

Load Balancer Problem:

1000 requests hit a load balancer every second and are distributed to 5 servers. 10% of requests get delayed and must be requeued.

  • How many requests are handled per second?
  • How many requests are handled by each server?

There are two tables:

  • Table 1: id, name, supervisor_id, branch_id
  • Table 2: branch_id, branch_name

Task: Write a query to print each employee’s id, name, supervisor name, and branch name.

Interview ​


The final interview was mostly informal, discussing about the company, work culture, internship duration, and salary.

Contributor ​