AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
TO THE
NEW
Compare
Filter interviews by
TO THE NEW Associate Technical Leader Interview Questions and Answers for Experienced
TO THE NEW Associate Technical Leader Interview Experiences for Experienced
4 interviews found
Anonymous
(5 Questions)
- Q1. Difference between first() or FirstOrDefault()
- Ans.
first() returns the first element of a sequence, while FirstOrDefault() returns the first element or a default value if the sequence is empty.
first() throws an exception if the sequence is empty, while FirstOrDefault() returns a default value (e.g. null) in that case.
Use first() when you expect the sequence to always have at least one element, and FirstOrDefault() when the sequence might be empty.
Example: var numbers =...
- Q2. Left join vs right join
- Ans.
Left join includes all records from the left table and matching records from the right table, while right join includes all records from the right table and matching records from the left table.
Left join: includes all records from the left table and matching records from the right table
Right join: includes all records from the right table and matching records from the left table
Example: Left join - SELECT * FROM table1...
- Q3. Optimization of SQL query
- Ans.
Optimizing SQL queries involves using indexes, minimizing joins, and avoiding unnecessary columns.
Use indexes on columns frequently used in WHERE clauses
Minimize the use of JOIN operations
Avoid selecting unnecessary columns in the query
Consider using stored procedures for frequently executed queries
- Q4. Tool used to check query slowness
- Ans.
One tool used to check query slowness is SQL Server Profiler.
SQL Server Profiler can be used to trace and analyze query performance.
It provides detailed information on query execution, including duration, reads, writes, and more.
Users can identify slow queries and optimize them for better performance.
Other tools like Query Store in SQL Server Management Studio can also be used for monitoring query performance.
- Q5. Design repository pattern using EF core
- Ans.
Repository pattern using EF core for data access layer
Create an interface for the repository with generic CRUD methods
Implement the repository interface with EF core for data access
Use dependency injection to inject the repository into services
Separate concerns by having repositories handle data access logic
Skills evaluated in this interview
Nishant Singh
I applied via Recruitment Consulltant
(2 Questions)
- Q1. Well architect framework
- Q2. 3 tier arch questions
Selected
I appeared for an interview before Apr 2024, where I was asked the following questions.
- Q1. Android, Java, Kotlin, DS
- Q2. General HR round
(1 Question)
- Q1. Basic Java Questions
(1 Question)
- Q1. SQL based questions were there
Interview Preparation Tips
Top trending discussions
Interview questions from similar companies
I applied via Naukri.com and was interviewed before Mar 2020. There were 4 interview rounds.
Interview Questionnaire
4 Questions
- Q1. Difference between Hashtable and hashmap?
- Ans.
Hashtable is synchronized while hashmap is not.
Hashtable is thread-safe while hashmap is not.
Hashtable does not allow null keys or values while hashmap allows one null key and multiple null values.
Hashtable is slower than hashmap due to synchronization.
Hashtable is a legacy class while hashmap is a newer implementation.
- Q2. Difference between hashmap and concurrent hashmap?
- Ans.
Hashmap is not thread-safe while Concurrent Hashmap is thread-safe.
Hashmap is not suitable for multi-threaded environments as it can lead to race conditions and data inconsistencies.
Concurrent Hashmap allows multiple threads to access and modify the map concurrently without any data inconsistencies.
Concurrent Hashmap uses a technique called lock striping to achieve thread-safety.
Concurrent Hashmap is slower than Hashma...
- Q3. Jdbc step
- Q4. Spring ioc
Interview Preparation Tips
Skills evaluated in this interview
I applied via Naukri.com and was interviewed before Sep 2020. There were 4 interview rounds.
Interview Questionnaire
1 Question
- Q1. IOS Basics , iPhone programming
Interview Preparation Tips
I appeared for an interview in Sep 2017.
Interview Questionnaire
4 Questions
- Q1. Technical interview take by client technical person actually they are hiring for another client so they took total 3 technical round and final will HR round
- Q2. Asking about life cycle of Dot net mvc contols entity frame work and SQL queries
- Q3. Problem based on oops and SQL queries outputs
- Q4. Basic questions about my self ,salary discussion basic formalities form I have to fill up
Interview Preparation Tips
Experience: There were around 15 objective question that includes mvc, c#.net and SQL server. It was very simple question like different types of filters,Acton results in mvc. Basic oops concept and dot net web page regarding
Round: Resume Shortlist
Experience: After completing test round another was technical round discussed maily for mvc and SQL server questions. Around 30 mint discussion. After qualify this round another round will start from client technical staff.
General Tips: It was for 2-3 year experience person very simple to crack but focus on you which profile you are looking for study interview questions from net
Skills: Dot net mve oops concept jQuery and SQL server
I applied via Naukri.com and was interviewed before May 2018. There were 5 interview rounds.
Interview Questionnaire
4 Questions
- Q1. Telephonic technical
- Q2. Core Java related exception handling ,design pattern ,oops solid design principle, rest API, different annotations of spring and jpa
- Q3. Same questions on telephonic round but detailed elaborate and given simple problem statement we had to justify that why it's time n space complexity valid. Rest API questions hibernate orm use
- Q4. Manager round just to check whether you have actually worked on project or not stress testing performance questions scenario questions
Interview Preparation Tips
Skills: Core Java sevlet JSP hibernate spring rest API, Communication, Body Language, Problem Solving, Analytical Skills, Decision Making Skills
Duration: 1-4 weeks
I applied via Recruitment Consultant and was interviewed in May 2019. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. Technical questions & team leading
Interview Preparation Tips
I appeared for an interview in Sep 2019.
Interview Questionnaire
1 Question
- Q1. Pl sql related questions
Interview Preparation Tips
Laterly after I had lunch by 2pm Hr came n told me that Manager is not available now so we will be conducting ur further round in weekdays.
Then there was no mail or call so I purposely mailed them still haven't got proper response from them, so at last I told my friend who referd me to ask for an update the same HR told him that they want Immediate joiner so we can't process him to further round. Wasted my whole day over there
TO THE NEW Interview FAQs
Tell us how to improve this page.
TO THE NEW Interviews By Designations
- TO THE NEW Software Engineer Interview Questions
- TO THE NEW Senior Software Engineer Interview Questions
- TO THE NEW Quality Engineer Interview Questions
- TO THE NEW Devops Engineer Interview Questions
- TO THE NEW Java Developer Interview Questions
- TO THE NEW Technical Lead Interview Questions
- TO THE NEW Associate Technical Leader Interview Questions
- TO THE NEW Senior Devops Engineer Interview Questions
- Show more
Overall Interview Experience Rating
based on 3 interview experiences
Difficulty level
Duration
Interview Questions from Similar Companies
TO THE NEW Associate Technical Leader Reviews and Ratings
based on 37 reviews
Rating in categories
|
Senior Software Engineer
684
salaries
|  ₹13.1 L/yr - ₹24 L/yr |
|
Software Engineer
597
salaries
| ₹4.9 L/yr - ₹12.1 L/yr |
|
Associate Technical Leader
236
salaries
| ₹22 L/yr - ₹36 L/yr |
|
Technical Lead
170
salaries
| ₹28 L/yr - ₹45 L/yr |
|
Senior Quality Engineer
168
salaries
| ₹12.3 L/yr - ₹22.5 L/yr |
ITC Infotech
CMS IT Services
KocharTech
Xoriant
- Home >
- Interviews >
- TO THE NEW Interview Questions >
- TO THE NEW Interview Questions for Experienced
