I applied through a recruiter. The process took 7 weeks. I interviewed at FINRA (Rockville, MD) in Dec 2019
Interview
4 round interview process.
--> 1st round - Take home Assessment : 4 questions
--> 2nd round - Video Interview (45 min to 60 Min interview , technical: SQL questions )
--> 3rd round - In Person Interview ( 6 person panel - interview duration 1.5 hrs). Don't know why 6 people invested 6 * 90 min to interview a contractor.
--> 4th round - They don't even know why they have this round. (Interviewer confessed). During this round, interviewer asked some random questions about relocation and discussed few details about the work that I'll be doing in next 6 months. (Seems like I'll be working on documentation).
Interview questions [1]
Question 1
SQL Questions:
1. Types of joins
2. Aggregate functions when and where to apply. (Given a use case).
3. Do you have knowledge in Stocks, Bonds, Futures etc.,
4. Where do u want to see yourself in next 5 years? (Don't know why they ask this question for a contractor)
5. How would you do business requirement analysis?
