I applied online. I interviewed at Tech Mahindra (Pune) in Aug 2024
Interview
Getting Start with Intro , Project, Work, Python, SQL , Pyspark and technical Engineer Questions, Project Overlap, Data Brick, Azure Data Lake, Azure Data Factory, Power Bi , Airflow, Snowfall, Python Fundamental, SQL Basic
Interview questions [1]
Question 1
Give me Over view of azure Data Factory and Data Bricks
I applied through an employee referral. The process took 4 weeks. I interviewed at Tech Mahindra in Dec 2024
Interview
I applied through a referral and went through the following interview process:
1. Technical Round (1 hr) – Covered SQL (medium difficulty) same question to be solved in PySpark, Azure-related questions mostly on Databricks, Datafactory and Data warehousing.
2. Technical/HR Round (1 hr) – Focused on scenario-based questions, Spark internals, and a basic discussion with team manager, project lead.
3. Client Round(45mins) - situational questions, general discussion.
The client round took place after two weeks. HR was very helpful and supportive throughout the process.
Interview questions [1]
Question 1
4 dim tables should be joined with a fact table to give an aggregated result both in SQLand Pyspark.