Capital One Software Engineer interview questions

Q1: Bunch of standard behavioral questions. Talk about a time when... questions. Q2: Case question: Capital One acquired an online bank IGN. What are the business/tech benefits of this acquisition? What are the challenges? They asked me to walk through a snippet of code and determine what it was doing. It was a function to determine "eligibility" for an offer to customers. 3 Variables into a function that had a bunch of cascading if/else statements - some were redundant. You need to make a truth table to figure it out. Then analyze the output of the truth table and refactor the code into a few lines. Q3/Q4: Technical background questions. They asked me mostly about my background and the things on my resume. Then quizzed me on questions like - what would you do if you had this table and wanted to get the second-highest value in this column how would you write the query? You have data in s3 file how do you update some of the values in s3 efficiently? How do you deal with spark driver-worker memory? What is a DAG in spark? Difference between GroupByKey and ReduceByKey? My interviewer said she tried to be a data scientist but it was "too hard" and then asked me DS algorithm questions which I answered to a level of detail she probably didn't have the knowledge on and she seemed impressed. She asked me about gradient boosting, how to tune an algorithm, what my favorite algorithm was. Asked me about SQL window function if I ever used one. I was pretty surprised I didn't get an offer because I answered almost all questions with good level of technical knowledge but if you go on Reddit and search for the capital one you'll find out they are a "fake" tech company and they've rejected plenty of candidates that got offers from real tech companies. They are looking for people who will drink the cool-aid. I asked my interviewer where they are in terms of automated deployments and he said they have a good portion of manual deployment and people doing SQL updates/inserts as a process. That sounds like a "real" tech company to me!

How many numbers can you represent in n bits