Subex Senior Data Analyst Interview Questions and Answers

Q1. SQL, excel, python and power Bi
Add your answer

Q1. Asked about scenario-based Small case study questions
Add your answer
Q2. Explain statistical concepts like Hypothesis testing, and type 1 and type 2 errors.
Ans. 
Hypothesis testing is a statistical method to test a claim about a population parameter. Type 1 error is rejecting a true null hypothesis, and type 2 error is failing to reject a false null hypothesis.
• Hypothesis testing involves formulating a null hypothesis and an alternative hypothesis.

• Type 1 error occurs when we reject a null hypothesis that is actually true.

• Type 2 error occurs when we fail to reject a null hypothes...read more
Answered by AI
Add your answer
Q3. Coding questions about Python and SQL
Add your answer
Q4. Questions about Machine learning algorithms, AUC ROC, Classification metrics
Add your answer

Q1. Explain about projects working on.
Add your answer
Q2. About a small scenario-based case study, how will you perform
Add your answer
Q3. How will you handle angry clients
Add your answer

Q1. Situation-based questions, small management scenario, what you will do
Add your answer
Q2. More questions about you? what you like and how the organization is good for you
Add your answer

Basic quants,lrdi and coding round

Q1. Basic questions on sql and python, past projects
Add your answer

Q1. Basic questions
Add your answer

SQL and quant, logical questions were asked.

Q1. 1. Tell me about your self 2. Resume based questions 3. Need to write basic SQL queries and also print same output using pandas
Add your answer

Q1. 1. Tell me about your self 2. Statistics questions 3. Guestimates 4. Why do you want to join company
Add your answer

It was a hybrid type of test it consisted of 3 sections
1. Aptitude
2. 2 DSA questions only the algorithm was to be written on the paper
3. 5 SQL queries (Intermediate level)

Q1. This was a one-to-one coding round medium-level dsa questions were asked.
Add your answer
Q2. Find the minimum element in a stack in O(1) complexity
Ans. 
To find the minimum element in a stack in O(1) complexity, we can use an auxiliary stack.
• Create an auxiliary stack to keep track of the minimum element.

• Push the first element of the main stack onto the auxiliary stack.

• For each subsequent element, compare it with the top element of the auxiliary stack.

• If it is smaller, push it onto the auxiliary stack.

• To get the minimum element, simply return the top element of the auxi...read more
Answered by AI
Add your answer

Q1. In this round knowledge regarding SQL queries was tested.
Add your answer
Q2. Fetch data without using subqueries instead use joins type of questions
Add your answer

Q1. In this round real world problem was described and I was asked to develop a data analytics solution for the same.
Add your answer

Basic test with Data Structures, algorithms, SQL questions

Q1. Questions about basic ML Algorithms
Add your answer

It consist of questions related to aptitude, basic computer science, statistics.

Q1. Listen to audio and speak what is said.
Add your answer

Q1. What is your strength and weakness.
Add your answer
Q2. What is join and it's types
Ans. 
Join is a SQL operation used to combine rows from two or more tables based on a related column between them.
• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• INNER JOIN returns rows when there is at least one match in both tables

• LEFT JOIN returns all rows from the left table and the matched rows from the right table

• RIGHT JOIN returns all rows from the right table and the matched rows from the left ...read more
Answered by AI
Add your answer