Perguntas de entrevista de vagas de Database Developer da empresa Progressive Leasing

I had one of their internal recruiters contact me about 6 months back. I declined the first contact. I was contacted by the same recruiter a second time about 2 months later. My employment situation had changed, so I went ahead and had my resume submitted. I had a phone screen with the manager and all members of the team I was going to work with. It was basically a conference call. The connection was bad for some of the people so I had a hard time understanding the non-native English speakers. I didn't think I did that well, but I was invited to a face-to-face right after the phone screen. The manager kept digging with trick questions, but it wasn't adversarial as it usually is in other companies I've interviewed at. I have both developer and database backgrounds so I got questions from both sides of my experience. I'm fairly senior, so the questions did not seem that hard to me. A more junior person would be hard pressed to answer a lot of the technical questions I was asked. The face-to-face was rather laid back affair. It was the same team. We went into a room and basically got to know everybody in the team. They even had somebody attend through Google Hangouts. I got asked questions about ORMs, and a lot of questions about dimension and fact tables, SSIS, and deadlocks. I got asked the "where is the logic better in; the code or the database?" question. I was surprised that I didn't get any (that I can remember) behavioral questions. At the end of the interview, the group manager gave me a tour. After the tour, I got to shoulder-surf a few of the team members. This whole process was longer than the run of the mill interviews at other companies. I ended up spending two and a half hours at their office for the face-to-face.