Epsilon Lead Data Analyst Interview Questions and Answers for Experienced

I was asked to write SQL queries for 3rd highest salary of the employee, some name filtering, group by tasks.
Python code to find the index of the maximum number without using numpy.

• Q1. Explain the Project undertaken during the research and follow-up questions
  Add Answer

• Q1. Write pandas query to separate the names as first and last name from the full name. Drop the duplicate columns and also the missing values. Write output for the...read more
  View Answers (1)

AWS and Python, basic Machine learning questions

Python, project description, AWS, in build package

Basic Machine learning data science

• Q1. Pandas basics and SQL joins nlp
  Add Answer

Time vs money, time time time

Dsa, python sql etl ssis

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

• Q1. SQL and python, time complexity
  Add 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 n...read more
  View Answers (2)
• Q3. SQL question Remove duplicate from a table tab1
  View Answers (2)

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 Answer