Ho sostenuto un colloquio presso Oak Street Health
Colloquio
Questions from manager. I think a code exam was planned but didn't happen because I answered all the questions correctly. Then a take-home test to design a data flow architecture.
Domande di colloquio [1]
Domanda 1
Clustered vs Non-clustered index? Schema changes? Incremental loads?
Ho presentato la mia candidatura tramite un selezionatore. La procedura ha richiesto 2 settimane. Ho sostenuto un colloquio presso Oak Street Health nel mese di ago 2023
Colloquio
I was approached by someone on LinkedIn and submitted my profile wherein I was invited to begin a 4-step interview process which was communicated to me would begin with a HR culture-fit interview, followed by a more technical conversation with the hiring manager, then a case-study presentation, and a final round with a manager of sorts. My first round was a technical interview which was rescheduled, and involved someone who asked the generic questions, and then gave me a coding exam. The coding language wasn't one that is on my profile, but I was told to go ahead and do it in whichever language I felt most comfortable. At this point I still have no idea what the role entails because the interviewer ended the meeting on time, without giving me the chance to ask any questions. The next day I was invited to their case study interview, which reads as an issue they currently have and have yet to solve. Feels like they interview people to get the answer to a problem they currently have.
Domande di colloquio [1]
Domanda 1
Explain the difference between direct table joins and fuzzy logic.
Ho presentato la mia candidatura tramite un selezionatore. La procedura ha richiesto 3 settimane. Ho sostenuto un colloquio presso Oak Street Health nel mese di dic 2022
Colloquio
There were three interviews. Two of which were with lead data engineers, one with product manager over two to three weeks. It was a very slow process.
Finally let me know they wanted someone with PySpark experience, which, if they would have reviewed my resume beforehand, could have saved us both many hours,
Domande di colloquio [1]
Domanda 1
Incremental processing, Data Factory integration runtimes, MPP database performance, connections in python, indexing. Ways to integrate disparate data sources.