The HR directly scheduled for technical interview without a introductory call. There were 3 folks questioning on SQL, DW concepts and python. The SQL questions were more theoretical like what string manipulation functions do you know, what is a window function.
Domande di colloquio [1]
Domanda 1
String manipulation functions
Window functions
Rank and dense_rank
Simple python questions with time and space complexity
Ho presentato la mia candidatura tramite segnalazione di un dipendente. La procedura ha richiesto una settimana. Ho sostenuto un colloquio presso GEICO (Plano, TX) nel mese di ott 2024
Colloquio
It was a Pretty good experience . Total 5 interviews. 3 Technical 2 behavioral. SQL- medium leetcode. Behavioral- tell me a time you did X in a previous role. Very smooth experience..
Ho presentato la mia candidatura tramite segnalazione di un dipendente. La procedura ha richiesto 3 settimane. Ho sostenuto un colloquio presso GEICO
Colloquio
Questions were straight forward. Mostly questions on SQL and some questions on describe the process of creating a data pipeline in DBT. no programing related questions. The rest are questions are generic such as how you handle working with other team members.
