Epsilon Interview Experience for Data Analyst Role

Epsilon is a global data, technology and services company that powers the marketing and advertising ecosystem. The company visited our campus on September 2025 to hire the students for 2 roles.

i) Product role ii) Analytics role

Hiring Process
The hiring process involves 3 rounds in total.

1. Online Assessment

The online assessment is conducted on the platform named Mettl. It included a wide range of topics from logical reasoning like Aptitude and Verbal to technical concepts covering Java, Python, JavaScript, AWS, Big Data and statistics. The duration of the assessment is 60 minutes for Analytics role and 90 minutes for Product role (1 coding question is bonus).

2. Technical Interviews — 2 (Virtual)

The company instructed all the shortlisted students to attend both the interviews.

Technical Round 1

The interview started with the self introduction. The interviewer mostly focussed on my internship and research paper publication and I have answered all the questions with confidence, admitting myself unaware when I was asked some new concepts. After that, the interviewer asked me to solve a simple DSA question — Two Sum in Python programming. At the end, the interviewer asked me a behavioral question and I answered it well. I received a positive feedback from the interviewer and hoped to make it through the HR Round.

Technical Round 2

Again, the interview began with the self introduction. Thereafter, the interviewer asked me the questions related to API (Application Programming Interface), Pandas concepts, SQL queries, a DSA question — Longest Substring Without Repeating Characters in Python, core CS concepts like OOPS, OS and DBMS. Here also, the interviewer asked me a behavioral question related to task management and priorities and I answered the question.

Interview Questions:

What is the difference between Authentication and Authorization?
How do you test whether an API is working or not? What are the different HTTP methods?
Given a Dataframe with some columns. Write the code using Pandas library to find the existence of a given column.
Given a list of unique numbers. What is the mode of the list? (Statistics)
There are 1000 visitors for a website. Only 50 customers made unique purchases on the website. What is the conversion rate of purchases on the website? (Analytics related)
Total number of orders placed by customer from each country. (SQL Query)
Department with highest average salary. (SQL Query — used CTEs)
Write a Python code to find factorial of a number using recursion.
Difference between each product sales and average product sales of each category. (SQL query. I mentioned the usage of Window functions).

In my both interviews, I mentioned about my capstone project which is related to NLP and I have answered some questions stating that I am learning the concepts. The interviewer asked me to wait for the HR call.

3. HR Round

After 2 hours, I got the call for the final round in the next 30 minutes. In the mean time, I explored about the company, its values, vision and mission and also prepared to answer the questions in STAR format.

The interview began with self introduction and motivation to learn data analytics. Also, I was questioned some questions related to my research. Then, I was asked to solve a DSA question which is kind of similar to this — Best Time to Buy and Sell Stock in Python. Thereafter, some scenario based questions related to AI are asked and I answered upto my knowledge. I received a positive feedback from interviewer and expecting for the results.

Final Outcome

I was selected for Analytics team after 45 days of the interview. I accepted the offer (6 months internship + Full-time based on performance).