I applied online. The process took 4 weeks. I interviewed at FHLBank Chicago in Aug 2022
Interview
Three rounds. Easy interviews. First phone call. Second round interview with Hiring Manager. Third round meet the team for 2 hours. I rank the experience negative because I was left waiting around for three weeks while they made their offer to the first choice and basically just kept me as their backup, and it took a lot of following up with HR.
Interview questions [1]
Question 1
Left Join vs Inner Join SQL. Very basic questions related to programming languages on resume. Some questions about mortgages and interest rates and understanding how the bank would make money.
I applied online. The process took 4 weeks. I interviewed at FHLBank Chicago (Chicago, IL) in Aug 2017
Interview
First phone interview with hiring manager asking about general question. Then in-person interviewed with hiring manager about experiences on resume and other analysts about technical questions for the second round. Final round with SVP about experiences on resume.
Interview questions [1]
Question 1
How to use excel pivot table. Write Vlookup and Hlookup