First round of interview purely technical
Pyspark
Explain RDD
Can you create New RDD from existing RDD
How to optimise spark jobs
Sql
Explain CTE function in sql
Remove duplicate rows
I applied through a recruiter. The process took 2 weeks. I interviewed at Tech Mahindra (Gurgaon, Haryana) in Mar 2025
Interview
There were 3 rounds in total. First round for Technical which was medium and contained questions related to spark, python and AWS services. Second was a client round again technical round and level was again medium followed by a HR round.
Interview questions [1]
Question 1
What is the difference between Aws EMR and Aws Glue. What is the use case where you will use EMR instead of AWS Glue
I applied through other source. The process took 2 weeks. I interviewed at Tech Mahindra in Nov 2024
Interview
I have given two technical rounds.
They asked me about project,
roles and responsibilities in the project.
And questions on AWS, python and SQL coding questions. Interview is easy.
And also PySpark questions, window functions row number, rank, dense rank in SQL .