Fractal Analytics Data Engineer 1 Interview Questions and Answers

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

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

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

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