Ho presentato la mia candidatura online. Ho sostenuto un colloquio presso Tech Mahindra (Poona) nel mese di ago 2024
Colloquio
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
Domande di colloquio [1]
Domanda 1
Give me Over view of azure Data Factory and Data Bricks
Ho presentato la mia candidatura tramite segnalazione di un dipendente. La procedura ha richiesto 4 settimane. Ho sostenuto un colloquio presso Tech Mahindra nel mese di dic 2024
Colloquio
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.
Domande di colloquio [1]
Domanda 1
4 dim tables should be joined with a fact table to give an aggregated result both in SQLand Pyspark.