TransUnion Interview Questions, Process, and Tips for Experienced

Q1. Job related questions without giving me time to respond
Add your answer

Q1. Talking over me and not listening to my response
Add your answer

Q1. Interview questions were based on the technologies where i have worked upon earlier .
Add your answer
Q2. Coding questions were asked
Add your answer

Q1. Project based questions
Add your answer

Q1. Expectations and details about the company culture
Add your answer

Q1. What is regression
Ans. 
Regression is a software testing technique used to ensure that new code changes do not negatively impact existing functionality.
• Regression testing involves re-running previously executed test cases to verify that new code changes have not introduced any new bugs or issues.

• It helps ensure that the software continues to function correctly after modifications.

• Regression testing can be automated to save time and effort.

• Exa...read more
Answered by AI
Add your answer

Q1. How do you remove duplicates in sql
Ans. 
Use the DISTINCT keyword in a SELECT statement to remove duplicates in SQL.
• Use the DISTINCT keyword in a SELECT statement to retrieve unique rows

• Use GROUP BY clause with aggregate functions like COUNT() to remove duplicates based on specific columns

• Use ROW_NUMBER() function with PARTITION BY clause to remove duplicates and keep only one row
Answered by AI
Add your answer
Q2. Explain the different joins in SQL
Ans. 
Different types of joins in SQL include inner join, outer join, left join, and right join.
• Inner join: Returns rows when there is a match in both tables

• Outer join: Returns all rows when there is a match in one of the tables

• Left join: Returns all rows from the left table and the matched rows from the right table

• Right join: Returns all rows from the right table and the matched rows from the left table
Answered by AI
Add your answer

GD on previous experience, skillset, projects, educational background, guesstimates between candidate, team manager, and team lead

SQL coding round, 5-6 queries were asked

Case study on SQL and Excel

Q1. Questions from SQL,UNIX,PYTHON,AWS
Add your answer

Q1. Current Project
Ans. 
Currently working on analyzing customer data for a retail company.
• Analyzing customer purchase history

• Identifying trends and patterns in customer behavior

• Segmenting customers based on demographics and purchase preferences
Answered by AI
Add your answer

Q1. Expected Salary,Process, Offer letter
Add your answer