Fractal Analytics Data Scientist Interview Questions and Answers for Experienced

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

Basic python sql questions, mcq based and coding questions.

Q1. They asked the projects which I am working on and had discussion on the same. Asked few statistical questions like boxplots and normal distribution. Also asked basic questions on advance SQL
Add your answer

Q1. Problem solving questions. Gave a case study to check presence of mind
Add your answer

Q1. Basic salary discussion
Add your answer

Q1. Explain Overfitting
Add your answer
Q2. More values in training set than test set
Add your answer

Python sql basic questions

Time and work, time and distance, percentages, data interpretation

Business case study - increase revenue for museum

Q1. Common machine learning algorithms, statistical concepts, projects mentioned in resume
Add your answer

Q1. Management round, behavioral questions were asked.
Add your answer
Q2. Why Mathcompany?, what if your current company offers more pay?
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