Tiger Analytics Interview Experience | Data Engineer Role

Last Updated : 23 Dec, 2024

I recently interviewed for the Data Engineer role at Tiger Analytics. Here’s a detailed breakdown of my interview experience:

Round 1: Online Test (90 Minutes)

The online test was divided into multiple sections:

Aptitude:

  • Included logical reasoning and quantitative analysis questions.

Computer Science Fundamentals:

  • Covered basic concepts of programming, data structures, and algorithms.

Coding Questions:

  • Easy Coding: A simple programming problem.
  • SQL Question: A query-based problem to test SQL skills.
  • Medium Coding: A moderately challenging problem to assess problem-solving skills.

Round 2: Technical Round 1 (45–50 Minutes)

This round focused on my technical knowledge and coding abilities.

Introduction:

  • "Tell me about yourself."

Coding Task:

  • Given the input {a,a,b,b,c,e,e,f,e,e,e}, produce the output {(a,2),(b,2),(c,1),(e,2),(f,1),(e,3)}.

SQL Question:

  • From a table (students, class, marks), find the maximum marks scored by students in each class.

Round 3: Technical Round 2 (45 Minutes)

This round involved more challenging technical problems to evaluate my problem-solving skills.

Introduction:

  • "Tell me about yourself."

Regex-Based Problem:

  • Write a regex solution to clean data with special characters in a column.
  • Input:
    id    name  
    1 abbb^&cc
    2 a&&ccc
  • Output:
    id    name  
    1 abbbcc
    2 accc

Character Frequency:

  • Find the frequency of each character in an array.

SQL Query:

  • Find the highest marks in each class.

Round 4: HR Round (15 Minutes)

This round evaluated my behavioral traits and overall fit for the role.

1. Introduction: "Tell me about yourself (within 30 seconds)."

2. Personal Insights:

  • "Tell me about yourself apart from academics."
  • Why Tiger Analytics and Data Engineering?

3. Relocation: "Are you willing to relocate?"

4. Final Questions: "Do you have any questions for us?"

Verdict: SELECTED

Key Takeaways

Preparation Tips:

  • Focus on core technical skills like SQL, coding, and problem-solving.

Communication:

  • Be clear and concise when explaining your thought process during technical rounds.

Stay Calm:

  • Maintain composure in HR rounds, focusing on your motivations and career aspirations.

This interview process was a great learning experience. I hope my journey inspires and helps others preparing for interviews at Tiger Analytics or similar companies. Best of luck to all aspirants!

Comment