Tiger Analytics Interview Questions, Process, and Tips for Freshers

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

Basic aptitude questions and coding questions.

Some basic data related questions, coding questions

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

Though I applied for Data Analyst position through campus Recruitment Program (Kolkata). It had MCQs and Coding test, but surprisingly the MCQs were about Java, OOPs concept and basic coding questions. Hardly any ML or Analytics related like Python, SQL or BI tools related questions. As if I appeared for SDE role, not sure why it happened, but later I came to know they hired none from our college.

This did not happen, as they didn't call anyone from our college.

Questions based on sql python (hard level)

Q1. Live coding round on python
Add your answer
Q2. Live coding questions on sql.
Add your answer

There are 20 Aptitude Question (time to solve these 20 question is 30 minutes). Then 10 MCQ Questions on Computer Science Fundamentals (time 10 minutes).

There are 5 question based on DSA 3 question of 20 marks and 2 questions of 50 marks. You need to any two question of 20 marks questions and one of 50 marks question. Total time you get to solve these question is 60 minutes.

Q1. Get Second highest element from an array (duplicates elements are allowed). Required T.C-->O(N) Single traversal. S.C--->O(1)
Ans. 
Get second highest element from an array of strings with O(N) time complexity and O(1) space complexity.
• Initialize two variables to store the highest and second highest elements.

• Traverse the array and update the variables accordingly.

• Return the second highest element.

• Handle edge cases like empty array or array with only one element.
Answered by AI
Add your answer
Q2. Sort nearly sortes array.
Ans. 
Sort nearly sorted array using min heap
• Create a min heap of size k+1

• Insert first k+1 elements into min heap

• For remaining elements, extract min and insert new element

• Extract all remaining elements from min heap

• Time complexity: O(nlogk)

• Example: ['apple', 'banana', 'cherry', 'date', 'elderberry']
Answered by AI
Add your answer
Q3. Coffiecent of x^7 in equation ? y=(x^101-1)(x^100+1)(x^99-1)...........................................(X^0+1)
Ans. 
Coffiecent of x^7 in a given equation
• Use the binomial theorem to expand the equation

• Identify the term with x^7

• The coefficient of x^7 is the coefficient of that term
Answered by AI
Add your answer
Q4. Some more probabilty and statistic questions exactly didn't remember.
Add your answer