Interview questions for Tech Mahindra Data Analyst
Hi everyone, this topic is for sharing Preparation guidelines and interview experience for Tech Mahindra Data Analyst
The Data Analyst at Tech Mahindra 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:
Interview Process Summary
Application: Applied via a job portal in July 2023. Location not specified.
Follow-up and deeper questions on topics from Round 1 (e.g., Excel/Power BI, project details).
Outcome: Cleared.
Technical (SQL)
How do you add months to the current date using SQL functions?
Excel/Power BI (Tools and Dashboards)
What Excel functions do you use frequently for data analysis?
How do you design and build dashboards? Walk me through a dashboard you created and explain its functionality.
Projects/Portfolio
Discuss your past projects in detail, focusing on the data analysis aspects.
What was your specific role and contribution in these projects?
HR/Personality/Behavioral
Please introduce yourself. (Self-introduction)
Can you walk me through your overall professional experience?
Interview Preparation Tips
Brush up on SQL date functions (e.g., DATE_ADD, ADD_MONTHS, INTERVAL) and be aware of database-specific syntax differences across MySQL, Oracle, and PostgreSQL.
Practice writing SQL for common scenarios like date calculations, joins, and aggregations.
Focus on mastering Advanced Excel and Power BI; prepare sample dashboards and be ready to explain their logic and KPIs.
Revise your projects thoroughly, emphasizing your role, methodology, and impact.
Attend mock interviews or multiple interviews for practice and confidence.
If you have attended the process from your campus, pls share your experiences here; Please follow guidelines
Application Process: [Application process details not provided]
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 being used (e.g., MySQL, Oracle, PostgreSQL). I also provided an example query to demonstrate the implementation.
Outcome: [Outcome of this round not specified]
Preparation Tips:
Brush up on SQL functions, especially date manipulation functions like DATE_ADD, ADD_MONTHS, and INTERVAL.
Practice writing queries for common scenarios like date calculations, joins, and aggregations.
Review database-specific functions as they can vary between systems like MySQL, Oracle, and PostgreSQL.
Conclusion:
The interview was straightforward, focusing on practical SQL knowledge. I felt confident in my answer, but I would recommend future candidates to prepare thoroughly for database-specific functions and practice writing queries for different use cases.
Application Process: Applied via campus placement at Sri Krishnadevaraya University (SKU) in August 2021.
Interview Rounds:
Round 1 - HR Interview:
Questions Asked:
Tell me about yourself.
What are your greatest strengths and weaknesses? Why are you looking for a change?
Tell me about the gap in your resume. How would you rate yourself on a scale of 1 to 10?
Your Approach: I answered the questions honestly, focusing on my skills and experiences relevant to the role. For strengths, I highlighted my analytical skills and adaptability, and for weaknesses, I mentioned areas I was actively working on. I explained any gaps in my resume with valid reasons.
Outcome: Successfully cleared the HR round.
Preparation Tips:
Be polite and use the right language and tone for a formal situation.
Listen to the questions carefully and think before answering.
Ask the interviewer to repeat or clarify if you don’t understand a question.
Use the STAR method to answer questions about your skills and experience.
Conclusion:
The interview was a great learning experience. Being prepared with answers to common HR questions and maintaining a confident yet humble demeanor helped me clear the round. For future candidates, I’d advise practicing common HR questions and staying calm during the interview.
Your Approach: Prepared by revising SQL queries and Excel functions thoroughly. Practiced scenario-based problems to ensure clarity in responses.
Outcome: Successfully cleared the round.
Round 3 - One-on-one Round:
Questions Asked:
Detailed description of my project (what I did and how).
Your Approach: Explained my project clearly, focusing on my contributions and the methodologies used.
Outcome: Moved to the final round.
Round 4 - HR Round:
Questions Asked:
Why should we hire you?
Why are you looking for a change?
What are your strengths and weaknesses?
Tell me about yourself.
What are your salary expectations?
Your Approach: Answered honestly and confidently, aligning my strengths with the role requirements. For salary expectations, I researched industry standards beforehand.
Outcome: Received positive feedback and an offer.
Preparation Tips:
Always speak up during interviews; don’t stay silent. Confidence and clarity in communication are key.
Revise SQL and Excel thoroughly, especially scenario-based questions.
Prepare to discuss your projects in detail, focusing on your role and the impact of your work.
Conclusion:
Overall, the interview process was smooth, and I felt well-prepared. The technical rounds were challenging but manageable with proper preparation. The HR round was more about fit and communication. My advice to future candidates is to practice speaking confidently and to thoroughly understand their projects and technical skills.
Application Process: Applied via Naukri.com and was interviewed in February 2022.
Interview Rounds:
Round 1 - Resume Shortlist:
Questions Asked: The round focused on reviewing the resume for relevant skills and experience.
Your Approach: Ensured the resume was concise and highlighted key skills like data analytics, SQL, and visualization tools.
Outcome: Successfully shortlisted for the next round.
Round 2 - Aptitude Test:
Questions Asked: The test included questions on mathematics, logical reasoning, and quantitative aptitude.
Your Approach: Prepared by practicing basic mathematical concepts and solving sample aptitude questions.
Outcome: Cleared the aptitude test and moved forward in the process.
Preparation Tips:
Focus on strengthening your mathematical skills as they play a crucial role in the aptitude test.
Practice solving quantitative and logical reasoning questions to improve speed and accuracy.
Ensure your resume is well-structured and highlights relevant skills for the role.
Conclusion:
The interview process was smooth, and the key to success was thorough preparation, especially in mathematics. For future candidates, I recommend dedicating time to aptitude practice and tailoring your resume to the job requirements.
Application Process: Applied via Naukri.com in March 2022.
Interview Rounds:
Round 1 - Resume Shortlist:
Questions Asked: Resume-based screening.
Your Approach: Ensured my resume was concise and highlighted relevant skills like Python, Data Science, and Data Analysis.
Outcome: Successfully shortlisted for the next round.
Round 2 - Coding Test:
Questions Asked: Python-based coding test.
Your Approach: Focused on Python programming concepts and problem-solving skills.
Outcome: Cleared the coding test.
Preparation Tips:
Topics to prepare: Data Science, Python.
General tip: Create a structured plan and execute it diligently to achieve success.
Conclusion:
The interview process was smooth, and the key was to present a well-structured resume and strong Python skills. Future candidates should focus on mastering Python and data analysis concepts to excel in the interview.
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.
Your Approach: Answered questions based on my knowledge of computer science topics.
Outcome: The round was a mix of technical and stress-testing questions, focusing on both knowledge and communication skills.
Preparation Tips:
Focus on your core curriculum topics, especially computer science-related subjects.
Practice communication skills as the interviewer may test your ability to articulate answers under pressure.
Conclusion:
The interview was a good learning experience, emphasizing both technical knowledge and communication. For future candidates, I’d recommend brushing up on your curriculum topics and practicing how to present your answers clearly and confidently.
Application Process: Applied via the company website in September 2021.
Interview Rounds:
Round 1 - Resume Shortlist:
Questions Asked: N/A (Resume screening round)
Your Approach: Ensured my resume was well-formatted and aligned properly to make it easy for the recruiter to review.
Outcome: Successfully shortlisted for the next round.
Round 2 - HR Round:
Questions Asked:
What are your salary expectations?
What is your family background?
Where do you see yourself in 5 years?
What are your strengths and weaknesses?
Tell me about yourself.
Your Approach: Answered honestly and confidently, focusing on aligning my career goals with the company’s vision.
Outcome: Cleared the HR round.
Preparation Tips:
Ensure your resume is well-formatted and easy to read.
Be prepared to discuss your career goals, strengths, and weaknesses clearly.
Research the company and role to align your answers with their expectations.
Conclusion:
The interview process was smooth, and the HR round was conversational. I focused on presenting myself confidently and aligning my answers with the company’s values. Proper resume formatting and thorough preparation for common HR questions helped me succeed. For future candidates, I recommend practicing common HR questions and ensuring your resume is polished.
Application Process: I applied through the company website and was interviewed before February 2023.
Interview Rounds:
Round 1 - Technical Round:
Questions Asked:
Introduce yourself.
What are outliers?
How do you deal with outliers?
Your Approach:
For the introduction, I kept it concise, focusing on my educational background, relevant skills, and why I was interested in the role.
For the question about outliers, I explained what outliers are in the context of data analysis and their impact on datasets.
Regarding dealing with outliers, I discussed common 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, especially those related to data analysis like outliers, data cleaning, and transformations.
Practice explaining technical concepts in simple terms to ensure clarity during the interview.
Be ready to discuss your previous projects or experiences related to data analysis.
Conclusion:
The interview was straightforward and focused on technical knowledge. I felt prepared for the questions asked, but I could have practiced more real-world examples to make my answers more impactful. For future candidates, I’d recommend focusing on both theoretical and practical aspects of data analysis to ace the interview.
Application Process: Applied through campus placement in October 2020.
Interview Rounds:
Round 1 - Technical Interview:
Questions Asked:
Tell me about yourself.
What is your strength?
What is an Aadhar card? (Because I was in the Aadhar process)
Check reading and conversation skills.
Are you okay with night shifts?
Your Approach: I answered confidently, focusing on my technical skills and experiences relevant to the role. For the Aadhar question, I explained its purpose and significance. I also ensured my communication was clear and concise.
Outcome: Passed this round.
Round 2 - HR Interview:
Questions Asked: Similar to the first round, with more focus on personal strengths and willingness to work in shifts.
Your Approach: I emphasized my adaptability and teamwork skills, and I confirmed my flexibility for night shifts.
Your Approach: I practiced common aptitude topics beforehand and managed my time efficiently during the test.
Outcome: Cleared the aptitude 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: Received a positive response and moved forward in the process.
Preparation Tips:
All questions were straightforward, so focus on clear communication and confidence.
Brush up on basic aptitude topics like logical reasoning and quantitative ability.
Be prepared to discuss your strengths and adaptability for shifts.
Conclusion:
The overall experience was smooth, and the questions were manageable. I could have practiced more scenario-based questions for the final round. My advice to future candidates is to stay calm, be honest, and prepare well for both technical and HR rounds.
Application Process: Applied via campus placement at Sri Krishnadevaraya University (SKU) in August 2021.
Interview Rounds:
Round 1 - HR Round:
Questions Asked:
Tell me about yourself.
What are your greatest strengths and weaknesses? Why are you looking for a change?
Tell me about the gap in your resume. How would you rate yourself on a scale of 1 to 10?
Your Approach: I answered confidently, focusing on my skills and experiences relevant to the role. For the strengths and weaknesses question, I highlighted my analytical skills and mentioned a minor weakness I was working on. I explained the gap in my resume honestly and rated myself a 7, acknowledging room for growth.
Outcome: Successfully cleared the HR round.
Preparation Tips:
Be polite and use the right language and tone for a formal situation.
Listen to the questions and think before you begin your answers.
Ask the interviewer to repeat or explain further if you do not understand a question.
Use the STAR method to answer questions about your skills and experience.
Conclusion:
The interview was a great learning experience. Being honest and confident helped me clear the round. For future candidates, I’d advise practicing common HR questions and staying calm during the interview.
Application Process: Applied via the company website in September 2021.
Interview Rounds:
Round 1 - Resume Shortlist:
Pro Tip: Properly align and format text in your resume. Poorly aligned text can lead to rejection as it takes more time for recruiters to read.
Outcome: Passed this round.
Round 2 - HR Round:
Questions Asked:
What are your salary expectations?
What is your family background?
Where do you see yourself in 5 years?
What are your strengths and weaknesses?
Tell me about yourself.
Your Approach: Answered honestly and confidently, focusing on aligning my career goals with the company’s vision.
Outcome: Cleared the HR round.
Preparation Tips:
Focus on resume formatting and alignment.
Prepare answers for common HR questions like salary expectations, strengths and weaknesses, and career goals.
Brush up on technical skills relevant to the role, such as SQL, data migration, and analytics tools.
Conclusion:
The interview process was smooth, and the HR round was conversational. Proper resume formatting and preparation for HR questions were key to clearing the rounds. For future candidates, ensure your resume is well-structured and practice common HR questions to build confidence.
Application Process: Applied via Naukri.com in April 2023.
Interview Rounds:
Round 1 - Resume Shortlist:
Questions Asked: N/A (Resume screening)
Your Approach: Ensured my resume was crisp and highlighted relevant skills for the Data Analyst role.
Outcome: Passed to the next round.
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: Cleared the aptitude test.
Round 3 - Coding Test:
Questions Asked: MySQL coding tasks performed in Database Workbench 8.0.
Your Approach: Practiced SQL queries and database management beforehand.
Outcome: Successfully completed the coding test.
Round 4 - Technical Round:
Questions Asked: Questions related to the Data Analyst profile, including technical aspects.
Your Approach: Prepared by reviewing data analytics concepts and tools mentioned in the job description.
Outcome: Awaiting results.
Preparation Tips:
Focus on mastering SQL, Power BI, Tableau, and Advanced Excel.
Practice coding in MySQL and familiarize yourself with Database Workbench.
Revise data analytics fundamentals and be ready to discuss your projects.
Conclusion:
Overall, the interview process was structured and tested both theoretical knowledge and practical skills. I ensured my resume was tailored to the role, which helped me clear the initial rounds. For future candidates, I recommend thorough preparation in the mentioned tools and staying confident during the technical discussions.
Application Process: I was approached by the company for the interview process, which took place before October 2022.
Interview Rounds:
Round 1 - Resume Shortlist:
Questions Asked: N/A (This round was focused on reviewing my resume.)
Your Approach: I ensured my resume was concise and highlighted my relevant skills and projects.
Outcome: My resume was shortlisted for the next round.
Round 2 - Technical Round:
Questions Asked:
Questions related to my projects.
“Tell us about your project.”
Your Approach: I discussed my projects in detail, focusing on my contributions, the technologies used, and the outcomes. I also prepared to explain any technical challenges I faced and how I resolved them.
Outcome: The interviewers seemed satisfied with my responses.
Preparation Tips:
Focus on clearly explaining your projects and the technical aspects involved.
Brush up on skills like SQL, Power BI, and data analysis concepts, as these are commonly asked about in such roles.
Conclusion:
Overall, the interview process was smooth, and I felt well-prepared. I would advise future candidates to thoroughly understand their projects and be ready to discuss them in detail. Additionally, practicing common technical questions related to data analysis tools can be very helpful.
Application Process: Applied via Naukri.com and was interviewed in March 2022.
Interview Rounds:
Round 1 - Resume Shortlist:
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: Successfully shortlisted for the next round.
Round 2 - Coding Test (Python):
Topics Covered: Data Science, Python
Outcome: Cleared the coding test round.
Preparation Tips:
Focus on Data Science and Python for the coding test.
Create a structured plan and execute it step-by-step to achieve success.
Application Process: The application was likely submitted through an online portal or campus placement, though specific details were not provided.
Interview Rounds:
Round 1 - HR Interview:
Questions Asked:
Are you serving a notice period?
How long is your notice period?
Your Approach: Answered honestly about the notice period status and duration.
Outcome: The result of this round was not specified.
Preparation Tips:
Familiarize yourself with common HR questions, especially those related to notice periods and current employment status.
Brush up on technical skills relevant to the role, such as Excel, SAS, data migration, and other tools mentioned in the job description.
Conclusion:
The HR round was straightforward, focusing on basic employment details. Future candidates should be prepared to discuss their notice period and ensure their technical skills align with the role requirements.
Your Approach: I prepared by revising SQL concepts and practicing Excel functions beforehand.
Outcome: I answered the questions confidently and moved to the next round.
Round 3 - One-on-one Round:
Questions Asked: Detailed discussion about my project—what I did and how I did it.
Your Approach: I explained my project thoroughly, focusing on my contributions and the methodologies used.
Outcome: The interviewer seemed satisfied with my explanation.
Round 4 - HR Round:
Questions Asked:
Why should we hire you?
Why are you looking for a change?
What are your strengths and weaknesses?
Tell me about yourself.
What are your salary expectations?
Your Approach: I answered honestly, aligning my responses with the role and company values. For salary expectations, I researched industry standards beforehand.
Outcome: The HR round went smoothly, and I was selected for the role.
Preparation Tips:
Always speak up during interviews—don’t stay silent. Confidence and clarity in communication are key.
Conclusion:
Overall, the interview process was thorough but manageable. I felt well-prepared for the technical and HR rounds. If I could do anything differently, I might have practiced more scenario-based SQL questions. My advice to future candidates is to thoroughly understand your projects and be ready to discuss them in detail.
Application Process: [Brief description of how the student applied]
Interview Rounds:
Round 1 - Technical Interview:
Questions Asked: The interview was insightful and engaging, focusing on technical expertise and problem-solving abilities. Specific questions were not provided, but the discussion highlighted the candidate’s knowledge and enthusiasm for the role.
Your Approach: The candidate articulated clear, thoughtful responses, aligning their experience with the role requirements. Their problem-solving abilities and interpersonal skills were emphasized.
Outcome: The candidate left a positive and lasting impression, indicating a strong performance in this round.
Preparation Tips:
Focus on aligning your experience with the role requirements.
Practice articulating your thoughts clearly and confidently.
Highlight problem-solving abilities and interpersonal skills during the interview.
Conclusion:
The interview was a smooth and positive experience, with the candidate’s technical expertise and enthusiasm standing out. To improve, the candidate could prepare more specific examples of their work to further demonstrate their fit for the role. Future candidates should focus on showcasing their problem-solving skills and aligning their experience with the job description.
Application Process: Applied via Naukri.com and was interviewed in February 2022.
Interview Rounds:
Round 1 - Resume Shortlist:
Questions Asked: No specific questions were asked in this round. The focus was on reviewing the resume for relevant skills and experience.
Your Approach: Ensured the resume was concise and highlighted key skills like data analytics, Excel, and other relevant tools.
Outcome: Successfully shortlisted for the next round.
Round 2 - Aptitude Test (Mathematics):
Questions Asked: Mathematics-based questions to assess analytical and problem-solving skills.
Your Approach: Focused on solving problems methodically and efficiently, ensuring accuracy.
Outcome: Cleared the aptitude test.
Preparation Tips:
Mathematics is fundamental; understanding concepts early on is crucial.
Practice aptitude questions regularly to improve speed and accuracy.
Conclusion:
The interview process was straightforward, with a strong emphasis on analytical skills. Ensuring a well-structured resume and being thorough with mathematical concepts helped me succeed. For future candidates, I’d recommend focusing on these areas to perform well in the interview process.
Application Process: Applied via a job portal in July 2023.
Interview Rounds:
Round 1 - Technical Round:
Questions Asked:
Self-introduction and development.
Excel-related questions.
Dashboard-related questions.
Project-related questions.
General experience-related question.
Your Approach:
Prepared a concise self-introduction highlighting relevant skills.
Revised Excel functions and dashboard creation techniques.
Discussed past projects in detail, focusing on data analysis aspects.
Outcome: Successfully cleared the round.
Round 2 - Technical Round:
Questions Asked:
Follow-up questions on previous topics.
Your Approach:
Answered confidently, elaborating on technical details.
Outcome: Cleared the round.
Preparation Tips:
Focus on mastering Advanced Excel and Power BI.
Prepare dashboards and be ready to explain their functionality.
Revise your projects thoroughly, especially data analysis aspects.
Attend as many interviews as possible for practice.
Conclusion:
The interview experience was positive, with a focus on technical skills like Excel, Power BI, and project discussions. Practicing mock interviews and revising core concepts helped in performing well. For future candidates, I recommend being thorough with your projects and technical tools.