Epsilon Senior Data Analyst Interview Questions and Answers

Q1. About SQL basics such as difference between delete and truncate, and some basic definitions.
Add your answer
Q2. About Python basics such as list, tuple and all.
Add your answer
Q3. Basic questions about Excel.
Add your answer

Q1. Salary Negotiation
Add your answer
Q2. About Company Work Culture
Add your answer

Q1. SQL Questions basic
Add your answer
Q2. GCP Question basic
Add your answer

Q1. Sql Question basic
Add your answer
Q2. GCP Question basic
Add your answer

Sql, python, Statistics mcq, Aptitude test. These were medium level questions.

Q1. SQL and python, time complexity
Add your answer
Q2. Make 2 lists a=[1,2,3,4] b=[9,8,5,5,2,3,3,4,1,1,10,9,2,3,4,10,10,9,7,7,8] Write a program to remove duplicate of b and keep only those elements of b which are not present in a, and the final list should ...read more
Ans. 
Remove duplicates from list b, keep elements not in list a, and sort in ascending order.
• Create a set from list b to remove duplicates

• Use list comprehension to keep elements not in list a

• Sort the final list in ascending order
Answered by AI
View 1 more answer
Q3. SQL question Remove duplicate from a table tab1
Ans. 
Use the DISTINCT keyword in SQL to remove duplicates from a table.
• Use the SELECT DISTINCT statement to retrieve unique rows from the table.

• Identify the columns that should be used to determine uniqueness.

• Example: SELECT DISTINCT column1, column2 FROM tab1;
Answered by AI
View 1 more answer

Given 2 case studies on data science and asked different possibilities to improve the models.

How to work with imbalance dataset.
How to remove null values, what is features engineering.
What is PCA
What is the working of XGBOOST

Q1. What was last project, tell me in detail. There were different technical questions related to my project
Add your answer

Q1. Tell me about Projects done during course
Add your answer

Q1. Given a query which had the application of aggregated finction subquery and sql functions
Add your answer
Q2. Another question on application of Having clause
Add your answer