Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Tech Mahindra Team. If you also belong to the team, you can get access from here

Tech Mahindra Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Tech Mahindra Business Intelligence Consultant Interview Questions and Answers

Updated 10 Oct 2020

Tech Mahindra Business Intelligence Consultant Interview Experiences

1 interview found

Interview Questionnaire 

1 Question

  • Q1. How can you do query optimization?
  • Ans. 

    Query optimization can be done by analyzing query execution plans, indexing, partitioning, and rewriting queries.

    • Analyze query execution plans to identify bottlenecks and optimize them

    • Create indexes on frequently queried columns to improve performance

    • Partition large tables to distribute data and improve query performance

    • Rewrite queries to use efficient join and filter conditions

    • Use query hints to force specific executi...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - They will ask about the live projects you worked on..Try to explain it better with your role

Interview questions from similar companies

I applied via Recruitment Consultant and was interviewed in Mar 2021. There were 3 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. It's was basic testing questios, specific to selenium and Java.
  • Q2. Explain framework
  • Ans. 

    A framework is a set of guidelines, standards, and tools used to develop software applications.

    • A framework provides a structure for developers to build upon

    • It includes pre-written code and libraries to simplify development

    • Frameworks can be specific to a programming language or platform

    • Examples include React for web development and TensorFlow for machine learning

  • Answered by AI
  • Q3. Basic java programs

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared, basically on manual testing, Selenium and Java

Skills evaluated in this interview

I applied via Campus Placement and was interviewed in Jan 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Swap two number with and without temporary variable
  • Ans. 

    Swap two numbers with and without temporary variable

    • Without temporary variable: Use addition and subtraction

    • With temporary variable: Use a third variable to store the value of one of the numbers

    • Example without temporary variable: a=5, b=7; a=a+b; b=a-b; a=a-b;

    • Example with temporary variable: a=5, b=7; temp=a; a=b; b=temp;

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Don't be afraid. It companies take interview to select you. And if you are selected in this company you are not lucky enough so try hard.

Skills evaluated in this interview

I applied via Walk-in and was interviewed in Mar 2020. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. Why should we hire you ?
  • Q2. Latest project running in the intustry?

Interview Preparation Tips

Interview preparation tips for other job seekers - Student should have to clear , to thier goals , excellent communication skills , Answer every question with clam , and must have patience.

I applied via Naukri.com and was interviewed before Jul 2020. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Performa in 3par
  • Ans. 

    Performa is a performance monitoring tool for HPE 3PAR storage arrays.

    • Performa provides real-time monitoring of storage performance metrics.

    • It helps identify performance bottlenecks and optimize storage performance.

    • Performa can generate reports and alerts based on user-defined thresholds.

    • It can also be used for capacity planning and trend analysis.

    • Examples of performance metrics monitored by Performa include IOPS, late

  • Answered by AI
  • Q2. San zoning

Interview Preparation Tips

Interview preparation tips for other job seekers - Brushup basics.

Interview Questionnaire 

2 Questions

  • Q1. About technology on which i had worked. What do you know about Design Pattern and explain them? Window Services and Web APIs.
  • Q2. MVC Architecture and Web APIs security?

Interview Preparation Tips

Interview preparation tips for other job seekers - I attended two technical round that was good in terms of technology and knowledge. Then one Managerial round which was taken by General Manager. Total interview process taken 1 month time, I must say process are slow due to approval and all.

I applied via Naukri.com and was interviewed in Nov 2020. There were 5 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Batch apex (Important), Governor limits, events, lightning and components bundle, Relationship in salesforce, how are account and contact related, If accounts gets deleted will the contact also get deleted...

Interview Preparation Tips

Interview preparation tips for other job seekers - Just prepare well before interview, join before 10 mins they hate delay, prepare notes have a topic in each page, and description, syntax, use cases and example in the page, if space is there put imp notes or latest interview questions, Batch apex, governor limits, types of error, lightning, lwc, aura, @future annotation, rest api, soap api, test starting ways, events, how to handle events including third party. brush up all these

Interview Questionnaire 

1 Question

  • Q1. What's your strength

Interview Questionnaire 

1 Question

  • Q1. Basic question about testing, risk management, integration testing, CFR21 PART 11

I applied via Naukri.com and was interviewed in May 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Related to Sever

Interview Preparation Tips

Interview preparation tips for other job seekers - There were 2 Tech round and the interviewer asked me from the JD not from Resume.
We have to be strong in technical.
All the Best for your career

Tell us how to improve this page.

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.6k Interviews
Accenture Interview Questions
3.8
 • 8.3k Interviews
Infosys Interview Questions
3.6
 • 7.6k Interviews
Wipro Interview Questions
3.7
 • 5.7k Interviews
Cognizant Interview Questions
3.7
 • 5.7k Interviews
Capgemini Interview Questions
3.7
 • 4.8k Interviews
HCLTech Interview Questions
3.5
 • 3.9k Interviews
Genpact Interview Questions
3.8
 • 3.2k Interviews
LTIMindtree Interview Questions
3.7
 • 2.9k Interviews
IBM Interview Questions
4.0
 • 2.4k Interviews
View all
Tech Mahindra Business Intelligence Consultant Salary
based on 6 salaries
₹5.4 L/yr - ₹20 L/yr
28% more than the average Business Intelligence Consultant Salary in India
View more details

Tech Mahindra Business Intelligence Consultant Reviews and Ratings

based on 1 review

5.0/5

Rating in categories

5.0

Skill development

5.0

Work-life balance

3.0

Salary

5.0

Job security

5.0

Company culture

4.0

Promotions

5.0

Work satisfaction

Explore 1 Review and Rating
Software Engineer
26.4k salaries
unlock blur

₹2 L/yr - ₹9.5 L/yr

Senior Software Engineer
21.6k salaries
unlock blur

₹5.5 L/yr - ₹23.5 L/yr

Technical Lead
11.9k salaries
unlock blur

₹9.6 L/yr - ₹38.5 L/yr

Associate Software Engineer
5.7k salaries
unlock blur

₹1.8 L/yr - ₹5.9 L/yr

Team Lead
5.1k salaries
unlock blur

₹5.3 L/yr - ₹17.5 L/yr

Explore more salaries
Compare Tech Mahindra with

Infosys

3.6
Compare

Cognizant

3.7
Compare

Accenture

3.8
Compare

Wipro

3.7
Compare
Did you find this page helpful?
Yes No
write
Share an Interview