
Civitas Learning Data Engineer Interview Questions
& Process
Real candidates share what happened, how many rounds they had,
and how the experience turned out.
Based on 5 interview experiences · FREE TO READ
Candidate interview experiences
First-hand accounts from people who interviewed at Civitas Learning.
Data Engineer
The HR person was really professional and responsive. First, there was a phone interview with HR, then a phone technical interview, and then four on-site interviews all in one day. It wasn't too hard or stressful, and the interviews seemed to go well. I really thought I'd get an offer. I'm over 40 and most of the team seemed to be in their 20s. I'm fine working with younger people so that didn't bother me. I was a bit surprised when the two young guys interviewing me said it was important that I was a good "cultural fit" and wanted to know if I'd be up for attending their weekly game night at their apartments. It was awkward. I was surprised when they passed on me. And a bit suspicious since a friend of mine who is equally qualified was turned down for the same job a year ago. She is also over 40. But I thought about it for 10 minutes and moved on. However, today Civitas turned down another of my "not young" highly-qualified friends. It's not a salary thing because we all talked about salary on the first call. I'd say if you're over 35, save your energy.
- Will you attend our weekly game night?
Data Engineer
Started with an HR recruiter phone screen. Then, about a week later, I had a technical phone interview with the director focusing on SQL. Another week passed, and I was set for a half-day onsite interview. This onsite was split into 5 parts, including whiteboarding exercises and a practical SQL test. I'm confident I nailed all the questions. However, I didn't get an offer due to concerns about my command line SQL skills, which honestly felt like an insult. I heard they used the same excuse for two other SQL/ETL experts. I suspect this young, trendy company might be ageist, as everyone seemed under 35.
- Can you discuss schema design?
- Explain SQL to me as if I have absolutely no prior knowledge.
Data Engineer
One of the best experiences I had. First, a screening call. Then, a video call with the manager, covering general questions and previous experience. Third, a technical interview on data modeling and SQL, which was quite straightforward, focusing on SQL basics. Fourth, an interview with all the data engineering team members where I was asked situational and behavioral questions like 'Tell me about a time you disagreed with a teammate's idea,' etc.
- For data modeling, you are given a situation and need to create the SQL entity schema: basic SQL knowledge. The 'difficult' part is using PARTITION BY, RANK(), ROW_NUMBER, and that's the extent of the difficulty.
Civitas Learning Data Engineer Interview Questions
Quoted word for word from Civitas Learning interview reports.
“What is the meaning of SQL?”
Read reports →“Write queries on your data model.”
Read reports →“Will you attend our weekly game night?”
Read reports →“Create a data model based on a business requirement.”
Read reports →“Explain SQL to me as if I have absolutely no prior knowledge.”
Read report →“Solve some SQL problems.”
Read report →“Can you design a data model given a business requirement to support its needs?”
Read report →“Can you discuss schema design?”
Read report →Formats, difficulty and experience
Across all 5 Civitas Learning interview reports.