Capital One Sr. Data Analyst interview questions

Both another director in another company's interview and I thought Capital One had some kind of weird interview process. IMO, we can not hire an candidate only by asking several cases or behavioral questions without some "real" challenging questions for this level position (Senior Data Analyst), such as "please compare the algorithms which you have involved in previous data mining models ". (base on my previous working experience and other on-site interviews' questions) And to my HUGE surprise, a manager in statistician said that "I didn't know anything about SQL when I joined capital one after I got my BS degree 7 years ago" , "Capital one has a on-site training program that teaches you this kind of technics", "we only hire the one has analytical thinking". Anyway, I don't want to offense these managers and directors, maybe we have different views about how to be a good candidate. I am not saying a good candidate must be a SQL master. It is your choice whether to be managed by them or not.

Recruiter contacted me about the position I applied online and set up a phone interview. She asked detailed questions about my work experience but in the end said my data analysis experience was not strong enough. And on top of that, they are "looking for people with prior industry experience" which I found contradicting to what they emphasized in the beginning--someone smart and very analytical. Anyway the experience was quick which is good in some way. I think they just don't want to train people instead they are looking for experienced hires.