i
McKinsey &
Company
Work with us
Filter interviews by
Services in Drupal are reusable objects that perform specific functions, such as database queries or sending emails.
Services are defined in YAML files and can be accessed throughout a Drupal site.
They are used to encapsulate reusable functionality and promote code reusability.
Examples of services in Drupal include the database service for interacting with the database, the mail service for sending emails, and the logge...
Debugging in Drupal involves using tools like Devel module, watchdog(), and error logs.
Enable Devel module for debugging information
Use watchdog() function to log messages to Drupal's watchdog log
Check error logs for PHP errors and warnings
Use dpm() function to print variables for debugging purposes
Questions are asked from hackerrank . Difficulty level medium .
Prepare for SQL too.
What people are saying about McKinsey & Company
I applied via Naukri.com and was interviewed before Aug 2020. There were 3 interview rounds.
Promise.all vs promise.allsettled how to resolve asynchronus call using promises
Addressing any gaps in education during the interview process.
Acknowledge any gaps in education and explain how you have worked to overcome them
Highlight any additional courses, certifications, or self-study you have done to fill in the gaps
Discuss how you have applied your knowledge in real-world projects to compensate for any educational shortcomings
I applied via Approached by Company and was interviewed in May 2023. There were 4 interview rounds.
Temp tables are used in SSRS reports for performance optimization and to reduce resource consumption.
Temp tables are used to store intermediate results during report generation, reducing the need to repeatedly query the database.
Regular tables can lead to locking and contention issues in multi-user environments, while temp tables are session-specific and do not cause conflicts.
Temp tables can be indexed and optimized f...
posted on 17 Feb 2022
I applied via LinkedIn and was interviewed in Aug 2021. There were 4 interview rounds.
This round is purely based on DS /Algo and System Design and their real-life applications implications and a few case studies.
Python uses automatic memory management through garbage collection.
Python uses reference counting to keep track of memory usage.
When an object's reference count reaches zero, it is deleted.
Python also uses a garbage collector to clean up circular references.
Memory allocation is handled by the Python memory manager.
Python provides tools like sys.getsizeof() to monitor memory usage.
posted on 14 Jun 2024
Basic coding questions and SQL queries
Various technologies including Java, Python, SQL, AWS, Docker, Kubernetes, etc.
Java
Python
SQL
AWS
Docker
Kubernetes
I applied via Company Website and was interviewed in Jun 2024. There was 1 interview round.
1 hr test with questions on react and , js, python
Inheritance is a way to create a new class using properties and methods of an existing class, while polymorphism allows objects of different classes to be treated as objects of a common superclass.
Inheritance allows a class to inherit properties and methods from another class.
Polymorphism allows objects of different classes to be treated as objects of a common superclass.
Inheritance promotes code reusability and reduce...
Code to check if two strings are anagrams
Create a function that takes in two strings as input
Convert both strings to lowercase and remove any spaces
Sort both strings and compare if they are equal to determine if they are anagrams
I appeared for an interview before Apr 2021.
Round duration - 60 Minutes
Round difficulty - Medium
This round started slow with some basic fundamental questions around OOPS and then paced up higher to some more advanced questions Java and Multithreading in Java in general.
SOLID principles are a set of five design principles in object-oriented programming to make software more maintainable, flexible, and scalable.
Single Responsibility Principle (SRP) - A class should have only one reason to change.
Open/Closed Principle (OCP) - Software entities should be open for extension but closed for modification.
Liskov Substitution Principle (LSP) - Objects of a superclass should be replaceable with...
Abstraction in OOP is the concept of hiding complex implementation details and showing only the necessary features to the outside world.
Abstraction allows us to focus on what an object does instead of how it does it
It helps in reducing complexity and improving maintainability of code
Example: In a car, we don't need to know the internal workings of the engine to drive it
Abstract class can have both abstract and non-abstract methods, while interface can only have abstract methods.
Abstract class can have constructors, fields, and methods with implementation.
Interface can only have abstract methods and constants.
A class can implement multiple interfaces but can only inherit from one abstract class.
Example: Abstract class - Animal with abstract method 'eat', Interface - Flyable with metho...
A classloader in Java is a part of the Java Runtime Environment that dynamically loads Java classes into the Java Virtual Machine.
Classloaders are responsible for loading classes at runtime based on the fully qualified name of the class.
There are different types of classloaders in Java such as Bootstrap Classloader, Extension Classloader, and Application Classloader.
Classloaders follow a delegation model where a classl...
Java is platform independent because it compiles code into bytecode that can run on any system with a JVM, which is platform dependent.
Java code is compiled into bytecode, which is platform independent
The JVM interprets the bytecode and translates it into machine code specific to the underlying platform
This allows Java programs to run on any system with a JVM installed, making Java platform independent
JIT compiler stands for Just-In-Time compiler, which dynamically compiles and optimizes code during runtime.
JIT compiler is used to improve the performance of applications by compiling code at runtime instead of ahead of time.
It converts bytecode into native machine code on-the-fly, allowing for faster execution.
Examples of JIT compilers include HotSpot for Java and V8 for JavaScript.
A thread pool is a collection of worker threads that are used to execute tasks concurrently.
Thread pools help manage and reuse threads to improve performance and reduce overhead.
They limit the number of concurrent threads to prevent resource exhaustion.
Tasks are submitted to the pool and executed by available threads.
Example: Java's Executor framework provides implementations of thread pools like ThreadPoolExecutor.
interrupted() checks if the current thread has been interrupted, while isInterrupted() checks if a thread has been interrupted.
interrupted() is a static method in the Thread class, while isInterrupted() is an instance method.
interrupted() clears the interrupted status of the current thread, while isInterrupted() does not.
Example: Thread.currentThread().interrupt(); System.out.println(Thread.interrupted()); // prints tr...
Round duration - 60 Minutes
Round difficulty - Medium
This round primarily focused on some major concepts in Spring Boot and Hibernate and had questions revolving around
that with some more questions from Microserviices and Java Design Patterns.
Spring supports five bean scopes: singleton, prototype, request, session, and application.
Singleton scope creates a single instance per Spring IoC container.
Prototype scope creates a new instance every time the bean is requested.
Request scope creates a new instance for each HTTP request.
Session scope creates a single instance per HTTP session.
Application scope creates a single instance per ServletContext.
Autowiring in Spring Boot is a way to automatically inject dependencies into a Spring bean.
Autowiring is a feature in Spring that allows the container to automatically inject the dependencies of a bean.
There are different modes of autowiring in Spring: 'byName', 'byType', 'constructor', 'autodetect', and 'no'.
For example, in 'byName' autowiring, Spring looks for a bean with the same name as the property being autowired...
The @RestController annotation in Spring Boot is used to define a class as a RESTful controller.
Used to create RESTful web services in Spring Boot
Combines @Controller and @ResponseBody annotations
Eliminates the need to annotate each method with @ResponseBody
The @SpringBootApplication annotation is used to mark the main class of a Spring Boot application.
It is a combination of @Configuration, @EnableAutoConfiguration, and @ComponentScan annotations.
It tells Spring Boot to start adding beans based on classpath settings, other beans, and various property settings.
It also implicitly provides a base package for component scanning.
Example: @SpringBootApplication
Example: @Spring...
Spring Actuator is a set of production-ready features to help monitor and manage your application.
Provides insights into application's health, metrics, and other useful information
Enables monitoring and managing of application through HTTP endpoints
Can be used to check application's health, view metrics, and even perform custom actions
Helps in identifying and troubleshooting issues in production environment
Hibernate provides various concurrency strategies like optimistic locking, pessimistic locking, and versioning.
Optimistic locking: Allows multiple transactions to read a row simultaneously, but only one can update it at a time. Uses versioning or timestamp to check for conflicts.
Pessimistic locking: Locks the row for exclusive use by one transaction, preventing other transactions from accessing it until the lock is rel...
Microservice architecture is an architectural style that structures an application as a collection of loosely coupled services.
Microservices are small, independent services that work together to form a complete application.
Each microservice is responsible for a specific business function and can be developed, deployed, and scaled independently.
Communication between microservices is typically done through APIs.
Microserv...
Spring Cloud addresses issues related to building and deploying cloud-native applications.
Service discovery and registration
Load balancing
Circuit breakers
Distributed configuration management
Routing and gateway
Monitoring and tracing
Singleton design pattern ensures a class has only one instance and provides a global point of access to it.
Ensures a class has only one instance by providing a global access point to it
Uses a private constructor to restrict instantiation of the class
Provides a static method to access the single instance
Round duration - 30 Minutes
Round difficulty - Easy
This is a cultural fitment testing round. HR was very frank and asked standard questions. Then we discussed about my
role.
Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Go through all the previous interview experiences from Codestudio and Leetcode.
Tip 3 : Do at-least 2 good projects and you must know every bit of them.
Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.
based on 2 interview experiences
Difficulty level
Duration
based on 4 reviews
Rating in categories
Business Presentation Specialist
524
salaries
| ₹2.2 L/yr - ₹10 L/yr |
Associate
295
salaries
| ₹24 L/yr - ₹65.6 L/yr |
Consultant
229
salaries
| ₹16 L/yr - ₹59 L/yr |
Analyst
206
salaries
| ₹9 L/yr - ₹28 L/yr |
Senior Analyst
204
salaries
| ₹13.7 L/yr - ₹37 L/yr |
BCG
Deloitte
Ernst & Young
PwC