Apple Data Engineer interview questions

If you want to waste your time and be heckled by a bunch of snobs, do interview here. The recruiter doesn't tell you anything about who's gonna interview you or what you are gonna be interviewed on. They just tell you that there are going to be x number of rounds from 9 AM to 3 PM. The first round was with the hiring manager, he seemed nice and we talked about things I have worked on. The second round was with a Data Engineer on the team. Solved a few programming questions. Up until this time, I haven't been clearly told what the team's working on due to privacy concerns, which I get. Then I was invited onsite. I was encouraged to ask questions by the recruiter during my onsite interview to my interviewers. On the day of the onsite, we start with a coding round, then a data design round. The next one is with the hiring manager and another manager from some team. It was more of a discussion and I was asked if I had any questions. I started asking about something that I had read in the news and if it was related to what this team works on. They said no. Then the manager from the other team asked why I asked about that research. I simply stated it seemed interesting and I would have loved to work on that. He just wouldn't let it go. We switched topics to other areas of interest. But the other guy kept coming back to why I asked about it. I finally said that since you are Apple Health team, so it would seem logical that you would be related to the research in that space. He replied in a very condescending tone - "We are not the only Apple Health team". How am I supposed to know that. Or any outsider is supposed to know that. The next round was with a Software Engineer at Apple. He started with asking questions about python concepts. Then we moved onto coding. As I was trying to work through the algorithm, I was constantly heckled by the interviewer on things like the variable name, the flow and not starting with the edge cases before the general case. Overall, it was an extremely unpleasant and frustrating experience. And a complete waste of time!

Applied in job portal of Apple. The first call from HR to schedule telephonic interview. The telephonic interview was at right time so be sure to be ready. Need to be ready with computer, internet, pen paper. The question based on experience in field. SQL is must so be ready for answering the select statement. AWS Redshift and Spark, their importance and why to use them and their function in depth.