Questions on sql - then a hr interview - didn’t go past that. Guess I wasn’t a good fit for the role as didn’t have the experience necessary in terms of years
Ho presentato la mia candidatura tramite un selezionatore. Ho sostenuto un colloquio presso Citadel
Colloquio
First sent a hacker rank, followed by hr interview about my motivations, and then had an interview by a member of the team. Afterwards I was given a case study to complete over a weekend
Domande di colloquio [1]
Domanda 1
How would you explain a technical concept to a non-technical PM?
Ho presentato la mia candidatura tramite un selezionatore. La procedura ha richiesto una settimana. Ho sostenuto un colloquio presso Citadel nel mese di gen 2024
Colloquio
A recruiter from Citadel reached out directly over LinkedIn.
1st stage was the call with the recruiter to talk about experience and a match to the role
2nd stage was a HackerRank test, which I failed. They expect all questions to be completed.
The test had 2 SQL and 1 Python question. The Python question had 3 parts. I've completed all SQL questions and 2 parts from the Python question then ran out of time. So failed the test.
Domande di colloquio [3]
Domanda 1
Write an SQL query to return associated entities with a specific ids.
Perform some data cleaning in pandas - filtering out rows which don't match a specific criteria, adjust a string column to keep only alphanumeric character. Finally create some dummy columns