Filter interviews by
I applied via Naukri.com and was interviewed before Sep 2022. There were 4 interview rounds.
Different types of joins include inner join, outer join, left join, and right join.
Inner join: Returns rows when there is a match in both tables
Outer join: Returns all rows when there is a match in one of the tables
Left join: Returns all rows from the left table and the matched rows from the right table
Right join: Returns all rows from the right table and the matched rows from the left table
ETL stands for Extract, Transform, Load. It is a process used to extract data from various sources, transform it into a consistent format, and load it into a target database or data warehouse.
Extract: Data is extracted from different sources such as databases, files, APIs, etc.
Transform: Data is cleaned, standardized, and transformed into a format suitable for analysis.
Load: The transformed data is loaded into a target...
Use a LEFT JOIN to find values without relationships in other tables.
Use a LEFT JOIN to join the table with other tables
Filter the results where the relationship is NULL
Improving database performance can be achieved through optimization of queries, indexing, hardware upgrades, and regular maintenance.
Optimize database queries by avoiding unnecessary joins and using appropriate indexes
Regularly monitor and tune the database for optimal performance
Consider hardware upgrades such as increasing memory or storage capacity
Implement caching mechanisms to reduce the load on the database serve
It is difficult to provide an exact number as it varies depending on the specific location and day of the week.
Burger sales can vary greatly depending on the popularity of the restaurant, day of the week, and time of year.
Fast food chains like McDonald's or Burger King may sell thousands of burgers in a day.
Local burger joints may sell a few hundred to a thousand burgers in a day.
Special events or promotions can also i...
Top trending discussions
posted on 20 Feb 2025
These are some tests they have copied from other organizations.
I applied via Referral and was interviewed in Oct 2024. There were 2 interview rounds.
Inter company accounting involves recording financial transactions between different entities within the same organization.
Inter company accounting ensures accurate financial reporting within a group of companies.
Transactions between entities are eliminated to avoid double counting.
Common inter company transactions include sales, purchases, loans, and transfers of assets.
Inter company accounts are used to track these t...
I manage a team by setting clear goals, providing support and resources, fostering open communication, and recognizing achievements.
Set clear goals and expectations for team members
Provide necessary support and resources for team to succeed
Foster open communication and encourage collaboration
Recognize and reward team achievements
Delegate tasks effectively based on team members' strengths and skills
React JS is a popular JavaScript library for building user interfaces.
Efficient and fast rendering with virtual DOM
Component-based architecture for reusability and maintainability
Support for server-side rendering for improved SEO
Large community and ecosystem for support and resources
Error loading in React JS can be caused by various reasons such as incorrect file paths, syntax errors, or network issues.
Check if the file paths in your import statements are correct
Look for syntax errors in your code, such as missing commas or semicolons
Ensure that your network connection is stable and there are no CORS issues
Use browser developer tools to check for any console errors or network requests failing
useMemo is a React hook that memoizes the result of a function to optimize performance by avoiding unnecessary re-computations.
useMemo is used to memoize expensive calculations so that they are only computed when dependencies change.
It takes a function and an array of dependencies as arguments.
The memoized value is only recalculated when one of the dependencies has changed.
Developed a mobile app for tracking daily water intake and hydration levels
Researched user needs and preferences for water intake tracking
Designed user-friendly interface with customizable water intake goals
Implemented features for tracking hydration levels and sending reminders
Conducted user testing to gather feedback for improvements
I applied via Campus Placement and was interviewed in Oct 2024. There were 4 interview rounds.
Good enough and it’s through online
Same as of the previous round
Same though online as previously mentioned
I applied via Campus Placement
The typical P2P process flow involves requisition, approval, purchase order creation, goods receipt, invoice receipt, and payment.
Requisition: Request for goods or services
Approval: Authorization of the requisition
Purchase Order Creation: Formal order placed with supplier
Goods Receipt: Receipt of goods/services
Invoice Receipt: Receipt of invoice from supplier
Payment: Settlement of invoice
Implementing a centralized data management system, providing digital training for employees, and investing in cybersecurity measures.
Implement a centralized data management system to streamline data storage and access.
Provide digital training for employees to enhance their digital literacy and skills.
Invest in cybersecurity measures to protect digital assets and data from cyber threats.
I managed conflicts by actively listening to all parties, facilitating open communication, and finding mutually beneficial solutions.
Actively listened to all parties involved to understand their perspectives
Facilitated open communication to encourage dialogue and collaboration
Found mutually beneficial solutions through compromise and negotiation
I applied via Naukri.com and was interviewed in May 2024. There was 1 interview round.
I applied via Company Website and was interviewed in May 2024. There was 1 interview round.
BCG Nairobi offers a unique opportunity to work on impactful projects in a dynamic and diverse environment.
Opportunity to work on projects with significant social impact
Dynamic and diverse work environment
Access to a wide network of clients and industries in Nairobi
Market research on multiple sclerosis drugs and competition
based on 1 interview
Interview experience
based on 4 reviews
Rating in categories
Associate Consultant
15
salaries
| ₹2.4 L/yr - ₹5.5 L/yr |
Sourcing Consultant
11
salaries
| ₹4 L/yr - ₹8.1 L/yr |
Consultant
9
salaries
| ₹4 L/yr - ₹9 L/yr |
Senior Consultant
8
salaries
| ₹7 L/yr - ₹13.3 L/yr |
Information Technology Recruiter
7
salaries
| ₹2 L/yr - ₹3.5 L/yr |
Wipro
Infosys
Tech Mahindra
WNS