The process took 4 weeks. I interviewed at GEICO in Jan 2024
Interview
Recruiter phone screening and questionnaire. Online assessment then 1 hour 30 minute final interview. 1 hour for technical, 30 minutes for behavioral. 2 business days to hear back from interview.
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..
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.
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
