Tech Mahindra Senior Analyst Interview Questions and Answers for Experienced

Types of joins in SQL include inner join, left join, right join, and full outer join.

• Inner join: returns rows when there is at least one match in both tables

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

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

• Full outer join: returns rows when there is a match in one of the tables

I have over 5 years of experience in data analysis, focusing on financial modeling and market research.

• Led a team to develop a financial forecasting model that improved accuracy by 20%.

• Conducted market research that identified new customer segments, resulting in a 15% increase in sales.

• Utilized SQL and Python for data extraction and analysis, streamlining reporting processes.

• Presented findings to senior management, inf...read more