Anko Associate Data Engineer Interview Questions and Answers

Q1. Difference between where and having
Ans. 
WHERE is used to filter rows before grouping, HAVING is used to filter groups after grouping.
• WHERE is used with SELECT statement to filter rows based on a condition

• HAVING is used with GROUP BY statement to filter groups based on a condition

• WHERE is applied before grouping, HAVING is applied after grouping

• Example: SELECT * FROM table WHERE column = 'value'

• Example: SELECT column, COUNT(*) FROM table GROUP BY column HAVIN
Answered by AI
Add your answer
Q2. View and materialised view
Add your answer

Retail data case study

Case study discussion

Q1. Retail situational based questions
Add your answer
Q2. Metrics used in retail business
Ans. 
Metrics used in retail business include sales, customer acquisition cost, customer lifetime value, inventory turnover, and gross margin.
• Sales: Total revenue generated from products or services sold

• Customer acquisition cost: Cost incurred to acquire a new customer

• Customer lifetime value: Predicted revenue a customer will generate over their lifetime

• Inventory turnover: Number of times inventory is sold and replaced in a ...read more
Answered by AI
Add your answer

Q1. Basic technical knowledge
Add your answer
Q2. Situational and managerial round questions
Add your answer

Q1. Basic salary negotiation
Add your answer
Q2. Situational base question
Add your answer

Q1. How many experience in working?
View 10 more answers
Q2. What is your qualification?
View 2 more answers
Q3. Where did you work earlier?
View 2 more answers
Q4. Why did you leave work in the first place?
View 1 more answer
Q5. Why do you need a job?
View 1 more answer

Q1. About pyspark questions
Add your answer
Q2. About etl tools
Add your answer

A/B Testing, data structures

Data entry, system operator,sales management, coding sarvese

Sales management
coding sarvese
data entry
System operator working

Q1. Which was the data entry meening
Add your answer
Q2. System operator
Add your answer

Sales management
Coding sarvese
Operator working sales management
Group discussion

Q1. 1. What Your study education 2. How do you work my complete
Add your answer

Round duration - 20 minutes
Round difficulty - Easy

Received a sudden call from one of the interviewers (Came to know this later as first round interview was with the same person). No background disturbances, but they took me by surprise.

Q1. General Questions
They asked about the internship experiences, technical knowledge(What I was comfortable in), SQL basic questions like order of query etc., some statistics related questions such as mean me...read more
Add your answer

Round duration - 90 minutes
Round difficulty - Easy

Evening time
Virtual interview from home, so choose a calm place
Interviewer really helpful and was giving ample time to solve

Q1. SQL Questions
Write a query to fetch the EmpFname from the EmployeeInfo table in upper case and use the ALIAS name as EmpName.
Write a query to create a new table which consists of data and structure copied ...read more
Add your answer

Round duration - 90 minutes
Round difficulty - Easy

Afternoon

Q1. Puzzles
Four people need to cross a rickety bridge at night. Unfortunately, they have only one torch and the bridge is too dangerous to cross without one. The bridge is only strong enough to support two peo...read more
Add your answer

Round duration - 60 minutes
Round difficulty - Easy

Evening

Q1. Third greatest element
Given an array/list 'ARR' of ‘N’ distinct integers, you are supposed to find the third largest element in the given array 'ARR'.
Input Format :
The first line conta...read more
Ans. Sorting Based Approach
The idea is to sort the array in non-decreasing order, and then return the third element from the back of the array.
 
The steps are as follows :
1. Sort the array in non-decreasing order.
2. Return the third element from the back of the array.
Space Complexity: O(logn)Explanation:
O(1)
 
We are not using any extra space. Thus, the overall space complexity will be O(1).
Time Complexity: O(nlogn)Explan...read more
Answered by CodingNinjas
View 2 more answers
Q2. DBMS Questions
What is an Index? Explain its different types.
What is Data Integrity?
Add your answer

Round duration - 90 Minutes
Round difficulty - Easy

Evening.
This round is with the co-founder as he acts as the hiring manager as well. 
This round is the most tricky one and you really need to be very careful in what you answer in this interview.

Q1. Basic HR Questions
1. Family background.
2. Why should I be hired.
3. Guesstimates (AGAIN!!!)
4. Puzzles (BASIC and INTERMEDIATE levels)
5. Expectations from the company.
6. When I can begin work.
7. Existing off...read more
Ans. 
Tip 1 : Be true, confident and calm
Tip 2 : Give smart and short answers rather than over-describing anything.
Answered by CodingNinjas
Add your answer

Mix of coding 2 Dsa program , 15 Dsa mcq

Q1. Big data related questions
Add your answer

Q1. Offer discussion
Add your answer