Fractal Analytics AWS Data Engineer Interview Questions and Answers

It was having basic aptitude questions

Q1. They asked basic english question
Add your answer
Q2. And alos topic was provided so we had to speak on it.
Add your answer

Q1. SQL syntax and difference between having and where clause
Ans. 
HAVING clause is used with GROUP BY to filter grouped rows, WHERE clause is used to filter individual rows.
• HAVING clause is used with GROUP BY to filter grouped rows based on aggregate functions

• WHERE clause is used to filter individual rows based on conditions

• HAVING clause is applied after GROUP BY, WHERE clause is applied before GROUP BY

• HAVING clause can only be used with SELECT statement that contains a GROUP BY clau
Answered by AI
Add your answer
Q2. Difference between array and linkedlist,stack and queue
Ans. 
Arrays store elements in contiguous memory, while linked lists use nodes with pointers. Stacks follow LIFO, queues follow FIFO.
• Arrays store elements in contiguous memory locations, allowing for constant time access to elements using indices.

• Linked lists use nodes with pointers to the next node, allowing for dynamic memory allocation and insertion/deletion at any position.

• Stacks follow Last In First Out (LIFO) principle...read more
Answered by AI
Add your answer

Q1. Tell me about your self
Ans. 
I am a data science enthusiast with a strong background in statistics and machine learning.
• Completed coursework in data analysis, statistical modeling, and predictive analytics

• Proficient in programming languages such as Python, R, and SQL

• Experience with data visualization tools like Tableau and Power BI

• Worked on projects involving regression analysis, clustering, and classification algorithms
Answered by AI
Add your answer
Q2. Why you want to join this role
Ans. 
I am passionate about using data to solve complex problems and make informed decisions.
• I have a strong background in statistics, mathematics, and programming, which are essential skills for a data science role.

• I am excited about the opportunity to work with real-world data and apply machine learning algorithms to extract valuable insights.

• I am eager to learn from experienced data scientists and contribute to innovative
Answered by AI
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

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

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