Fractal Analytics Consultant Data Analyst Interview Questions and Answers

First round was aptitude, communication test and a pseudo code question and all are elimination rounds if you passes all the rounds you will get an interview date....

Q1. Good Knowledge on dbms, sql
Add your answer
Q2. Python basic questions
Add your answer

Q1. Very liberal questions about yourself, relocation, etc..
Add your answer

Q1. Questions about SQL
Add your answer
Q2. Questions about python dataframes
Add your answer
Q3. Difference between random forest and decision tree
Ans. 
Random forest is an ensemble learning method using multiple decision trees to improve accuracy and reduce overfitting.
• Random forest uses multiple decision trees to make predictions.

• Decision tree is a single tree structure used for classification and regression.

• Random forest reduces overfitting by averaging the predictions of multiple trees.

• Decision tree can be prone to overfitting if not pruned properly.

• Random forest i...read more
Answered by AI
Add your answer

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

Q1. SQL, spark, hadoop, Linux,python
Add your answer

Q1. System design, real time data ingestion architecture and processing
Add your answer

Q1. Strength and weakness
Add your answer

Q1. Behaviour round questions were asked
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

Python coding and sql coding

Q1. List all the string which start with 'a'
Ans. 
List of strings starting with 'a'
• Use a loop to iterate through each string

• Check if each string starts with 'a'

• Add the string to the list if it starts with 'a'
Answered by AI
Add your answer
Q2. Find out max value from the given table
Ans. 
Use SQL query to find max value from a table
• Use SQL query SELECT MAX(column_name) FROM table_name;

• For example, SELECT MAX(salary) FROM employees;

• Ensure proper column name and table name are used in the query
Answered by AI
Add your answer