Tiger Analytics Data Engineer Interview Questions and Answers for Freshers

Q1. Basics of Power BI & Scernio Based Question SQL
Add your answer

Q1. Managerial Round
Add your answer
Q2. Project Details and Question around Project
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