Add office photos
Filter interviews by
Design Tree Consultants Interview Questions and Answers
Be the first one to contribute and help others!
Interview questions from similar companies
Anonymous
Interview experience
Good
Difficulty level
Moderate
Duration
2-4 weeks
Result
Selected
I applied via campus placement at Institute of Aeronautical Engineering, Hyderabad and was interviewed in Nov 2024.
3 Interview Rounds
1
Aptitude Test Round
Easy-medium questions were asked in this
2
Coding Test Round
The coding questions are mostly easy-moderate level difficulty and they ask questions based on specific clusters selected ( java, python, c# )
3
Technical Round (3 Questions)
- Q1. Mostly he covered all the concepts of DBMS (along with syntaxes) Add Answer
- Q2. Asked to solve pseudo codes Add Answer
- Q3. Oops in real life with detail explanation along with implementation in java Add Answer
Interview Preparation Tips
Topics to prepare for Cognizant Programmer Analyst Trainee interview:
- DBMS
- OOPS
- Problem Solving
- Operating Systems
- Computer Networking
Interview experience
Good
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
No response
I applied via Recruitment Consulltant and was interviewed in Oct 2024.
1 Interview Round
1
Technical Round (16 Questions)
- Q1. How many years of experience you have in CRM and how did you reach this stage on dynamics CRM? Add Answer
- Q2. What other CRMs are you aware about. View Answers (1)
- Q3. Are you comfortable with Marketing CRM capabilities? Have you built any give examples. View Answers (1)
- Q4. Difference between Plugin and Workflow View Answers (1)
- Q5. Difference between Canvas App and Model Driven Apps? Have you integrated any with CRM using customisation View Answers (1)
- Q6. What microsoft certifications you hold? How many are pending renewals View Answers (1)
- Q7. How does Power BI help in visualisation? Give me difference between basic and advance dashboards View Answers (1)
- Q8. What are the steps additionally a pro power BI does? More about transformation Add Answer
- Q9. How many connectors have you worked with in power Apps View Answers (1)
- Q10. How good is your C# and .Net? And SQL knowledge. Add Answer
- Q11. Explain me any previous CRM project that you built end to end. View Answers (1)
- Q12. Have you explored any AI features integrating with CRM? What's your thoughts on Copilot capabilities View Answers (1)
- Q13. What does Marketing CRM include and explain a marketing Campaign scenario. Add Answer
- Q14. Difference between workflows and Power automate Add Answer
- Q15. In C# can you write code to a plugin quickly? What are classess in C# Add Answer
- Q16. Why do you want to join Accenture and how the organisation will benifit from it Add Answer
Interview Preparation Tips
Topics to prepare for Accenture Application Lead interview:
- MS Dynamics CRM
- Power apps
- Power Bi
- C#
- ASP.Net
- Javascript
Skills evaluated in this interview
Interview experience
Good
Difficulty level
Easy
Duration
Less than 2 weeks
Result
-
I applied via Referral and was interviewed in Nov 2024.
2 Interview Rounds
1
Technical Round (11 Questions)
- Q1. Internal working of HashMap Add Answer
- Q2. Features of java8 Add Answer
- Q3. Use of synchronized keyword Add Answer
- Q4. Difference between failsafe and fail fast and also its implementation Add Answer
- Q5. Coding question : sort an array, use of streams to find names from employee object whose salary is greater than 50000 Add Answer
- Q6. Difference between concurrent and generic collection Add Answer
- Q7. What is string pool. What is string literal? Add Answer
- Q8. Security measures used in your project Add Answer
- Q9. What is difference between rest and soap Add Answer
- Q10. What do u mean by REST state Add Answer
- Q11. What is serialization? What is the way to stop serialization? Add Answer
2
Manegerial Round Round (4 Questions)
- Q1. Difference between failsafe and faifast Add Answer
- Q2. Difference between concurrent and generic collection Add Answer
- Q3. Security measures used in current project Add Answer
- Q4. Why you are leaving your current organization and follow up questions on that Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Please prepare well on your project and java 8 features(if you are using java8). also please brush up knowledge on collections, multithreading, and oops concept
Interview experience
Poor
Difficulty level
Easy
Duration
Less than 2 weeks
Result
Selected
I applied via Campus Placement and was interviewed in Sep 2024.
9 Interview Rounds
1
Aptitude Test Round
Standardized assessment that evaluate a person abilities, skills and potential
2
Coding Test Round
Programming challenge that assesses a candidate coding skills and problems-solving ability.
3
Group Discussion Round
Structured conversation where participants share ideas and perspective
4
Assignment Round
Tap recent activity,
5
Case Study Round
Details analysis of a real world situation that can be used to gain insight and generalization
6
HR Round (3 Questions)
- Q1. Tell me about yourself. View Answers (2)
- Q2. What is your strength and weaknesses ? View Answers (2)
- Q3. Why are you interested in this job? View Answers (2)
7
Technical Round (2 Questions)
- Q1. What programming language are you most familiar with? View Answers (1)
- Q2. What is features of c programming language? View Answers (1)
8
One-on-one Round (3 Questions)
- Q1. Tell me about yourself View Answers (1)
- Q2. Why should we hire you View Answers (1)
- Q3. What are your strength View Answers (1)
9
No any Round (2 Questions)
- Q1. Tell me about yourself self View Answers (1)
- Q2. What are your weakness View Answers (1)
Interview Preparation Tips
Topics to prepare for Wipro Other Program / Project Management - Other interview:
- Web Technologies
- Core Java
- Python
- Data Analytics
Interview experience
Poor
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
No response
I applied via Company Website
1 Interview Round
1
Technical Round (9 Questions)
- Q1. Question on LIST_AGGR Add Answer
- Q2. Question on dynamic SQL ,what is a bind variable Add Answer
- Q3. Question on constraints ,do we can delete a child table column having connection with foreign key with parent table Add Answer
- Q4. Triggers : do we can use commit or roll back with in trigger ? View Answers (1)
- Q5. Materialized views and how to refresh View Answers (1)
- Q6. Print 1 to 10 using sql View Answers (1)
- Q7. What is Context switching ? And about collection types ... View Answers (1)
- Q8. Tell me about Analytical functions you worked on ? View Answers (1)
- Q9. What are Set operators ,which one keep duplicates among them View Answers (1)
Interview Preparation Tips
Topics to prepare for Infosys Oracle SQL and PLSQL Developer interview:
- Siva academy
- Techtfq
- Kudvenkat
Skills evaluated in this interview
Interview experience
Average
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
No response
I applied via Naukri.com and was interviewed in Oct 2024.
2 Interview Rounds
1
Technical Round (7 Questions)
- Q1. How do you optimize SQL queries? View Answers (1)
- Q2. How do you do performance optimization in Spark. Tell how you did it in you project. View Answers (1)
- Q3. What is SparkContext and SparkSession? View Answers (1)
- Q4. When a spark job is submitted, what happens at backend. Explain the flow. View Answers (2)
- Q5. Calculate second highest salary using SQL as well as pyspark. View Answers (1)
- Q6. 2 types of modes for Spark architecture ? View Answers (1)
- Q7. If you want very less latency - which is better standalone or client mode? View Answers (1)
2
Technical Round (2 Questions)
- Q1. Scenario based. Write SQL and pyspark code for a dataset. Add Answer
- Q2. If you have to find latest record based on latest timestamp in a table for a particular customer(table is having history) , how will you do it. Self join and ne...read more Add Answer
Interview Preparation Tips
Topics to prepare for LTIMindtree Data Engineer interview:
- SQL
- pyspark
- ETL
Skills evaluated in this interview
Interview experience
Excellent
Difficulty level
Easy
Duration
Less than 2 weeks
Result
Selected
I applied via Naukri.com and was interviewed in Oct 2024.
3 Interview Rounds
1
Technical Round (5 Questions)
- Q1. About interface and abstract class with C# coding Add Answer
- Q2. Output prediction for interface program in C# View Answers (1)
- Q3. Sql queries like finding the 2nd largest salary, few joins,cte. Add Answer
- Q4. C# Program for reversing a string of text. View Answers (1)
- Q5. And oops concepts, dependency injection, Solid principles with examples and design patterns you in your projects and how. Add Answer
2
Technical Round (4 Questions)
- Q1. Few sql queries like window functions Add Answer
- Q2. About indexing and stored procedures and triggers. Add Answer
- Q3. How do you manage the team Add Answer
- Q4. String programs using linq View Answers (1)
3
HR Round (1 Question)
- Q1. Just a salary and location discussion Add Answer
Interview Preparation Tips
Topics to prepare for Capgemini Senior Software Engineer 1 interview:
- OOPS
- Design Patterns
- Solid principles
- MS SQL Server
- LINQ
Skills evaluated in this interview
Interview experience
Average
Difficulty level
Easy
Duration
Less than 2 weeks
Result
Not Selected
I applied via Naukri.com and was interviewed in Nov 2024.
2 Interview Rounds
1
Case Study Round
Executive Summary/Synopsis. Introduce the topic area of the report. .
Introduction. Summarise the your task.
Findings. Identify the key problems you have identified by:
Discussion. Summarise the major problem(s).
Conclusion.
Recommendations.
References.
2
HR Round (5 Questions)
- Q1. What is ir strength s View Answers (1)
- Q2. Tell me about ur life Add Answer
- Q3. What kind of role do u want View Answers (1)
- Q4. What is ur qualification Add Answer
- Q5. Are you intrested ratational shifts View Answers (1)
Interview Preparation Tips
Interview preparation tips for other job seekers - Improve ur skills
Communication skills
Convencing with customer
Communication skills
Convencing with customer
Interview experience
Excellent
Difficulty level
Easy
Duration
Less than 2 weeks
Result
Selected
I applied via Newspaper Ad and was interviewed in Nov 2024.
1 Interview Round
1
Assignment Round
• Email/chat-Based scenarios.
• Problem/solving scenario.
• Role specific question.
• Multitasking task.
• Behavioral assessment.
Interview Preparation Tips
Interview preparation tips for other job seekers - Here’s some advice for job seekers applying for a Customer Service Associate role:
1. Develop Strong Communication Skills:
Practice speaking clearly and politely, both on the phone and in writing.
Focus on active listening to understand customer needs.
2. Show Patience and Empathy:
Customers may be upset, so demonstrate patience and understanding.
Offer solutions while maintaining a calm and professional tone.
3. Prepare for Common Scenarios:
Be ready to explain how you would handle angry customers or resolve issues.
Practice answering questions like, "How would you deal with an upset customer?" or "How do you handle difficult situations?"
4. Know the Company and Products:
Research the company’s services or products so you can speak knowledgeably about them.
Familiarity with their customer policies can also help in interview scenarios.
5. Be Solution-Oriented:
Employers value candidates who can resolve problems efficiently and stay focused on solutions.
Prepare examples of when you’ve gone above and beyond to help a customer.
6. Show Adaptability:
Be open to working in shifts or dealing with high-pressure situations.
Employers appreciate flexibility in customer service roles.
7. Practice Handling Multitasking:
In customer service, you may need to juggle multiple tasks. Practice managing multiple customer queries at once, whether in-person or over chat.
Being patient, professional, and solution-focused will help you stand out in the interview process.
1. Develop Strong Communication Skills:
Practice speaking clearly and politely, both on the phone and in writing.
Focus on active listening to understand customer needs.
2. Show Patience and Empathy:
Customers may be upset, so demonstrate patience and understanding.
Offer solutions while maintaining a calm and professional tone.
3. Prepare for Common Scenarios:
Be ready to explain how you would handle angry customers or resolve issues.
Practice answering questions like, "How would you deal with an upset customer?" or "How do you handle difficult situations?"
4. Know the Company and Products:
Research the company’s services or products so you can speak knowledgeably about them.
Familiarity with their customer policies can also help in interview scenarios.
5. Be Solution-Oriented:
Employers value candidates who can resolve problems efficiently and stay focused on solutions.
Prepare examples of when you’ve gone above and beyond to help a customer.
6. Show Adaptability:
Be open to working in shifts or dealing with high-pressure situations.
Employers appreciate flexibility in customer service roles.
7. Practice Handling Multitasking:
In customer service, you may need to juggle multiple tasks. Practice managing multiple customer queries at once, whether in-person or over chat.
Being patient, professional, and solution-focused will help you stand out in the interview process.
Interview experience
Good
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Selected
I applied via Approached by Company and was interviewed in Oct 2024.
1 Interview Round
1
Technical Round (3 Questions)
- Q1. 1) OOPS in java, and told to explain abstraction, encapsulation, inheritance with practical code 2) Exception handling(globally), Authentication and authorizati...read more View Answers (1)
- Q2. 1) Advantage of springboot over spring 2) Tell me all the anotations you know in spring 3) What are CRUD operations, write controller layer and use validating a...read more View Answers (1)
- Q3. 1) ACID properties 2) DBMS commands 3) inner queries 4) Joins 5) S3 bucket congif and how to handle file and upload and retrieve in s3 6) Ci/Cd basic flow and d...read more Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Prepare resume well and keep applying to jobs
Skills evaluated in this interview
Tell us how to improve this page.
Interview Questions for Popular Designations
Interview Questions from Similar Companies
Design Tree Consultants Reviews and Ratings
based on 10 reviews
Rating in categories
|
Electrical Design Engineer
5
salaries
|  ₹3 L/yr - ₹5.2 L/yr |
|
Structural Design Engineer
4
salaries
| ₹4 L/yr - ₹5 L/yr |
|
Junior Design Engineer
4
salaries
| ₹2.4 L/yr - ₹4.2 L/yr |
|
Senior QA QC Engineer
4
salaries
| ₹7.2 L/yr - ₹8.4 L/yr |
|
CAD Engg
4
salaries
| ₹3 L/yr - ₹7.2 L/yr |
Explore more salaries
Compare Design Tree Consultants with
Architect Hafeez Contractor
Compare
Edifice Consultants
Compare
Voyants Solutions
Compare
RSP Design Consultants
Compare
Calculate your in-hand salary
Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and
get your in-hand salary
Did you find this page helpful?
Yes No
- Home >
- Interviews >
- Design Tree Consultants Interview Questions
Share Interview Advice