I applied online. The process took 2 months. I interviewed at Align Technology (Raleigh, NC) in May 2018
Interview
Data modeling pre-test using Excel and Power BI o be completed 4 days prior to the in person interview. The test will be reviewed in the interview where you are asked to explain what you did. Four panel interview taking approx 3 hrs which is part behavioral questions and part technical.
Interview questions [1]
Question 1
Which is better to use in Excel, VLookup or Index/Match?
I applied online. The process took 4 weeks. I interviewed at Align Technology
Interview
HR screen, interview with hiring manager & presentation of take home analysis. Fairly straight forward interview process around technical fit and behavioral fit. Took about a month and a bit on aggregate
Interview questions [1]
Question 1
Technical questions around SQL, in a specific use case, how would you approach coding out an answer