Aays Data Engineer Interview Questions and Answers

Q1. Sql - List top 3 youngest ages of employees dept wise
Ans. 
List top 3 youngest ages of employees dept wise using SQL.
• Use GROUP BY to group employees by department.

• Use ORDER BY to sort ages in ascending order.

• Use LIMIT to get top 3 youngest ages.

• Use MIN to get the youngest age in each department.
Answered by AI
View 3 more answers
Q2. Sql - List employees whose age is greater than average age of all employees
Ans. 
List employees whose age is greater than average age of all employees using SQL.
• Calculate the average age of all employees using AVG() function.

• Use WHERE clause to filter out employees whose age is greater than the average age.

• Join the employee table with the age table to get the age of each employee.

• Example: SELECT * FROM employees WHERE age > (SELECT AVG(age) FROM employees);
Answered by AI
View 1 more answer
Q3. Python - sum of digits till the result becomes single digit Ex: 479 - 20 - 2
Ans. 
Python program to find the sum of digits till the result becomes a single digit.
• Convert the number to a string and iterate through each digit.

• Add the digits and store the result.

• Repeat the process until the result becomes a single digit.

• Return the single digit result.
Answered by AI
View 7 more answers

Q1. Basic HR questions like why futurense, qualities that get you into futurense
Add your answer

Reasoning and aptitude questions were asked

Q1. Interview was around python programming and team fitment
Add your answer

Mettel Python SQL general python

Q1. Sql concepts some queries on window functions
Add your answer

Q1. They asked me questions on python and mysql , after that they had asked my project and told me to do some modification
Add your answer

Q1. Why should we hire you?
Add your answer
Q2. Where do you see yourself in 5 years?
Add your answer
Q3. What are your strengths and weaknesses?
Add your answer
Q4. Tell me about yourself.
Add your answer

2 python questions
2 SQL questions
5 MCQ questions

Q1. Basic SQL questions Acid property Difference between Varchar and char Join questions
Add your answer

Q1. Share details of your previous job.
Add your answer
Q2. Why are you looking for a change?
Add your answer
Q3. Tell me about yourself.
Add your answer

MCQ and Coding test

Q1. Basic SQL and Python Questions
Add your answer

Q1. What is your family background?
Add your answer
Q2. Tell me about yourself.
Add your answer

Hacker earth test- Python, SQL

Q1. Experience. python basic to intermediate and sql basic to intermediate
Add your answer