Santa Clara Family Health Plan Interview Questions
& Process
Real candidates share what happened, how many rounds they had,
and how the experience turned out.
Based on 13 interview experiences · FREE TO READ
Which role are you interviewing for?
6 roles · 13 reportsCandidate interview experiences
First-hand accounts from people who interviewed at Santa Clara Family Health Plan.
Santa Clara Family Health Plan
Data Analyst
Entry Average Positive experience No offer 1 round
Interview process
Technical screen
Interview formats
Technical Behavioral
It was a one-hour interview with three interviewers who took notes as I answered. The first 30 minutes were focused on SQL, and the next 30 minutes involved a discussion about my experience and some technical questions.
Confirmed questions3 questions
- Can you tell us why you want to work here?
- What made you decide to pursue a career as a Data Analyst?
- Can you explain how you've utilized indexing?
Santa Clara Family Health Plan
Program Manager
Mid Average Negative experience No offer 2 rounds
Interview process
Phone screen Panel
Interview formats
Behavioral
The interview process was quick and only 2 rounds (first was a phone screen, second was a panel interview with 3 individuals). Interview was going well, but they asked the same question in different forms. The director decided to go on her phone towards the end which was highly unprofessional and it gave me a reason to realize it isn't a work environment I would thrive in. 3 weeks went by before I emailed HR to ask (mainly as a courtesy since they should have emailed) and they send an automated reply. In my opinion, the company lacks professionalism in the interview space.
Confirmed questions1 question
- Tell me about a time you had to juggle multiple tasks and decide which ones to focus on first.
Santa Clara Family Health Plan
Business Systems Analyst
Mid Average Neutral experience No offer 2 rounds
Interview process
Recruiter call Technical screen
Interview formats
Technical Coding
I applied online via Indeed and had two interview rounds. The first was a phone screening with the Hiring Manager. The second round was a technical screening focused on SQL, conducted by the hiring manager and another manager. They gave me remote access to a database with 3-4 tables, and I had 40 minutes to write about 6-7 SQL queries. I answered about 80-90% correctly. No other questions were asked. A few days later, I got a rejection email from HR. I was disappointed because I was expecting a third round.
Confirmed questions4 questions
- Could you write an SQL query that joins three tables?
- Using MIN/MAX functions, how would you find the youngest patient?
- How would you determine the count of patients who were active during 2019?
Santa Clara Family Health Plan
Application Developer
Mid Average Neutral experience No offer 3 rounds
Interview process
Recruiter call Phone screen Technical screen Onsite Background check
Interview formats
Technical Behavioral Other
The hiring process was a bit drawn out. It started with an HR phone screen. Following that, there was an hour-long technical interview focused entirely on SQL, which was enjoyable despite a shaky RDP connection. The next step was a panel interview with several managers. The CTO asked a lot about my willingness to work extra hours, like nights and weekends. Finally, they requested references. It seems the HR contact asking for references had a less-than-stellar interaction with two of my references, who mentioned she asked quite a few odd questions.
Confirmed questions2 questions
- The technical interview involved SQL and reading data with .NET, and it was open book.
- The panel interview was mostly fine, but I think they were looking for me to confirm I'd work late or on weekends.
Santa Clara Family Health Plan Interview Questions
Quoted word for word from Santa Clara Family Health Plan interview reports.
“What is the difference between Medi-Cal and Managed Care Medi-Cal?”
Read reports →“Using MIN/MAX functions, how would you find the youngest patient?”
Read reports →“What is the count of claims that were denied?”
Read reports →“How would you determine the count of patients who were active during 2019?”
Read reports →“What are Tableau IF THEN statements?”
Read report →“Given a database of heirs, write SQL queries to retrieve specific data as requested by each question.”
Read report →“Could you write an SQL query that joins three tables?”
Read report →“Can you explain SQL joining tables?”
Read report →“Can you code through remote access?”
Read report →Formats, difficulty and experience
Across all 13 Santa Clara Family Health Plan interview reports.