First friend of mine uploaded my resume in Apple job site, then got a call from recruiter, she schedule phone interview with Hiring Manager, Hiring Manager called me on schedule time asked me to tell about myself, after that she explained they are looking for Project Manager not much into technical more into Managerial job explained she is looking for their internal home grown system enhancements, she asked 2 question on 1. Difference b/w Char and Varchar 2. Joins what is that Joins are used for I answered them and she told me that she want to bring me onsite for face to face interview in Apple campus in Cupertino CA, they schedule 8 interview (Including hiring manager and lunch meeting project manager, other interviewees are 1 Sr. Manager, 2 department heads, 1 technical lead, 2 more project manager ) back to back All of them asked about myself How do you decide database size what are the information you look for. During Project you will notice one of the vendor group is slipping in timeline how do you mitigate this issue Asked what Design patterns using in my projects Asked about while importing data to database what design patterns you will use What is difference XSLD and XSLT Why do not you always use XML format for data import What methodology I am using in my project what are advantage when I said I am using Agile when you handling project in that team from outside vendors are involved what disadvantage agile will have in this scenario. What are the things you will consider for application to service multi language (international) Then Hiring manager told me I do not have Java experience ( in my resume I have clearly mentioned that I have only experience in Microsoft technology) What are non functional requirements that I will consider during the project

felt like they are looking for someone who had the exact same experience before. The hiring manager seemed very bored and actually that intimidated me during the interview. Not behavioral based