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!