Add office photos
Tech Mahindra logo
Engaged Employer

Tech Mahindra

Verified
3.5
based on 35.4k Reviews
Video summary
Filter interviews by
Associate Analyst
Clear (1)

Tech Mahindra Associate Analyst Interview Questions and Answers

Updated 21 Jun 2024

Q1. 1.what is kyc 2. Why kyc is important 3.what is money laundering 4.what are the stages of money laundering 5. What do you mean by CDD and EDD 6. Finance related questions to check the subject knowledge 7. What...

read more
Ans.

Questions related to KYC, money laundering, CDD, EDD, and finance were asked for the Associate Analyst position.

  • KYC stands for Know Your Customer and is the process of verifying the identity of a customer.

  • KYC is important to prevent fraud, money laundering, and terrorist financing.

  • Money laundering is the process of making illegally obtained money appear legitimate.

  • The stages of money laundering include placement, layering, and integration.

  • CDD stands for Customer Due Diligence...read more

View 4 more answers
right arrow

Q2. 1. What is kyc? 2.Why kyc is important? 3. What is money laundering? 4. What are the stages of money laundering? 5.What do you mean by CDD and EDD? 6. Finance related questions to check the subject knowledge 7....

read more
Ans.

Answering questions related to KYC, money laundering, and finance

  • KYC stands for Know Your Customer and is the process of verifying the identity of a customer or client

  • KYC is important to prevent fraud, money laundering, and terrorist financing

  • Money laundering is the process of making illegally obtained money appear legitimate

  • The stages of money laundering include placement, layering, and integration

  • CDD stands for Customer Due Diligence and is the process of verifying the iden...read more

Add your answer
right arrow

Q3. You are from diffrent stream and why do you wnat to join in this

Ans.

I am passionate about this field and have relevant skills and experience to contribute effectively.

  • I have always been interested in this field and have pursued relevant courses or projects in it

  • I have developed skills and gained experience that are directly applicable to this role

  • I am excited about the opportunity to learn and grow in this field

  • I believe my background in a different stream will bring a fresh perspective to the team

Add your answer
right arrow

Q4. what are the types of SQL joins

Ans.

SQL joins are used to combine data from two or more tables based on a related column between them.

  • Inner join: returns only the matching rows from both tables

  • Left join: returns all the rows from the left table and matching rows from the right table

  • Right join: returns all the rows from the right table and matching rows from the left table

  • Full outer join: returns all the rows from both tables, with NULL values in the columns where there is no match

  • Cross join: returns the Cartesi...read more

Add your answer
right arrow
Discover Tech Mahindra interview dos and don'ts from real experiences

Q5. explain algorithms followed by SQL join

Ans.

SQL join algorithms are used to combine data from multiple tables based on a common column.

  • SQL join algorithms include nested loop join, hash join, and merge join.

  • Nested loop join is the simplest and slowest algorithm, where each row in one table is compared to every row in the other table.

  • Hash join is faster, where a hash table is created for one table and the other table is scanned to match the hash values.

  • Merge join is the fastest, where both tables are sorted on the join ...read more

Add your answer
right arrow

Q6. execute query on self join

Ans.

Self join is used to join a table with itself.

  • Use table aliases to differentiate between the two instances of the same table

  • Specify the join condition using the aliases

  • Example: SELECT e1.employee_name, e2.employee_name FROM employees e1 JOIN employees e2 ON e1.manager_id = e2.employee_id

Add your answer
right arrow

Q7. Why we use Excel

Ans.

Excel is a powerful tool for data analysis, visualization, and organization.

  • Excel allows for easy data entry and manipulation

  • It can perform complex calculations and analysis

  • Excel can create charts and graphs for data visualization

  • It is widely used in business for budgeting, forecasting, and reporting

  • Excel can be used for project management and tracking tasks

Add your answer
right arrow
Contribute & help others!
Write a review
Write a review
Share interview
Share interview
Contribute salary
Contribute salary
Add office photos
Add office photos

Interview Process at Tech Mahindra Associate Analyst

based on 11 interviews
3 Interview rounds
Resume Shortlist Round
HR Round
One-on-one Round
View more
interview tips and stories logo
Interview Tips & Stories
Ace your next interview with expert advice and inspiring stories

Top Associate Analyst Interview Questions from Similar Companies

Wipro Logo
3.7
 • 27 Interview Questions
Deloitte Logo
3.8
 • 15 Interview Questions
View all
Recently Viewed
INTERVIEWS
Concentrix Corporation
No Interviews
INTERVIEWS
Jet2 Travel Technologies
No Interviews
INTERVIEWS
Jet2 Travel Technologies
No Interviews
INTERVIEWS
Jet2 Travel Technologies
No Interviews
INTERVIEWS
Netcracker Technology
No Interviews
INTERVIEWS
Neebal Technologies
No Interviews
INTERVIEWS
People Tech Group
No Interviews
INTERVIEWS
Air India Sats Airport Services
No Interviews
INTERVIEWS
Netcracker Technology
No Interviews
INTERVIEWS
Jet2 Travel Technologies
No Interviews
Share an Interview
Stay ahead in your career. Get AmbitionBox app
play-icon
play-icon
qr-code
Helping over 1 Crore job seekers every month in choosing their right fit company
75 Lakh+

Reviews

5 Lakh+

Interviews

4 Crore+

Salaries

1 Cr+

Users/Month

Contribute to help millions

Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.

Follow us
  • Youtube
  • Instagram
  • LinkedIn
  • Facebook
  • Twitter