AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
TransUnion Associate Data Engineer Interview Questions and Answers
TransUnion Associate Data Engineer Interview Experiences
1 interview found
Abushama Siddiqui
(2 Questions)
- 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
- 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
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
Assistant Manager Interview Questions & Answers
HDFC Ergo General Insurance
Anonymous
posted on 29 Jun 2022
I applied via Referral and was interviewed before Jun 2021. There was 1 interview round.
(2 Questions)
- Q1. Family background about
- Q2. Computer skills excel, pivot
Interview Preparation Tips
Interview Questionnaire
7 Questions
- Q1. Tell me about yourself
- Ans.
I am a highly skilled System Engineer with expertise in designing and implementing complex IT infrastructure.
Experienced in managing and troubleshooting network systems
Proficient in virtualization technologies such as VMware and Hyper-V
Strong knowledge of operating systems like Windows, Linux, and Unix
Familiar with scripting languages like PowerShell and Bash
Ability to analyze and optimize system performance
Excellent p
- Q2. How to troubleshoot email outlook related issue
- Ans.
Troubleshooting email outlook related issues involves checking settings, connectivity, and account status.
Check internet connectivity
Verify account settings
Check for updates and patches
Disable add-ins and extensions
Recreate email profile
Check server status
Check for antivirus and firewall settings
Try accessing email from a different device or browser
- Q3. How to diagnose booting related issue
- Ans.
Diagnosing booting related issues involves checking hardware, software, and configuration settings.
Check hardware components such as hard drive, RAM, and motherboard for any issues
Verify that the operating system is installed correctly and up-to-date
Check the boot order in BIOS settings
Use diagnostic tools such as Windows Startup Repair or Linux Boot Repair
Check for any recent software or driver updates that may have c
- Q4. How to assign ip address in window
- Ans.
To assign an IP address in Windows, go to Network and Sharing Center, select the network adapter, and choose Properties.
Open Network and Sharing Center
Click on Change adapter settings
Right-click on the network adapter and select Properties
Select Internet Protocol Version 4 (TCP/IPv4) and click Properties
Choose 'Use the following IP address' and enter the IP address, subnet mask, and default gateway
Click OK to save the
- Q5. How to join system in domain window domain
- Ans.
To join a system in a Windows domain, follow these steps:
Open System Properties and click on the 'Computer Name' tab
Click the 'Change' button and select the 'Domain' option
Enter the name of the domain and provide domain credentials when prompted
Restart the computer for the changes to take effect
- Q6. What is active directory
- Ans.
Active Directory is a Microsoft service that manages network resources and user permissions.
It is used to authenticate and authorize users and computers in a Windows domain network.
It stores information about users, groups, computers, and other network objects.
It allows administrators to centrally manage and deploy software, updates, and policies.
It provides a hierarchical structure for organizing network resources.
It ...
- Q7. Questions related ticking tool
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in Nov 2021. There was 1 interview round.
(1 Question)
- Q1. Fundamentals of SQl and PlSql Aws knowledge
Interview Preparation Tips
Assistant Manager Interview Questions & Answers
National Securities Depository
Anonymous
posted on 26 Dec 2022
Selected
I applied via Recruitment Consulltant and was interviewed in Nov 2022. There were 4 interview rounds.
(1 Question)
- Q1. Technical Cybersecurity related questions
(1 Question)
- Q1. Cybersecurity Process related questions
(1 Question)
- Q1. Salary and negotiation related discussion
Interview Preparation Tips
Assistant Manager Interview Questions & Answers
National Securities Depository
Anonymous
posted on 6 Nov 2024
Selected
I applied via Naukri.com and was interviewed before Nov 2023. There was 1 interview round.
(2 Questions)
- Q1. Basic personal questions
- Q2. Technical questions
Interview Preparation Tips
Assistant Manager Interview Questions & Answers
National Securities Depository
Anonymous
posted on 4 May 2023
Selected
I applied via Referral and was interviewed before May 2022. There were 3 interview rounds.
Math, English, logic, GK
(3 Questions)
- Q1. Tell me about yourself
- Ans.
I am a highly motivated and experienced professional with a passion for leadership and team development.
I have over 5 years of experience in management roles, including leading teams of up to 20 people.
I am skilled in project management, problem-solving, and communication.
I am dedicated to creating a positive and productive work environment, and I thrive on helping my team members reach their full potential.
In my previ...
- Q2. What is your Strength
- Ans.
My strength is my ability to lead and motivate a team towards achieving goals.
I have excellent communication skills that help me convey my ideas and expectations clearly to my team.
I am a good listener and take feedback constructively to improve my leadership style.
I am organized and can prioritize tasks effectively to ensure deadlines are met.
I am adaptable and can handle unexpected challenges with a calm and rational...
- Q3. What is your weekness
- Ans.
I tend to overthink and sometimes struggle with delegation.
I have a tendency to want to do everything myself, which can lead to burnout and inefficiency.
I am aware of this weakness and have been working on delegating tasks to others and trusting their abilities.
For example, in my previous role as a team leader, I struggled with delegating tasks to my team members. However, I learned that by doing so, I was able to empo...
(1 Question)
- Q1. Questions related to Java, Spring, Rest API
Selected
I applied via Approached by Company and was interviewed in Jul 2024. There were 3 interview rounds.
(1 Question)
- Q1. Basic java collection questions
(1 Question)
- Q1. Spring boot basic questions
(1 Question)
- Q1. Why should we hire you
- Ans.
I have a strong technical background, proven track record of delivering high-quality software, and a passion for continuous learning and improvement.
I have a Bachelor's degree in Computer Science and X years of experience in software development.
I have successfully led multiple projects from conception to completion, delivering high-quality software on time and within budget.
I am proficient in a variety of programming ...
Interview Preparation Tips
Share the link for codesignal
(2 Questions)
- Q1. Java related questions
- Q2. Based on the resume
TransUnion Interview FAQs
Tell us how to improve this page.
TransUnion Interviews By Designations
- TransUnion Senior Analyst Interview Questions
- TransUnion Product Owner Interview Questions
- TransUnion Associate Software Developer Interview Questions
- TransUnion Analyst Interview Questions
- TransUnion Software Developer Interview Questions
- TransUnion Java Developer Interview Questions
- TransUnion Data Scientist Interview Questions
- TransUnion Financial Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
- Data Analyst Interview Questions
- Data Engineer Interview Questions
- Data Scientist Interview Questions
- Data Entry Operator Interview Questions
- Associate Data Scientist Interview Questions
- Data Associate Interview Questions
- Associate Data Analyst Interview Questions
- Senior Data Engineer Interview Questions
- Show more
TransUnion Associate Data Engineer Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
TransUnion Associate Data Engineer Reviews and Ratings
based on 1 review
Rating in categories
|
Senior Analyst
230
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Analyst
212
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Developer
159
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Developer Associate
152
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Consultant
112
salaries
| ₹0 L/yr - ₹0 L/yr |
CIBIL
Experian
Equifax
Crif High Mark Credit Information Services
- Home >
- Interviews >
- TransUnion Interview Questions >
- TransUnion Associate Data Engineer Interview Questions
