I applied in-person. The process took 4 weeks. I interviewed at Apple (Sunnyvale, CA)
Interview
There were two phone interview and an onsite interview with 5 interviews.
Mostly SQL. The focus is on aggregate functions, window functions etc. There were database design questions also. There programming and data mining questions also.
Overall it was a good experience. All the interviewers were nice. But at the end, the recruiter never told me the results of the interview. Even after mailing her multiple times. Did not expect this unprofessional approach from Apple.
Contacted by a team manager. HR reviewed application and asked to schedule an interview. Made multiple requests to make confirmation following which,\ a tech phone screen was finally scheduled for 30 mins, but it lasted for merely 5 mins (a complete bummer). A team member later contacted for further screening. Didn't hear back for interview confirmation, upon multiple requests, understood that OPT candidates have more 'screenings'. Didn't hear back at all.
Interview questions [1]
Question 1
HR had 5 mins interview call. (instead of scheduled 30 mins)
I applied through an employee referral. The process took 4 weeks. I interviewed at Apple (San Jose, CA) in Oct 2017
Interview
process was good with 7 interviews back to back with different level of interviewers from Senior managers to junior engineers. all of them were from different group with different set of questions.