Taro Logo

DevOps/Release Management Analyst Interview Interview Experience - Chicago, Illinois

November 1, 2017
Positive ExperienceGot Offer

Process

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.

Questions

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

Write a bash script that takes a path as a parameter and writes the current size of the directory at that path to a file

Was this helpful?

Interview Statistics

The following metrics were computed from 1 interview experience for the Intercontinental Exchange DevOps/Release Management Analyst Interview role in Chicago, Illinois.

Success Rate

100%
Pass Rate

Intercontinental Exchange's interview process for their DevOps/Release Management Analyst Interview roles in Chicago, Illinois is incredibly easy as the vast majority of engineers get an offer after going through it.

Experience Rating

Positive100%
Neutral0%
Negative0%

Candidates reported having very good feelings for Intercontinental Exchange's DevOps/Release Management Analyst Interview interview process in Chicago, Illinois.

Intercontinental Exchange Work Experiences