Solicité el puesto a través de un captador. El proceso duró 2 semanas. Acudí a una entrevista en Tech Mahindra (Toronto, ON) en ago 2024
Entrevista
It was a fairly straightforward process, about the technical experience with GCP, coding questions in sql and python, how to load data into bigquery, challenging experiences and how they were overcome.
Preguntas de entrevista [1]
Pregunta 1
write python code to check for anagram, what is kwargs in python
surrogate keys in sql
i recently attended an interview with Tech-mahindara for the role of data engineer role so there are two rounds of interviews 1st are screening and 2nd round is technical discussion round next will be HR round
Preguntas de entrevista [1]
Pregunta 1
Tell me about your current project.
Explain the end-to-end architecture of your project.
What is Medallion Architecture?
Why do we need Bronze, Silver, and Gold layers?
Source Systems & Ingestion
How do you get extracts from source systems?
What is the extraction frequency?
What integration mechanism do you use between source systems and GCP?
How do you load data from GCS to BigQuery?
If you don't want to use Airflow, what alternatives can you use?
Migration
hi, hr got my profile from the naukri and connect with me about my experience and skills set which is align with this position or not and current ctc ans expected cts and total 3 rounds of interview.
Preguntas de entrevista [1]
Pregunta 1
total 3 code and some theory questions and projected related scenario base que asked.
Acudí a una entrevista en Tech Mahindra (Bangalore Rural)
Entrevista
The Interview has gone very clean and the recruiter is very calm and listen and guide us if there is any wrong is there. We can expect easy to medium level Questions
