I applied online. I interviewed at Intercontinental Exchange
Interview
I have given only 1 round as of now and it has been good. This round was telephonic and lasted an hour. I am hoping to receive further feedback or decision after this round.
Interview questions [1]
Question 1
The questions were based on their own requirement which was Python, SQL, Linux, and QA.
I applied online. The process took 4 weeks. I interviewed at Intercontinental Exchange
Interview
Interview process took a month, it started of with a call from recruiter and then phone interview with an Engineer(basic questions about sql, java) and face to face interview which they say will be for 4 hours but it lasted 6 hours, rather than interview questions, the process is really exhausting and they make you sit in a room and people keep on coming one after another and ask questions on the fly, they won't provide you any lunch even though the interview extended beyond agreed time, No feedback after the interview. They mostly want to know if you are willing to work longer hours.
Interview questions [1]
Question 1
Questions about basic java, sql and small coding assignments on white board, behavioral questions.
I applied through a recruiter. The process took 1 week. I interviewed at Intercontinental Exchange (Chicago, IL) in Nov 2017
Interview
I was presented with the opportunity via a recruiting agency. Since I worked through a recruiter, they did not require a phone screen and had me come in for the final interview. There were 4 people from the RM team who interviewed me. One was the director who I would be reporting to, another was the manager of the team, and lastly, the other two were team members. I was first asked to speak about my previous position and what I did there. This took about 5 minutes. After this, I had to complete four problems on a whiteboard. I will list the three problems that I remember below in the Interview Questions section. After I finished answering the problems, I was asked a few more specific questions regarding the responsibilities I had from my previous job. The next day I heard back from the recruiter saying that the interview went well and that he had received positive feedback. Another day later I was presented with an offer which I ultimately accepted.
Interview questions [3]
Question 1
Two SQL tables with students’ names and IDs were present. Both tables consisted of two columns. Both tables had an ID field which linked them together using a primary key. One table had student names while the other had cities the students were from.
Query all students’ names that begin with the letter “m”
What is a primary/foreign key?
Create a third table with the students’ zip codes and link this table to the other two tables (HINT: Use ID as the foreign key)
Write pseudo code that will print two letters on each line with the first letter not moving to the next until the following letter reaches the end of the alphabet (the letter Z):
AA
AB
AC
.
.
.
ZX
ZY
ZZ