Fractal Analytics Data Analyst Interview Questions and Answers

Q1. SQL, excel, python and power Bi
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

Aptitude test was very easy

Q1. Based on resume
Add your answer
Q2. Some simple hr questions
Add your answer

Q1. About family and their occupations
Add your answer
Q2. General questions
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