TransUnion Software Developer interview questions

Hiring Process has 3 different rounds first round is online test which covers quantitative, logical ,reasoning ,coding questions and the next round is technical round and then followed by HR interview.

Questions are technical but the topic depends on the subject of interest of the candidate yet technical computer science questions. Introduce yourself Explain About your projects. Which programming languages u are comfortable with C/C++/Java/Python? From where do you want to ask your question, C/C++/Java/Python? Explain different searching and sorting techniques with time complexity. write Python program for merge sort? How comfortable are you with SQL? What is a primary key? What is a unique key? How are these two different? What is meant by referential integrity constraint? What are stored procedures in SQL? Which statements can be rollback? SQL Query for the highest salary of an employee without using the where clause? What are the different types of join used in SQL? Explain them. How would you rate yourself in SQL? Ok, so How good are you with Cloud? Out of 45 students, 18 were selected for the next round (HR). HR Interview Tell me about yourself. what are your key achievements? Talk about your extracurriculars and responsibilities. how can you rate yourself as a team member? speak about your strengths and weakness? Do You have any questions to ask? Out of 18 students, 5 were offered