I applied through a recruiter. I interviewed at TransUnion (Chennai)
Interview
1. Phone screener round
2. PPT preparation for the given case study
3. Technical round (SQL basics to intermeditae)
4. Case study round (Present the PPT prepared)
5. HR discussion
Interviewed with the technical recruiter. It was good. I sensed some hesitation around changes about mergers and acquisitions that recently happened with the company.
Later week I was sent schedule technical interview. Even sent a reminder a day before. On the day of interview, I joined the team link sent to me and I waited and waited and waiter. Interviewer was a no show. I texted the recruiter, who has been pretty good about responding the other day, of course did not reply. Very unprofessional.
Interview questions [1]
Question 1
simple- why do you want to work here. Reason for leaving previous company, etc.
Interviewer asked very conceptual and project based questions. 2 SQL queries, questions of spark based on day to day use and debugging skills. some questions were bit unusual and need very in-depth understanding.
Interview questions [1]
Question 1
1. When does the driver is performing as executor.
2. How to ensure broadcast join without writing a single code.
3. Daily Petabyte of code then how to ensure that back date calculations you can do easily without delay.
4. How do you debug the spark app.
5. What does your driver do ? any instance where driver did something?
6. What all is there in driver and executor logs?
7. Was OCI Data Flow server or cluster based?