Tiger Analytics Data Engineer Interview Questions, Process, and Tips

Q1. Explain spark architecture
Ans. 
Spark architecture is a distributed computing framework that consists of a driver program, cluster manager, and worker nodes.
• Consists of a driver program that manages the execution of tasks

• Utilizes a cluster manager to allocate resources and schedule tasks

• Worker nodes execute the tasks and store data in memory or disk

• Supports fault tolerance through resilient distributed datasets (RDDs)
Answered by AI
Add your answer

Pure coding
They take one hour of coding interview they ask python sql pysprak
And spark sql

Q1. Spark python sql
Add your answer

2 Interview rounds for technical
1st Interview
Duration - 1 hr
Topics - Python DSA question,

Q1. SQL Joins, query , performance
Add your answer
Q2. Python scripting , pandas, pyspark
Add your answer

In the first round they ask some technical mcq and gave some coding questions in python and SQL.there were less aptitude questions.

Q1. Just asking simple string based questions and some difficult sql questions .it was 1hr section.
Add your answer
Q2. Groupby having, joins like inner outer left right
Add your answer
Q3. Most frequent word in a sentence ?
Ans. 
The most frequent word in a sentence can be found by counting the occurrence of each word and selecting the one with the highest count.
• Split the sentence into words using whitespace as delimiter

• Create a dictionary to store the count of each word

• Iterate through the words and update the count in the dictionary

• Find the word with the highest count in the dictionary
Answered by AI
Add your answer
Q4. Given some tables and extract the values between some values and fileter by some values
Add your answer

Medium level of coding questions were asked. Didn't need a lot of optimization to pass the test cases so it wasn't very hard.

Q1. Medium level coding questions were asked. Questions on programming concepts like OOPS, scope of variables were asked. Multiple questions were asked on probability. I was asked questions based on conditiona...read more
Add your answer

Q1. Spark Concepts, Performance Tuning
Add your answer

Q1. Discussion about CTC
Add your answer