Me postulé en línea. Acudí a una entrevista en Intercontinental Exchange
Entrevista
I got email of first conducting digital interview. It was 25 mins interviews and you get to practice questions and once you are ready digital interview starts. you get to practice interview in starting and once you are ready , interview starts.
Preguntas de entrevista [1]
Pregunta 1
1. A university has a database tracking student registration for courses, among other data. The three tables for course registration that we are interested in are, STUDENT, COURSE, STUDENT_COURSE.
- STUDENT: Contains STUDENT_ID, NAME, and ADDRESS
- COURSE: Contains COURSE_ID and COURSE_TITLE
- STUDENT_COURSE: Contains STUDENT_ID and COURSE_ID
a) List student ID, name, and course title registered for all students. List should be sorted by student name and then by course title.
b) Write a query to return the student ID and name of all students who have not registered for any courses.
c) A student incorrectly got registered for a PHYSICS course instead of a MATH course. Write an update statement to correct the registration. You have the following details: Student Name = John Doe, Address = Addr1, Current (incorrect) course title = PHYSICS, New course title = MATH
2. Any interesting defect found?
3. How the system works the flow for your application?
4. Difficult project you were successful?
5. Open, edit, save file in unix?
Me postulé a través de un reclutador. El proceso tomó 3 semanas. Acudí a una entrevista en Intercontinental Exchange (Atlanta, GA) en ene 2017
Entrevista
Long process (3 weeks at least). Last round took more than 4 hours... it was intense, but interesting. They combine written test & technical interviews. Everybody is always busy and working on something.
Me postulé en línea. El proceso tomó 2 meses. Acudí a una entrevista en Intercontinental Exchange (Atlanta, GA) en jun 2015
Entrevista
2 phone interviews + 1 face-to-face + skills test. The phone interviews were straight forward. The face to face lasted around 7 hours (1.5 skiils test and lunch included). It was a relay style interview where I met with QA, dev, project management, and other managers. it was a little intense for me. Each interviewer consistently reiterated the expected workload and aggressive schedule.
Preguntas de entrevista [1]
Pregunta 1
I was asked to draw an example of the system i was currently working on. Additionally, I was asked some tricky logic questions.