I applied online. I interviewed at Fidelity Investments (Raleigh, NC) in Jun 2020
Interview
Due to covid , all the process is online. First round is video HR interview of about 10-15 minutes which goes very smooth and second round is technical interview of about half an hour.
Interview questions [1]
Question 1
What is the structure of a SQL query?
How do we transfer data from amazon s3 to amazon DynamoDB?
If cluster, network everything is good and the SQL query is running very slow then what will you do to enhance the performance?
I applied through an employee referral. I interviewed at Fidelity Investments in Mar 2018
Interview
I applied to the LEAP Program through a reference. I had one phone interview before being moved to the final round interview. After the final round interview, I was told that they had made the decision to hire me but ran out of spots, therefore being "waitlisted". They said I was in the first position, so if any demand changes, withdraws, etc occur I would be made an official offer. They ended up having me "waitlisted" until the actual day I graduated. Luckily, I had several other offers from much better ran companies that wouldn't do this, and I had accepted an offer well before they were able to give me answer. There seems to be a lot of internal health problems in this company, especially in the technology department. I would only recommend working here if salary is your first priority; they seem to pay their entry-level technology employees pretty well. But they lack organizational health, career advancement opportunities, and culture. Your skills and time are better spent somewhere else.
Interview questions [1]
Question 1
Describe the database schema of a website (they ask in you in an earlier question for your favorite website, so they can quiz you over the structure)
I applied through college or university. The process took 2 days. I interviewed at Fidelity Investments (Mysore) in Oct 2016
Interview
The initial process had an online exam with negative marking. Then it was followed by 3 rounds of interview.
i)technical interview
ii) Behavioural interview
iii) HR Round
The initial process had an online exam with negative marking. Then it was followed by 3 rounds of interview.
i)technical interview
ii) Behavioural interview
iii) HR Round