I applied through an employee referral. The process took 3 weeks. I interviewed at GEICO
Interview
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.
I applied through an employee referral. The process took 1 week. I interviewed at GEICO (Plano, TX) in Oct 2024
Interview
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..
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.
Interview questions [1]
Question 1
String manipulation functions
Window functions
Rank and dense_rank
Simple python questions with time and space complexity