The first round was great and get into the second round case interview. The interviewer gave the positive feedback but got rejected two weeks later. Have no idea what happened. If you are in that interview, remember to ask numbers before construct the frame work
Ho presentato la mia candidatura online. La procedura ha richiesto 2 settimane. Ho sostenuto un colloquio presso Frontier nel mese di ott 2021
Colloquio
1st round 30 minute video interview. My interviewer was pleasant, and explained the role well. Asked me some simple questions about my resume. We chatted a bit, and I left having a good impression. Got a rejection e-mail a few days later, they didn't explain why I didn't get the role.
Domande di colloquio [1]
Domanda 1
What is the difference between a LEFT JOIN and INNER JOIN?
Ho presentato la mia candidatura online. La procedura ha richiesto 3 settimane. Ho sostenuto un colloquio presso Frontier (Dallas, TX) nel mese di ago 2021
Colloquio
Phone interview screen, then 3 rounds of interviews that were a mix of behavioral and technical. Technical being like common interview brain teasers or business case scenarios. Interviews did not having and whiteboard coding in SQL or python.
Domande di colloquio [1]
Domanda 1
you have 9 balls that all look identical from the naked eye. 1 of the balls is the same weight as the other 9. You also have a scale that you can use twice. How do you find the unique ball?