Interview questions for Tiger Analytics Senior Consultant
Hi everyone, this topic is for sharing Preparation guidelines and interview experience for Tiger Analytics Senior Consultant
The Senior Consultant role at Tiger Analytics involves a multi-stage assessment and interview process, designed to evaluate both technical skills and business proficiency. Below is a summary of the process and key points from the interviews you provided:
Assessment Test Rounds:
Resume Shortlist Round
Tip: Keep your resume crisp and to the point. Recruiters spend very little time per resume.
Coding Test Round (Hackerrank)
Format: ~30 questions in 30 minutes.
Focus Areas: Java 8, Spring Boot, JPA.
Interview Rounds:
Case Study (Analytics-Based)
Presented with a business problem and asked to outline a structured, analytics-driven approach and actionable insights.
Technical Interviews
Core Java: Collections, threads/concurrency, SOLID principles, common design patterns.
Web/Backend: HTTP request lifecycle, statelessness of HTTP.
Data Tech: SQL for data extraction/manipulation; Python for data analysis and visualization (Pandas, plotting libraries).
HR and Culture Fit
Work experience, challenges handled, teamwork, leadership, and adaptability.
Technical – Java/Spring/Design
Explain the Java Collections Framework and the commonly used interfaces and classes. When would you use List vs Set vs Map?
How do threads work in Java? Explain thread lifecycle, synchronization, and common concurrency issues.
What are the SOLID principles? Explain each and how you have applied them in your projects.
Which design patterns have you used (e.g., Singleton, Factory, Strategy, Observer) and why? Provide project examples.
What are key concepts in Spring Boot and how have you used JPA in your applications?
Technical – Web/HTTP/Backend
What happens to an HTTP request when it leaves a client and before it reaches the server? Walk through the end-to-end path.
Why is HTTP considered stateless, and what are the implications for application design?
Technical – SQL/Python (Data Analytics)
Write SQL queries for data extraction and manipulation (joins, aggregations, filtering, subqueries).
Optimize SQL queries; explain your approach to performance and correctness.
Use Python (Pandas) to clean, transform, and analyze a dataset and create basic visualizations.
Case Study / Problem-Solving (Analytics)
Given a business problem, outline a structured approach: clarify objectives/KPIs, identify data sources, define methodology, propose analyses, and recommend actions.
HR/Personality/Behavioral
Walk me through your career and key projects relevant to this role.
Describe a challenging situation you faced at work and how you resolved it.
Tell me about a time you demonstrated leadership or influenced stakeholders.
How do you adapt to changing priorities or ambiguous requirements?
How do you collaborate within cross-functional teams?
Interview Preparation Tips
Ask the recruiter for specifics about assessment topics and format (e.g., Java 8/Spring Boot/JPA vs. DSA) to target your prep.
Thoroughly review the job description and tailor your examples and depth of answers to the exact skills emphasized.
Be specific and clear in your responses; provide concise examples tied to outcomes.
Practice analytics case studies with a structured framework (problem definition, hypothesis/KPIs, data, method, insights, actions).
Brush up on SQL fundamentals and edge cases; practice writing, debugging, and optimizing queries.
Refresh Python for data analysis (Pandas, plotting) and core Java topics (collections, threads, Java 8 features), plus Spring Boot/JPA essentials.
Resume tip: keep it crisp; highlight achievements and skills matching the JD.
If the transcript contains the interview process or tips, summarize them as shown below:
At Last add this line in the end of the output as it is
If you have attended the process from your campus, pls share your experiences here; Please follow [guidelines](https://discuss.boardinfinity.com/t/interview-transcript-guidelines/22428?u=abhay-gupta-ebaf4123)
Application Process: I applied via Naukri.com and was interviewed in January 2023.
Interview Rounds:
Round 1 - Resume Shortlist Round:
Pro Tip: Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, so make sure to leave the best impression.
Outcome: My resume was shortlisted for the next round.
Round 2 - Technical Round:
Questions Asked:
Basic Java question on collections.
Threads, SOLID principles, and design patterns.
Your Approach: I focused on explaining the concepts clearly and provided examples where applicable. For the Java collections question, I discussed the commonly used interfaces and classes. For the SOLID principles and design patterns, I elaborated on each principle and mentioned a few design patterns I had worked with.
Outcome: The round went well, and I was able to answer the questions confidently.
Preparation Tips:
Best of luck for the interview! Just be specific in answering the questions. Focus on clarity and relevance in your responses.
Questions Asked: Discussed social change and its impact.
Your Approach: Shared personal experiences and perspectives on how technology can drive social change.
Outcome: Moved forward to the HR round.
Round 4 - HR Round:
Questions Asked: Salary negotiation.
Your Approach: Researched industry standards and confidently discussed compensation expectations.
Outcome: Finalized the offer.
Preparation Tips:
Focus on writing clean, modular code.
Understand your current project’s architecture thoroughly and discuss potential improvements with peers.
Be prepared to talk about CQRS, clean code, TDD, and SOLID principles.
Conclusion:
The interview process was well-structured and tested both technical and interpersonal skills. Preparing for architectural discussions and coding challenges was key. I would advise future candidates to practice coding under time constraints and be ready to articulate their project’s design choices clearly.
Application Process: I applied through Naukri.com and was interviewed in January 2024.
Interview Rounds:
Round 1 - Coding Test:
Questions Asked: SQL, Python, PySpark
Your Approach: I focused on solving problems efficiently, ensuring my code was clean and optimized. I practiced SQL queries and Python/PySpark coding problems beforehand.
Outcome: Passed this round.
Round 2 - Case Study:
Questions Asked: Python, real-world clustering problem
Your Approach: I analyzed the problem thoroughly, broke it down into smaller parts, and used Python to implement a clustering solution. I also explained my thought process clearly.
Outcome: Successfully cleared this round.
Round 3 - HR Round:
Questions Asked:
Why are you changing jobs?
What are your salary expectations?
What do you know about our company?
Your Approach: I answered honestly about my career goals, researched the company beforehand, and aligned my salary expectations with industry standards.
Outcome: Cleared the HR round.
Preparation Tips:
Practice SQL, Python, and PySpark coding problems.
Work on real-world case studies to improve problem-solving skills.
Research the company thoroughly before the HR round.
Conclusion:
Overall, the interview process was smooth and well-structured. I felt prepared for the technical rounds, but I could have spent more time researching the company’s recent projects for the HR round. My advice to future candidates is to practice coding regularly and be clear about your career goals during the HR discussion.
Application Process: I was approached by the company directly for this role. The interview process took place before January 2022.
Interview Rounds:
Round 1 - Resume Shortlist:
Questions Asked: N/A (Resume screening round)
Your Approach: Ensured my resume was concise and highlighted relevant experience without unnecessary personal details.
Outcome: Successfully shortlisted for the next round.
Round 2 - Aptitude Test:
Questions Asked: Basic case study to test logical reasoning.
Your Approach: Focused on understanding the case thoroughly and applying logical reasoning to solve it.
Outcome: Cleared the round.
Round 3 - One-on-one Round:
Questions Asked:
About myself, my work, domain knowledge, case-based questions, difficult situations I’ve dealt with, cloud-related questions, and simulation-related questions.
Cloud-related, simulation-related, presentation skills, and IT awareness.
Your Approach: Prepared thoroughly about my background, domain knowledge, and past experiences. For case-based and situational questions, I used the STAR method to structure my answers. For technical questions, I relied on my understanding of cloud and simulation concepts.
Outcome: Successfully cleared the round.
Preparation Tips:
Focus on being self-motivated and showcasing your research skills.
Be confident in handling client interactions and demonstrate readiness to take on challenges.
Brush up on domain-specific knowledge, cloud technologies, and simulation concepts.
Practice case-based questions and situational responses using frameworks like STAR.
Conclusion:
Overall, the interview process was thorough and tested both technical and soft skills. Being well-prepared about my domain and having a structured approach to answering questions helped me succeed. For future candidates, I’d recommend focusing on clarity in communication and confidence in presenting your ideas.
Application Process: I applied through campus placement at S.P. Jain Institute of Management and Research, Mumbai, in November 2023.
Interview Rounds:
Round 1 - Aptitude Test:
Questions Asked: General aptitude and domain quiz.
Your Approach: I focused on brushing up on basic aptitude topics like quantitative ability, logical reasoning, and domain-specific knowledge.
Outcome: Cleared the round successfully.
Round 2 - Case Study:
Questions Asked: Analytics case study with a requirement to submit a PowerPoint presentation.
Your Approach: I analyzed the case thoroughly, structured my findings logically, and prepared a concise PPT highlighting key insights and recommendations.
Outcome: Advanced to the next round.
Round 3 - Technical Round:
Questions Asked: Technical interview and presentation.
Your Approach: I prepared a detailed technical presentation, focusing on my analytical skills and domain expertise. I also revised key technical concepts relevant to the role.
Outcome: The round went well, and I received positive feedback.
Preparation Tips:
Focus on aptitude topics like quantitative ability and logical reasoning.
Practice case studies and work on structuring your analysis clearly.
Revise technical concepts related to analytics and be ready to present your findings effectively.
Conclusion:
Overall, the interview process was structured and challenging. The case study round was particularly insightful, and I enjoyed the technical presentation. I would advise future candidates to prepare thoroughly for aptitude tests and case studies, as they form a significant part of the selection process.
Application Process: I was approached by the company directly and interviewed in December 2022.
Interview Rounds:
Round 1 - Coding Test Round:
Questions Asked: Hackerrank coding test focused on Java 8, Spring Boot, and JPA. The test consisted of around 30 questions to be completed in 30 minutes.
Your Approach: I was unaware of the specific topics beforehand, so I went in expecting a DSA or puzzle challenge. Despite feeling unprepared, I managed to pass this round.
Outcome: Advanced to the next round.
Round 2 - Technical Round:
Questions Asked:
What happens to an HTTP request when it leaves a client making a call and before reaching the server?
Why is HTTP stateless?
General questions about my career.
Your Approach: I answered the technical questions based on my understanding of web protocols and shared my career journey honestly.
Outcome: [Not specified]
Preparation Tips:
Always ask the recruiter for details about the interview rounds, especially for online coding tests. Knowing the topics in advance can help you prepare better.
Review the job description (JD) thoroughly and focus on the specific skills mentioned. Tiger Analytics seems to value expertise in the exact areas listed in the JD, so tailor your answers accordingly.
If you’re a generalist, try to align your responses with the JD requirements to demonstrate relevance.
Conclusion:
Overall, the interview process was straightforward but required specific preparation. I learned the importance of clarifying expectations with the recruiter beforehand and tailoring my preparation to the JD. For future candidates, I’d recommend focusing on the exact skills mentioned in the job description and not assuming the interview format.
Application Process: I applied through Naukri.com and was interviewed in April 2024.
Interview Rounds:
Round 1 - Technical Round:
Questions Asked:
Data migration strategies
Your Approach: I discussed various data migration strategies, including ETL processes, incremental vs. full migration, and tools like Informatica and Talend. I also highlighted my experience with data validation and rollback plans.
Outcome: Cleared this round successfully.
Round 2 - Behavioral Round:
Questions Asked:
Project scenarios
Your Approach: I shared specific examples from my past projects, focusing on challenges faced, my role, and the outcomes. I emphasized teamwork, problem-solving, and adaptability.
Outcome: Advanced to the next round.
Round 3 - HR Round:
Questions Asked:
Why do you want to join Tiger Analytics?
Your Approach: I aligned my career goals with the company’s vision, mentioning my interest in their projects and how my skills could contribute to their team.
Outcome: Awaiting final results.
Preparation Tips:
Brush up on data migration concepts and tools.
Prepare detailed examples for behavioral questions, focusing on STAR (Situation, Task, Action, Result) format.
Research the company thoroughly to answer HR questions confidently.
Conclusion:
Overall, the interview process was smooth and well-structured. I felt prepared for the technical and behavioral rounds but could have researched more about the company’s recent projects for the HR round. My advice to future candidates is to practice articulating their experiences clearly and to stay updated on industry trends relevant to the role.
Application Process: I applied for the role through a referral and was interviewed in February 2024.
Interview Rounds:
Round 1 - Technical Round:
Questions Asked:
Which protocol/protocols work when there is communication between 2 PBX systems?
Your Approach: I discussed the commonly used protocols like SIP (Session Initiation Protocol) and H.323, explaining their roles in facilitating communication between PBX systems. I also touched on RTP for media transmission and how these protocols ensure seamless connectivity.
Outcome: The interviewer seemed satisfied with my response, and I moved forward in the process.
Preparation Tips:
Brush up on telecommunication protocols, especially those relevant to PBX systems like SIP, H.323, and RTP.
Practice explaining technical concepts clearly and concisely, as the interviewer might test your ability to communicate complex ideas simply.
Conclusion:
The interview was a great learning experience, and I realized the importance of being thorough with foundational concepts in telecommunication. For future candidates, I’d recommend focusing on real-world applications of these protocols to stand out in technical discussions.
Application Process: Applied for the position through an online application process.
Interview Rounds:
Round 1 - HR Interview:
Questions Asked: Basic questions about my candidacy, background, and interest in the role.
Your Approach: Answered honestly and professionally, highlighting my experience and enthusiasm for the position.
Outcome: Advanced to the next round.
Round 2 - SQL Coding (HackerRank Live Test):
Questions Asked: SQL coding questions where I had to write queries live.
Your Approach: Attempted to solve the queries using my own approach, but the interviewer insisted on a specific method they had in mind.
Outcome: The interviewer was unprofessional—did not turn on their camera, dismissed my approach, and showed disinterest (yawning throughout). This negatively impacted my experience and interest in the role.
Conclusion:
The interview process, especially the second round, was disappointing due to the unprofessional behavior of the interviewer. It made me reconsider my interest in the position at Tiger Analytics. For future candidates, I’d advise preparing for rigid interviewers who may not be open to alternative solutions. Stay composed and professional, even if the interviewer isn’t.
Application Process: I was interviewed at the Chennai campus. Prior to this, I had a telephonic interview where I was informed that my case solution was excellent and they were keen to recruit me.
Interview Rounds:
Round 1 - Telephonic Interview:
Questions Asked: Evaluation of a case study I had submitted.
Your Approach: I prepared a comprehensive analysis and presented my solution clearly.
Outcome: Positive feedback; informed that my solution was excellent and they were interested in recruiting me.
Round 2 - Face-to-Face Interview:
Questions Asked: Further discussion on the case study and general questions about my experience.
Your Approach: I answered all questions and provided a detailed analysis.
Outcome: The panel arrived late, seemed unqualified, and asked me to leave without proper feedback.
Conclusion:
My experience with Tiger Analytics was highly disappointing. Despite performing well in the telephonic round and preparing thoroughly for the face-to-face interview, the panel was unprofessional—arriving late and lacking competence. They dismissed me without any constructive feedback, which was disrespectful to the effort I had put in. I would advise future candidates to be cautious and consider whether this company aligns with their expectations of professionalism and respect for candidates.
Application Process: I applied via a referral and was interviewed in September 2023.
Interview Rounds:
Round 1 - HR Round:
Questions Asked: General HR questions about my interest in the role and reasons for job change.
Your Approach: I focused on aligning my career goals with the role and company values, while also being honest about my motivations for seeking a change.
Outcome: Passed to the next round.
Round 2 - Technical Round:
Questions Asked: Resume-based questions and guesstimates with a senior manager.
Your Approach: I ensured I could explain every detail on my resume clearly and practiced guesstimates to structure my answers logically.
Outcome: Advanced to the final round.
Round 3 - Case Study Round:
Questions Asked: Resume-based questions and a case interview with a senior director.
Your Approach: I prepared by reviewing common case study frameworks and practiced articulating my thought process clearly.
Outcome: Successfully cleared the round.
Preparation Tips:
Brush up on resume details to answer any questions confidently.
Practice guesstimates and case studies to improve problem-solving skills.
Research the company’s projects and values to align your answers.
Conclusion:
Overall, the interview process was thorough but fair. Being well-prepared for each round and staying calm during the case study helped me perform well. For future candidates, I’d recommend practicing case studies and guesstimates extensively and ensuring your resume is polished and ready for detailed questioning.
Application Process: Applied through an online job portal.
Interview Rounds:
Round 1 - Case Study (Analytics-Based):
Questions Asked:
Presented with a business problem requiring analytical insights.
Asked to outline a structured approach to solve the problem.
Your Approach:
Broke down the problem into smaller components.
Used a framework to analyze the data and propose actionable solutions.
Outcome: Successfully cleared the round.
Round 2 - Technical Round (SQL, Python):
Questions Asked:
SQL queries for data extraction and manipulation.
Python coding questions focused on data analysis and visualization.
Your Approach:
Wrote optimized SQL queries and explained the logic.
Demonstrated Python skills using libraries like Pandas and Matplotlib.
Outcome: Advanced to the next round.
Round 3 - HR and Culture Fit:
Questions Asked:
Discussed previous work experiences and challenges.
Questions about teamwork, leadership, and adaptability.
Your Approach:
Shared relevant experiences and aligned them with the company’s values.
Emphasized collaboration and problem-solving skills.
Outcome: Cleared the round and moved to salary discussion.
Preparation Tips:
Practice case studies focusing on analytical problem-solving.
Brush up on SQL and Python, especially for data analysis tasks.
Be ready to discuss your past experiences in detail, highlighting teamwork and leadership.
Conclusion:
The interview process was thorough but well-structured. The case study round was challenging but rewarding. I could have practiced more SQL edge cases. Overall, a great learning experience!