Tech Mahindra Data Analyst Interview Questions & Experience Guide

Interview Preparation
,
21

Company Name: Tech Mahindra

Position: Data Analyst

Location: [Not specified]

Application Process: Applied via the company website in December 2021.

Interview Rounds:

  • Round 1 - Technical Interview:
    • Questions Asked: Questions related to the BSc Computer Science curriculum, covering various topics in computer science.
    • Your Approach: Focused on answering questions clearly and confidently, ensuring to demonstrate both technical knowledge and communication skills.
    • Outcome: The round was a stress test to evaluate knowledge and communication abilities.

Preparation Tips:

  • This interview was a technical one but also served as a stress test. Be prepared to answer questions related to your curriculum (e.g., Computer Science topics).
  • Practice clear and concise communication to showcase both technical and soft skills.

Conclusion:
The interview was a good experience, testing both technical knowledge and communication skills. For future candidates, focus on understanding your curriculum thoroughly and practice articulating your answers clearly under pressure.

22

Company Name: Tech Mahindra

Position: Data Analyst

Application Process: I was approached by the company for this role and interviewed before October 2022.

Interview Rounds:

  • Round 1 - Resume Shortlist:

    • Questions Asked: No specific questions were asked in this round. The focus was on reviewing my resume.
    • Your Approach: I ensured my resume was concise and highlighted relevant skills and projects for the Data Analyst role.
    • Outcome: My resume was shortlisted, and I moved to the next round.

  • Round 2 - Technical Round:

    • Questions Asked:
      1. Questions related to my projects.
      2. “Tell us about your project.”
    • Your Approach: I discussed my projects in detail, emphasizing the tools and methodologies I used, such as SQL, Power BI, and data analysis techniques. I also explained the impact of my work.
    • Outcome: The interviewers seemed satisfied with my responses, and I progressed further in the hiring process.

Preparation Tips:

  • Focus on your resume and ensure it clearly showcases your skills and projects relevant to the role.
  • Be prepared to discuss your projects in detail, including the tools and technologies you used.
  • Brush up on technical skills like SQL, Power BI, and data analysis concepts.

Conclusion:
Overall, the interview process was smooth, and the questions were aligned with the role. I could have prepared more thoroughly for project-related questions to make my answers even more impactful. For future candidates, I’d recommend practicing how to articulate your project experiences clearly and confidently.

23

Company Name: Tech Mahindra

Position: Data Analyst

Location: [Not specified]

Application Process: Applied via a job portal in July 2023.

Interview Rounds:

  • Round 1 - Technical Round:

    • Questions Asked:
      1. Self-introduction and development.
      2. Excel-related questions.
      3. Dashboard-related questions.
      4. Project-related questions.
      5. General experience discussion (“This is a very good experience”).
    • Your Approach: Prepared thoroughly for Excel and dashboard-related topics, and ensured a clear and concise self-introduction.
    • Outcome: Successfully cleared the round.

  • Round 2 - Technical Round:

    • Questions Asked:
      1. All questions from the previous round were revisited.
    • Your Approach: Maintained consistency in answers and elaborated where necessary.
    • Outcome: Cleared the round successfully.

Preparation Tips:

  • Focus on Advance Excel and Power BI.
  • Practice creating dashboards.
  • Attend as many interviews as possible to gain experience.

Conclusion:
The overall interview experience was positive. The key to success was thorough preparation in Excel and dashboard-related topics. For future candidates, I recommend practicing consistently and attending every interview opportunity to build confidence.

24

Company Name: Tech Mahindra

Position: Data Analyst

Location: [Not specified]

Application Process: [Not specified]

Interview Rounds:

  • Round 1 - Technical Round:

  • Questions Asked:

    • How to add months to the current date using SQL functions?

  • Your Approach:

    • I explained the use of the DATE_ADD or ADD_MONTHS function in SQL, depending on the database system (e.g., MySQL, Oracle, or PostgreSQL). I also provided an example query to demonstrate the implementation.

  • Outcome:

    • The interviewer seemed satisfied with my explanation, and I passed this round.

Preparation Tips:

  • Brush up on SQL functions, especially date manipulation functions, as they are commonly asked in technical rounds for Data Analyst roles.
  • Practice writing queries for different scenarios to ensure clarity and confidence during the interview.

Conclusion:
The interview was straightforward, focusing on practical SQL knowledge. I felt prepared for the question, but I could have explored more edge cases or variations of the problem to showcase deeper understanding. For future candidates, I’d recommend practicing a wide range of SQL problems to handle any unexpected twists in the questions.

25

Company Name: Tech Mahindra

Position: Data Analyst

Location: On-campus (Virtual Mode)

Application Process: Applied through on-campus placement. The interview was conducted virtually, with a group of 5 candidates interviewed simultaneously.

Interview Rounds:

  • Round 1 - Technical Interview:

    • Questions Asked:

      • SQL queries to retrieve specific data from a given dataset.
      • Questions about data manipulation and retrieval techniques.

    • Your Approach:

      • Focused on writing efficient SQL queries to fetch the required data.
      • Ensured clarity in explaining the logic behind each query.

    • Outcome: Successfully cleared the round.

Preparation Tips:

  • Practice writing SQL queries for various scenarios, especially data retrieval and manipulation.
  • Familiarize yourself with common datasets to quickly understand and work with given data during interviews.

Conclusion:
The experience was smooth, and the virtual setup worked well. Practicing SQL beforehand was very helpful. For future candidates, I’d recommend focusing on hands-on SQL practice and being comfortable with explaining your approach during the interview.

26

Company Name: Tech Mahindra

Position: Data Analyst

Application Process: I applied through the company website and was interviewed before February 2023.

Interview Rounds:

  • Round 1 - Technical Round:
    • Questions Asked:
      1. Introduce yourself.
      2. What are outliers?
      3. How do you deal with outliers?
    • Your Approach:
      • For the introduction, I kept it concise, focusing on my educational background, relevant skills, and projects.
      • For the outliers question, I explained what outliers are in the context of data analysis and provided examples.
      • For handling outliers, I discussed techniques like removing them, transforming the data, or using robust statistical methods.
    • Outcome: I successfully cleared this round.

Preparation Tips:

  • Brush up on basic statistical concepts like outliers, data cleaning, and transformation techniques.
  • Practice explaining your projects and skills clearly and concisely.
  • Familiarize yourself with tools like SQL, SAS, and Spark, as they are often relevant for Data Analyst roles.

Conclusion:
The interview was straightforward, with a focus on technical knowledge and problem-solving skills. I felt well-prepared, but I could have practiced more real-world scenarios for handling outliers. For future candidates, I’d recommend being clear and confident in your explanations and ensuring you understand the basics of data analysis thoroughly.

27

Company Name: Tech Mahindra

Position: Data Analyst

Location: [Not specified]

Application Process: Applied via Naukri.com and was interviewed in April 2023.

Interview Rounds:

  • Round 1 - Resume Shortlist:

  • Questions Asked: Resume-based screening.

  • Your Approach: Ensured my resume was concise and highlighted relevant skills for the Data Analyst role.

  • Outcome: Cleared this round successfully.

  • Round 2 - Aptitude Test:

  • Questions Asked: Topics included MySQL, Power BI, Tableau, Advanced Excel, and Python.

  • Your Approach: Focused on revising key concepts and practicing problems related to these tools.

  • Outcome: Passed the aptitude test.

  • Round 3 - Coding Test:

  • Questions Asked: MySQL coding tasks in Database Workbench 8.0.

  • Your Approach: Practiced writing SQL queries beforehand to ensure familiarity with the syntax and functions.

  • Outcome: Successfully completed the coding test.

  • Round 4 - Technical Round:

  • Questions Asked: Focused on the Data Analyst profile, testing technical knowledge.

  • Your Approach: Prepared by reviewing data analysis concepts and tools mentioned in the job description.

  • Outcome: Cleared the technical round.

Preparation Tips:

  • Brush up on MySQL, Power BI, Tableau, Advanced Excel, and Python as these are commonly tested.
  • Practice writing SQL queries and solving problems in Database Workbench.
  • Ensure your resume is tailored to the role and highlights relevant skills.

Conclusion:
Overall, the interview process was smooth, and the rounds were well-structured. I focused on revising key technical skills and ensuring my resume was strong, which helped me clear all rounds. For future candidates, I’d recommend thorough preparation in the tools mentioned and practicing SQL queries extensively.

28

Company Name: Tech Mahindra

Position: Data Analyst

Location: [Not specified]

Application Process: Applied via campus placement in October 2020.

Interview Rounds:

  • Round 1 - Technical Interview:

    • Questions Asked:
      1. Tell me about yourself.
      2. What is your strength?
      3. What is an Aadhar card? (The interviewer asked this because I was involved in an Aadhar-related process.)
      4. Check reading and conversation skills.
      5. Are you okay with night shifts?
    • Your Approach: I answered confidently, focusing on my skills and experiences relevant to the role. For the Aadhar card question, I explained its purpose and significance. I also ensured my reading and conversation skills were clear and articulate.
    • Outcome: Passed this round.

  • Round 2 - HR Interview:

    • Questions Asked: Similar questions to the technical round, with more focus on personal strengths and willingness to work in shifts.
    • Your Approach: I reiterated my strengths and confirmed my flexibility for night shifts.
    • Outcome: Passed this round.

  • Round 3 - Aptitude Test:

    • Questions Asked: Basic aptitude questions covering logical reasoning and quantitative ability.
    • Your Approach: I solved the questions methodically, ensuring accuracy.
    • Outcome: Passed this round.

  • Round 4 - Final Interview:

    • Questions Asked: A mix of technical and HR questions, including scenario-based queries.
    • Your Approach: I combined my technical knowledge with problem-solving skills and maintained a positive attitude.
    • Outcome: Successfully cleared the final round.

Preparation Tips:

  • All questions were straightforward, so focus on being clear and confident in your answers.
  • Brush up on basic technical concepts and practice aptitude questions.
  • Be prepared to discuss your strengths and flexibility for work shifts.

Conclusion:
The interview process was smooth, and the questions were manageable. I could have prepared more for scenario-based questions, but overall, it was a good experience. My advice to future candidates is to stay calm and answer confidently, as the questions are designed to assess your clarity and adaptability.