I applied through other source. I interviewed at TransUnion in Jan 2023
Interview
Interview process is very smooth. First HR has joined the meeting and then Interview Panel has also joined at given time. First they have introduced themself and then interview started.
Interview questions [1]
Question 1
I have given interview for Data Engineer role at Transunion. They have asked questions on multiple technology, such as Hive, Shell Scripting, SQL, Spark etc. on hive - what are different types of tables in hive?? different fileformats?? difference between Avro and parquet? on HDFS - command to check file size in Hadoop directory? What happens when name node fails? what happen if Data node crashes? On Spark - Difference between repartitions and coalesce? Narrow and Wide Transformation ? Brodcasts and Accumulator in spark?
We had 3 rounds of interview after OA, Technical round,Managerial round and HR round.All the rounds were of medium difficulty and the interviewers were very friendly and made me very comfortable during interview.
There was only general Technical questions about main used technologies in this position, no test or coding, just like basic questions like have you used and can you explain how yo use it on the different technologies, like Python, SQL, Java, Git
I applied online. The process took 4 weeks. I interviewed at TransUnion (Pune)
Interview
Assessment Round - 60 Mins (SQL & Python)
Client Interveiw - 60 Mins (PySpark & Project related discussion)
Unable to clear the client round but was a good experience.
HR were very thorough for giving an updates.
Interview questions [1]
Question 1
Remove duplicates from spark dataframe without using in built function.
Handle null values.
