UST Associate Lead Interview Questions and Answers

6 Questions on SQL queries involving different joins, aggregations etc.

Q1. More than 90 minutes of questions on the same 6 SQL Queries asked in the first round
Add your answer

Average to easy difficulty level.

Q1. Java code of string manipulation
Add your answer
Q2. What is the Java code for various types of sorting algorithms?
Add your answer
Q3. Sql query and topics related to joins.
Add your answer

Q1. About yourself and family
Add your answer
Q2. What do you know about the company?
Add your answer
Q3. Can you provide examples of real-life scenarios where you handled conflicts with either a colleague or a manager?
Add your answer
Q4. What actions would you take if your manager does not approve your product idea, and how would you attempt to persuade them?
Add your answer

Q1. All about angular framework and Typescript
Add your answer
Q2. Javascript precoded question
Add your answer

Q1. In this round as well as Angular related question
Add your answer
Q2. Lifecycle hook of angular
Ans. 
Lifecycle hooks in Angular are methods that allow you to tap into the lifecycle of a component or directive.
• Lifecycle hooks include ngOnInit, ngOnChanges, ngDoCheck, ngOnDestroy, etc.

• ngOnInit is used for initialization logic, ngOnChanges is used for reacting to input changes, ngOnDestroy is used for cleanup tasks, etc.

• Example: ngOnInit() { console.log('Component initialized'); }
Answered by AI
Add your answer
Q3. Lazy loading concept
Add your answer

Self introduction
Next assessment if select in first round

Versant round..consists of voice test, typing, mail writing

Q1. Self intro Any topic which in resume or manager will give you the topic General questions will be asked..vary from person to person
Add your answer

Q1. Tell me about yourself?
Ans. 
I am a detail-oriented individual with a strong background in data analysis and process improvement.
• I have a Bachelor's degree in Business Administration with a focus on operations management.

• I have experience working as a data analyst, where I improved efficiency by streamlining processes.

• I am proficient in Excel, SQL, and data visualization tools like Tableau.

• I am a quick learner and enjoy taking on new challenges.
Answered by AI
Add your answer
Q2. Which is the most memorable day in your life?
Ans. 
The day I graduated from college
• Feeling of accomplishment after years of hard work

• Celebrating with friends and family

• Reflecting on the journey and looking forward to the future
Answered by AI
Add your answer

Q1. Voice based question through a software
Add your answer

Q1. Tell me about yourself?
Ans. 
I am a detail-oriented individual with a background in data analysis and strong problem-solving skills.
• Graduated with a degree in Business Administration

• Worked as a data analyst for XYZ Company

• Proficient in Excel and data visualization tools

• Strong analytical and problem-solving skills

• Excellent attention to detail
Answered by AI
Add your answer
Q2. How was your last birthday?
Ans. 
My last birthday was spent with close friends and family, enjoying a delicious meal and exchanging thoughtful gifts.
• Celebrated with close friends and family

• Enjoyed a delicious meal

• Exchanged thoughtful gifts
Answered by AI
Add your answer
Q3. Are you comfortable with night shifts? Have you discussed this in your family?
Ans. 
Yes, I am comfortable with night shifts and have discussed it with my family.
• I am comfortable working night shifts as I have done so in previous roles.

• I have discussed the possibility of working night shifts with my family and they are supportive.

• I understand the importance of maintaining a healthy work-life balance even with night shifts.
Answered by AI
Add your answer
Q4. How was your day today? What did you observe throughout the day?
Ans. 
My day was busy but productive. I observed a lot of teamwork and collaboration among colleagues.
• Started the day with a team meeting to discuss goals and priorities

• Worked on various tasks with different team members throughout the day

• Witnessed effective communication and problem-solving skills in action

• Noticed a positive and supportive work environment
Answered by AI
Add your answer

Q1. Find largest and smallest from an array
Add your answer
Q2. Reverse an array
Add your answer
Q3. Print your name in reverse
Add your answer

Q1. Thread questions
Add your answer
Q2. Design patterns
Add your answer

Q1. LLD Design of any popular ecommerce
Add your answer
Q2. HLD Design of any popular ecommerce
Add your answer