Fullstack Developer

Scenario: You are given a dataset containing information about various products sold on an e-
commerce platform. The dataset is in CSV format with the following columns:
• product_id
• product_name
• category
• price
• quantity_sold
• rating
• review_count (number of reviews)
Question: Write a Python script to perform the following tasks:

1. Database Connection
2. Data Upload
3. Login and Sign-Up System
4. Data Cleaning
5. Summary Report

Scenario: You are given a database for an e-commerce platform. The database includes the 
following tables: 
1. Customers 
o customer_id (INT, Primary Key) 
o customer_name (VARCHAR) 
o email (VARCHAR) 
o signup_date (DATE) 
2. Orders 
o order_id (INT, Primary Key) 
o customer_id (INT, Foreign Key referencing Customers) 
o order_date (DATE) 
o total_amount (DECIMAL) 
3. Order_Items 
o order_item_id (INT, Primary Key) 
o order_id (INT, Foreign Key referencing Orders) 
o product_id (INT) 
o quantity (INT) 
o price_per_unit (DECIMAL) 
4. Products 
o product_id (INT, Primary Key) 
o product_name (VARCHAR) 
o category (VARCHAR)

Question: Write a SQL query to find the top 5 customers who have spent the most money on the 
platform. The output should include the following columns: customer_id, customer_name, email, 
total_spent, and most_purchased_category (the category of products they spent the most money on).

Design a URL shortener service like Bitly or TinyURL. They asked me questions related to that, and it was easy.

How would you incorporate microservices into an e-commerce platform? (Learn)

• What distinguishes a RESTful API from a SOAP API? (Learn)
• What standard caching techniques are used in System Design? (Learn)
• What is the CAP theorem, and how does it apply to the design of systems? (Learn)
• How do Monorepos and Polyrepos differ from one another, and when would you use each?

Given an array of integer nums and an integer target, return indices of two numbers such that they add up to the target. You can only use each element once.

Input: nums = [2,7,11,15], target = 9
Output: [0,1]
Explanation: Because nums[0] + nums[1] = 2 + 7 = 9

• Tell me about yourself.
• How will you improve this organisation?
• Where do you see yourself in 5 years?

Compensation discussion