16 questions · from 2 interviews
Epsilon interview questions
Every question candidates reported from their Epsilon interviews, most frequently asked first. Each links to the write-up it came from, so you can see the round and how it went.
Epsilon coding and DSA questions
- 01
Valid Palindrome
I was given a Palindrome based question, specifically the one found at https://leetcode.com/problems/valid-palindrome/description/. The question was the same as the LeetCode problem.
- 02
Container With Most Water
I was given a DSA whiteboarding question, specifically 'Container with Most Water' (https://leetcode.com/problems/container-with-most-water/). We discussed its Time Complexity (TC), Space Complexity (SC), and edge cases.
- 03
Two Sum
Solve the classic Two Sum problem: Given an array of integers nums and an integer target , return indices of the two numbers such that they add up to target .
Easy · From Epsilon Interview Experience for Data Analyst Role
- 04
Longest Substring Without Repeating Characters
Given a string s , find the length of the longest substring without repeating characters.
Medium · From Epsilon Interview Experience for Data Analyst Role
- 05
Python - Factorial using Recursion
Write a Python function to calculate the factorial of a given number using recursion.
Easy · From Epsilon Interview Experience for Data Analyst Role
- 06
Best Time to Buy and Sell Stock (similar)
A DSA question similar to "Best Time to Buy and Sell Stock". Given an array prices where prices[i] is the price of a given stock on the i -th day, find the maximum profit you can achieve.
Easy · From Epsilon Interview Experience for Data Analyst Role
Epsilon system design questions
- 01
Design E-commerce Platform with Inventory Management
I was asked to design an e-commerce platform with a special focus on inventory management. This implied concurrency handling. The discussion focused on APIs, Entities, and different operations required, with a core focus on inventory management and…
- 02
API Testing and HTTP Methods
Describe methods to test if an API is functional and list the various HTTP methods (e.g., GET, POST, PUT, DELETE).
Epsilon other questions
- 01
SQL Query for Product Filtering
I was asked to write an SQL query for filtering products by different criteria.
Medium · From Interview Process at Epsilon (Bangalore) Office
- 02
Difference between Authentication and Authorization
Explain the key distinctions between authentication and authorization in the context of security.
- 03
Pandas - Check Column Existence in DataFrame
Given a Pandas DataFrame and a column name, write Python code using the Pandas library to check if the column exists in the DataFrame.
Easy · From Epsilon Interview Experience for Data Analyst Role
- 04
Statistics - Mode of a List
Given a list of unique numbers, define what the mode of the list is.
Easy · From Epsilon Interview Experience for Data Analyst Role
- 05
Website Conversion Rate Calculation
Calculate the conversion rate for a website given 1000 visitors and 50 unique purchases.
Easy · From Epsilon Interview Experience for Data Analyst Role
- 06
SQL - Total Orders Per Customer Per Country
Write an SQL query to find the total number of orders placed by each customer, broken down by country.
Medium · From Epsilon Interview Experience for Data Analyst Role
- 07
SQL - Department with Highest Average Salary
Write an SQL query to find the department with the highest average salary. (The candidate mentioned using CTEs).
Medium · From Epsilon Interview Experience for Data Analyst Role
- 08
SQL - Product Sales vs. Category Average Sales (Window Functions)
Write an SQL query to calculate the difference between each product's sales and the average product sales within its respective category. (The candidate mentioned using Window functions).
Hard · From Epsilon Interview Experience for Data Analyst Role
Epsilon interview questions FAQ
What questions are asked in Epsilon interviews?
Candidates reported 16 distinct questions across 2 Epsilon interviews. 6 coding and DSA questions, 2 system design questions, 8 other questions.
How difficult are Epsilon interview questions?
Of the questions candidates rated, 55% were easy, 36% medium and 9% hard.