Contracting Role. One interview with hiring manager. General Database Design concepts. 2 nd round was more technical. I had to write SQL queries. If you are good on LeetCode etc you should be fine.
Interview questions [1]
Question 1
What is SCD1 and SCD2? SCD== Slowly changing Dimension
I applied through a recruiter. The process took 4 days. I interviewed at Kaiser Permanente (Pasadena, CA) in Jun 2014
Interview
-The process intially started with a phone screen with the manager
-Setup onsite interview the same week
- interviewed with manager and two other people. I was asked a few SAS - technical questions, and understanding of clinical data review. The entire interview lasted about 90 minutes total
Interview questions [1]
Question 1
-Knowledge and comfort level with SAS Base/Advanced
-Utilization and development of Macros