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

Clear (1)

Tech Mahindra SQL Developer Interview Questions and Answers

Updated 2 Dec 2024

Tech Mahindra SQL Developer Interview Experiences

3 interviews found

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. What is sql , index , stored proc , triggers

SQL Developer Interview Questions & Answers

user image Teju Royal

posted on 19 Dec 2023

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Company Website and was interviewed in Nov 2023. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all Resume tips
Round 2 - One-on-one 

(2 Questions)

  • Q1. Tell me about yourself
  • Q2. Say something about compay
Round 3 - HR 

(1 Question)

  • Q1. Why do u choose this role

Interview Preparation Tips

Topics to prepare for Tech Mahindra SQL Developer interview:
  • SQL

SQL Developer Interview Questions Asked at Other Companies

asked in BNP Paribas
Q1. How is a change request in application serviced by development te ... read more
asked in BNP Paribas
Q2. Write down a procedure to return a certain series (99, 96, 93, .. ... read more
asked in BNP Paribas
Q3. Given sample data on two tables, write down the result sets of al ... read more
asked in Capgemini
Q4. 2. Query optimization techniques? 3. Types of schemas and differe ... read more
asked in Accenture
Q5. What is Database Management System?

SQL Developer Interview Questions & Answers

user image Anonymous

posted on 30 Mar 2022

I applied via Company Website

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all Resume tips
Round 2 - Aptitude Test 

Trians and clock and blood relation

Interview Preparation Tips

Interview preparation tips for other job seekers - Iam manohar Iam from Bangalore pragent SQL coaching

SQL Developer Jobs at Tech Mahindra

View all

Interview questions from similar companies

I was interviewed in Apr 2017.

Interview Questionnaire 

2 Questions

  • Q1. Java questions...
  • Q2. Tell me about urself and about us family and all
  • Ans. 

    I am a software developer with a passion for coding and problem-solving. My family is supportive and has always encouraged my career in tech.

    • Experienced software developer

    • Passionate about coding and problem-solving

    • Supportive family that encourages my career in tech

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: Easy questions are there
Duration: 1 hour
Total Questions: 90

Round: Group Discussion
Experience: 12 members are there only 9 got selected
Tips: Be confident in urself and specially work in Communication skills
Duration: 15 minutes

Round: Technical Interview
Experience: Asking all the concepts of Java like oops collections threads
Tips: Prepare well on Java

Round: HR Interview
Experience: Everything was Gud but due to my certificate problem I got rejected.. Otherwise everything is good.
Tips: Be confident

College Name: C. V. Raman College of Engineering

I was interviewed before Mar 2021.

Round 1 - Face to Face 

(3 Questions)

Round duration - 60 minutes
Round difficulty - Easy

This was an easy round which went really smooth.

  • Q1. 

    Nth Fibonacci Number Problem Statement

    Calculate the Nth term in the Fibonacci sequence, where the sequence is defined as follows: F(n) = F(n-1) + F(n-2), with initial conditions F(1) = F(2) = 1.

    Input:

    ...
  • Ans. 

    Calculate the Nth Fibonacci number efficiently using dynamic programming.

    • Use dynamic programming to store previously calculated Fibonacci numbers to avoid redundant calculations.

    • Start with base cases F(1) and F(2) as 1, then iteratively calculate F(n) using F(n-1) and F(n-2).

    • Ensure the input N is within the constraints 1 <= N <= 10000.

    • Example: For N = 5, the 5th Fibonacci number is 5 (1, 1, 2, 3, 5).

  • Answered by AI
  • Q2. 

    Prime Numbers Problem Statement

    Given a positive integer N, your task is to determine and return all prime numbers less than or equal to N.

    Input:

    N = 10

    Output:

    2 3 5 7

    Example:

    Input:
    N = 20
    Out...
  • Ans. 

    Implement a function to return all prime numbers less than or equal to a given positive integer N.

    • Create a function that takes a positive integer N as input

    • Iterate from 2 to N and check if each number is prime

    • Use a helper function to determine if a number is prime

    • Return an array of all prime numbers less than or equal to N

  • Answered by AI
  • Q3. What is a merge join in SQL?
  • Ans. 

    A merge join in SQL is a method of combining two sorted datasets by matching corresponding rows based on a specified condition.

    • Merge join is used when joining two large datasets that are already sorted.

    • It is more efficient than other join methods like nested loop join or hash join for sorted datasets.

    • The join condition must be an equality condition.

    • Example: SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.i

  • Answered by AI
Round 2 - HR 

Round duration - 30 minutes
Round difficulty - Easy

The round went excellent. I really enjoyed it. Just be confident about whatever you answer

Interview Preparation Tips

Eligibility criteriaAbove 7 CGPALarsen & Toubro Infotech (LTI) interview preparation:Topics to prepare for the interview - Database, Basic C/C++, Data Structures, Algorithms, System Design, Aptitude, OOPSTime required to prepare for the interview - 3 monthsInterview preparation tips for other job seekers

Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Go through all the previous interview experiences from Codestudio and Leetcode.
Tip 3 : Do at-least 2 good projects and you must know every bit of them.

Application resume tips for other job seekers

Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.

Final outcome of the interviewSelected

Skills evaluated in this interview

I was interviewed before Mar 2021.

Round 1 - Face to Face 

(2 Questions)

Round duration - 60 minutes
Round difficulty - Easy

This round went well. Interview depends on your basic knowledge of C/C++.

  • Q1. 

    Matrix Multiplication Task

    Given two sparse matrices MAT1 and MAT2 of integers with dimensions 'N' x 'M' and 'M' x 'P' respectively, the goal is to determine the resulting matrix produced by their multipl...

  • Ans. 

    Implement a function to multiply two sparse matrices and return the resulting matrix.

    • Create a function that takes two sparse matrices as input and returns the resulting matrix after multiplication

    • Iterate through the non-zero elements of the matrices to perform the multiplication efficiently

    • Handle the edge cases such as empty matrices or matrices with all zero elements

    • Ensure the dimensions of the matrices are compatible

  • Answered by AI
  • Q2. 

    Problem: Count Even or Odd in Array

    Tanmay and Rohit are best buddies. Tanmay gives Rohit a challenge involving an array of N natural numbers. The task is to perform and answer a series of queries on the ...

  • Ans. 

    Count the number of even or odd numbers in a range of an array based on given queries.

    • Create an array to store the input numbers.

    • Iterate through the queries and update or count even/odd numbers based on the query type.

    • Output the count of even or odd numbers for each query of type 1 or 2.

  • Answered by AI
Round 2 - HR 

Round duration - 30 minutes
Round difficulty - Easy

Typical HR round with behavioral problems.

Interview Preparation Tips

Eligibility criteriaAbove 7 CGPALarsen & Toubro Infotech (LTI) interview preparation:Topics to prepare for the interview - Data Structures, Algorithms, System Design, Aptitude, OOPSTime required to prepare for the interview - 3 monthsInterview preparation tips for other job seekers

Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Go through all the previous interview experiences from Codestudio and Leetcode.
Tip 3 : Do at-least 2 good projects and you must know every bit of them.

Application resume tips for other job seekers

Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.

Final outcome of the interviewSelected

Skills evaluated in this interview

I was interviewed before Sep 2016.

Interview Preparation Tips

Round: Group Discussion
Experience: Interview was scheduled in Grab Job consultancy. In that, a class room, where we all asked to sit and interviewer was sitting in front and asked to speak one by one on the topic traffic situation in Hyderabad.
Tips: Just speak once two to three lines. Don't rush to speak. Take ur time and don't try speak repeatedly.
Duration: 35 minutes

Round: Technical Interview
Experience: System based test. Easy question from java , c, data structure.

Round: HR Interview
Experience: Not held because already we got too late.

Skills: Proficiency In English, Basic Coding
College Name: Medak College of engineering

I was interviewed in Mar 2017.

Interview Questionnaire 

5 Questions

  • Q1. Oops concepts in Java?
  • Ans. 

    Oops concepts in Java

    • Encapsulation - hiding implementation details

    • Inheritance - reusing code and creating parent-child relationships

    • Polymorphism - multiple forms of a method or object

    • Abstraction - creating abstract classes and interfaces

    • Example: Encapsulation - using private variables and public methods

    • Example: Inheritance - creating a subclass that inherits from a superclass

    • Example: Polymorphism - using method overloa...

  • Answered by AI
  • Q2. Altering columns in Databases?
  • Ans. 

    Altering columns in databases involves modifying the structure of a table by adding, deleting or modifying columns.

    • Use ALTER TABLE statement to modify columns

    • Add new columns using ADD COLUMN

    • Delete columns using DROP COLUMN

    • Modify columns using MODIFY COLUMN

    • Changing column data type may result in data loss

  • Answered by AI
  • Q3. Asked some queries in SQL
  • Q4. Reversing a number in java?
  • Ans. 

    Reversing a number in Java

    • Convert the number to a string

    • Use StringBuilder to reverse the string

    • Convert the reversed string back to a number

  • Answered by AI
  • Q5. Extracting words from a line in java?
  • Ans. 

    To extract words from a line in Java, split the line using whitespace as delimiter.

    • Use the split() method of String class

    • Pass the whitespace regex as argument to split() method

    • Iterate over the resulting array to get individual words

  • Answered by AI

Interview Preparation Tips

Round: Technical Interview
Experience: Started with the question "Tell me about yourself". Asked me about Core Java. Asked to solve some questions related to Java and SQL.
Tips: Be prepared with high knowledge in Java, Data Structures and SQL.

Skills: Java Programming, Data Strrutures, SQL
College Name: IIITDM Jabalpur

Skills evaluated in this interview

Interview Questionnaire 

2 Questions

  • Q1. What's a Single Ops tool?
  • Ans. 

    Single Ops tool is a software that helps businesses manage their operations from a single platform.

    • It streamlines processes and improves efficiency

    • It can include features like scheduling, inventory management, and invoicing

    • Examples include ServiceTitan, Jobber, and Housecall Pro

  • Answered by AI
  • Q2. Tell me about yourself
  • Ans. 

    I am a dedicated and hardworking individual with a passion for learning and growth.

    • I have a background in marketing and have worked in the industry for 5 years.

    • I am currently pursuing a Master's degree in Business Administration to further my skills and knowledge.

    • I am a team player and enjoy collaborating with others to achieve common goals.

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: We had screening test in which 15 out of 40 were shortlisted
Tips: Be quick , skip the difficult ones
Duration: 20 minutes
Total Questions: 60

Round: Group Discussion
Experience: Had a brief discussion on the topic.Started the conversation and did positive contribution.
Tips: Speak with confidence , maintain eye contact with everyone .
Duration: 15 minutes

Round: Technical Interview
Experience: Have been asked around 10-15 questions , difficulty is moderate

Round: HR Interview
Experience: Open loop questions
Tips: Be realistic and keep it short

College Name: Malla Reddy Institute Of Engineering & Technology ( MRIET )

Skills evaluated in this interview

Associate Interview Questions & Answers

Capgemini user image Vivek kumar Singh

posted on 26 Jul 2017

Interview Questionnaire 

1 Question

  • Q1. Self intro Technical

Interview Preparation Tips

Round: Technical round
Experience: Computer skills

Round: Manager Round
Experience: Manager asked about experience and academics questions

Contribute & help others!
anonymous
You can choose to be anonymous

Tech Mahindra Interview FAQs

How many rounds are there in Tech Mahindra SQL Developer interview?
Tech Mahindra interview process usually has 2 rounds. The most common rounds in the Tech Mahindra interview process are Resume Shortlist, Aptitude Test and One-on-one Round.
How to prepare for Tech Mahindra SQL Developer interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Tech Mahindra. The most common topics and skills that interviewers at Tech Mahindra expect are SQL Development, SQL, ETL, SQL Queries and Data Warehousing.

Recently Viewed

INTERVIEWS

Honeywell Building Solutions

No Interviews

INTERVIEWS

Rock On

No Interviews

INTERVIEWS

AVASOFT

No Interviews

INTERVIEWS

Embibe

No Interviews

INTERVIEWS

NCR Voyix

No Interviews

INTERVIEWS

Cognizant

No Interviews

INTERVIEWS

Accenture

No Interviews

INTERVIEWS

LTIMindtree

No Interviews

INTERVIEWS

Autodesk

No Interviews

INTERVIEWS

AVASOFT

No Interviews

Tell us how to improve this page.

Tech Mahindra SQL Developer Interview Process

based on 4 interviews

Interview experience

4.5
  
Good
View more
Tech Mahindra SQL Developer Salary
based on 165 salaries
₹2.8 L/yr - ₹10 L/yr
At par with the average SQL Developer Salary in India
View more details

Tech Mahindra SQL Developer Reviews and Ratings

based on 10 reviews

3.8/5

Rating in categories

3.2

Skill development

3.6

Work-life balance

3.8

Salary

3.7

Job security

3.6

Company culture

3.7

Promotions

3.6

Work satisfaction

Explore 10 Reviews and Ratings
Opening For SQL Developer (Pan India)

Hyderabad / Secunderabad,

Pune

+1

5-10 Yrs

Not Disclosed

SQL Developer ! 7+ yrs ! Hyderabad

Hyderabad / Secunderabad

7-12 Yrs

₹ 14-22.5 LPA

Explore more jobs
Software Engineer
26.3k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Software Engineer
21.4k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Technical Lead
11.7k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate Software Engineer
5.5k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Team Lead
5k salaries
unlock blur

₹0 L/yr - ₹0 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
Rate your experience using AmbitionBox
Terrible
Terrible
Poor
Poor
Average
Average
Good
Good
Excellent
Excellent