Celebal Technologies Associate Data Engineer Interview Questions and Answers

First round is basically on python multiple choice questions and then it was asking 6 python easy-moderate question(Don't worry it's not like DSA) then 6 SQL questions which is kind of midium level questions.

Q1. Interviewer asked more about pandas, numpy and according to my resume. 1.what's Linear Regression (As on my resume mentioned that algorithm.)?? I can't remember such pandas and numpy questions but I can sa...read more
Add your answer
Q2. How is an empty class created in python.
Ans. 
An empty class can be created in Python using the 'pass' keyword.
• Use the 'class' keyword to define a class.

• Add the class name and a colon after the 'class' keyword.

• Use the 'pass' keyword to indicate an empty class body.
Answered by AI
Add your answer

2 SQL questions with some dsa and python mqs.

Q1. Mostly asked SQL questions.
Add your answer
Q2. Joins, normalisation, aggregate functions etc
Add your answer
Q3. SQL queries to find duplicate values
Ans. 
Use SQL queries with GROUP BY and HAVING clause to find duplicate values in a table.
• Use GROUP BY clause to group the records based on the columns you want to check for duplicates.

• Use HAVING clause to filter out the groups that have more than one record, indicating duplicates.

• Example: SELECT column_name, COUNT(*) FROM table_name GROUP BY column_name HAVING COUNT(*) > 1;
Answered by AI
Add your answer
Q4. SQL queries to find second highest salary
Ans. 
Use SQL query with subquery to find second highest salary
• Use ORDER BY clause to sort salaries in descending order

• Use LIMIT clause to get the second row after skipping the first row

• Use a subquery to avoid duplicates if multiple employees have the same highest salary
Answered by AI
Add your answer

Q1. Generic behavioral questions
Add your answer