Ho presentato la mia candidatura tramite un selezionatore. La procedura ha richiesto 2 settimane. Ho sostenuto un colloquio presso Tech Mahindra (Toronto, ON) nel mese di ago 2024
Colloquio
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.
Domande di colloquio [1]
Domanda 1
write python code to check for anagram, what is kwargs in python
surrogate keys in sql
Ho sostenuto un colloquio presso Tech Mahindra (Poona)
Colloquio
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
Domande di colloquio [1]
Domanda 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
Ho sostenuto un colloquio presso Tech Mahindra (Poona)
Colloquio
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.
Domande di colloquio [1]
Domanda 1
total 3 code and some theory questions and projected related scenario base que asked.
Ho sostenuto un colloquio presso Tech Mahindra (Bangalore Rural)
Colloquio
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
