Upload Button Icon Add office photos

Filter interviews by

Day 2 Day Consultancy Interview Questions and Answers

Be the first one to contribute and help others!

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all tips
Round 2 - HR 

(2 Questions)

  • Q1. Sql, python, tableau are important topics
  • Q2. Prepare windows function in sql
  • Ans. 

    Windows function in SQL is used to perform calculations across a set of rows that are related to the current row.

    • Windows functions are used to calculate values based on a group of rows

    • They are used with the OVER clause

    • Examples include ROW_NUMBER(), RANK(), DENSE_RANK(), SUM(), AVG(), MIN(), MAX()

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - have basic understanding of technology on which u have worked

Skills evaluated in this interview

I applied via Job Portal and was interviewed before Jan 2021. There were 2 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Was an good interview which happened around one and half an hour
Round 2 - Case Study 

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview was really good as they have asked about my experience and the work which I had performed... Etc
Round 1 - One-on-one 

(1 Question)

  • Q1. SQL questions were asked.
Round 2 - One-on-one 

(1 Question)

  • Q1. Technical questions were asked.

Interview Preparation Tips

Interview preparation tips for other job seekers - For Ubique- Don't go for this. No job security. Don't believe in their words. If you still do believe, you will be left jobless after few months.

For ZS Associate- They treat contractors very badly. They keep contractors overloaded with work and keep their employees free. And if anything goes wrong, everything will be on contractors.
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(3 Questions)

  • Q1. Some basic SQL based questions and PySpark questions
  • Q2. Coalesce and partition in PySpark
  • Ans. 

    Coalesce reduces the number of partitions in a DataFrame, while repartition increases the number of partitions.

    • Coalesce is used to reduce the number of partitions in a DataFrame without shuffling the data

    • Repartition is used to increase the number of partitions in a DataFrame and can involve shuffling the data

    • Coalesce is more efficient than repartition when reducing partitions as it avoids shuffling

  • Answered by AI
  • Q3. Puzzles of get 4 litter of water using 3 litter and 5 litter flask. Famous online puzzle

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I was interviewed before May 2023.

Round 1 - Technical 

(1 Question)

  • Q1. Technical Java questions for 1 year experience developers was asked.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed before Jun 2023. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Advantage of react Js
  • Ans. 

    React Js allows for efficient and reusable UI components, virtual DOM for faster rendering, and easy integration with other libraries.

    • Efficient and reusable UI components make development faster and easier.

    • Virtual DOM allows for faster rendering by only updating the parts of the DOM that have changed.

    • Easy integration with other libraries like Redux for state management.

    • React Native allows for building mobile apps using

  • Answered by AI
  • Q2. Stateless and Statefull Component

Skills evaluated in this interview

I applied via Naukri.com and was interviewed in Nov 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. I was asked about my previous company work experience. There were two rounds both were mostly same.

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident in what you say. What ever you have written in your Resume be completely prepared with technical questions of those technologies and work experience.

Interview Questionnaire 

2 Questions

  • Q1. Explain in brief about your past projects, techniques applied, approach to the problem?
  • Q2. Explain in brief all the tasks that were assigned in the previous company?
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. String immutable question in java
  • Q2. Annotations in Spring boot
  • Ans. 

    Annotations in Spring Boot are used to simplify the configuration and development of applications.

    • Annotations are used to provide metadata about the application's components

    • They help in reducing the amount of configuration required

    • Examples include @RestController, @Autowired, @RequestMapping

  • Answered by AI

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Difference between functions and stored procedure in SQL.
  • Ans. 

    Functions return a single value while stored procedures can perform multiple operations and return multiple values.

    • Functions return a single value while stored procedures can return multiple values.

    • Functions are used for computations and return values, while stored procedures are used for executing a series of statements.

    • Functions can be called from within SQL statements, while stored procedures are called using the EX...

  • Answered by AI
  • Q2. Difference between abstract class and Interface in C#
  • Ans. 

    Abstract class can have implementation details, while interface only contains method signatures.

    • Abstract class can have constructors, fields, and methods with implementation details, while interface can only have method signatures.

    • A class can inherit from only one abstract class, but can implement multiple interfaces.

    • Abstract classes are used when some common functionality needs to be shared among multiple classes, whi...

  • Answered by AI

Skills evaluated in this interview

Tell us how to improve this page.

Interview Questions from Similar Companies

Right Advisors Interview Questions
4.5
 • 25 Interviews
Career Point Interview Questions
3.2
 • 14 Interviews
Ubique Systems Interview Questions
2.9
 • 14 Interviews
HiringBooster Interview Questions
4.1
 • 12 Interviews
E-Solutions Interview Questions
3.4
 • 10 Interviews
R2R Consults Interview Questions
3.8
 • 7 Interviews
View all

Day 2 Day Consultancy Reviews and Ratings

based on 1 review

5.0/5

Rating in categories

5.0

Skill development

5.0

Work-life balance

5.0

Salary

5.0

Job security

5.0

Company culture

5.0

Promotions

5.0

Work satisfaction

Explore 1 Review and Rating
Compare Day 2 Day Consultancy with

Wintax Solution

4.8
Compare

E-Solutions

3.4
Compare

Anri Solutions HR Services

3.4
Compare

Crescendo Global

4.3
Compare
Did you find this page helpful?
Yes No
write
Share an Interview