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
J'ai postulé via un recruteur. J'ai passé un entretien chez Citadel
Entretien
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
Questions d'entretien [1]
Question 1
How would you explain a technical concept to a non-technical PM?
J'ai postulé via un recruteur. Le processus a pris 1 semaine. J'ai passé un entretien chez Citadel en janv. 2024
Entretien
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.
Questions d'entretien [3]
Question 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