i
Debox Consulting
Filter interviews by
3 hours on excel data processing
Top trending discussions
posted on 14 Dec 2024
I was interviewed in Nov 2024.
Some basic questions related to profit, time, and distance.
Identify the missing number in the array and remove the duplicate string from another string, then write the remaining portion.
REST APIs are a set of rules and conventions for building and interacting with web services.
REST stands for Representational State Transfer
Uses standard HTTP methods like GET, POST, PUT, DELETE
Data is transferred in JSON or XML format
Stateless communication between client and server
Example: GET request to retrieve data from a server
Components in software development are modular, reusable parts of a system that perform specific functions.
Components are building blocks of a software system
They are designed to be modular and reusable
Each component performs a specific function or set of functions
Examples include buttons, forms, navigation bars in a web application
API testing involves testing the functionality, reliability, performance, and security of APIs.
API testing ensures that the API functions as expected and meets the requirements.
It involves testing the input parameters, output, authentication, error codes, and response time.
Tools like Postman, SoapUI, and JMeter are commonly used for API testing.
API testing can be done manually or automated using scripts.
Common types of...
Developed a web application for online food ordering and delivery service
Used React.js for front-end development
Implemented Node.js and Express.js for back-end functionality
Integrated payment gateway for secure transactions
posted on 20 Dec 2024
I have worked on various technologies including Java, Python, SQL, and Tableau.
Java
Python
SQL
Tableau
I have worked extensively with Java programming language.
Developed web applications using Java EE
Utilized Spring framework for dependency injection
Implemented RESTful APIs with JAX-RS
I applied via campus placement at NIPER National Institute of Pharmaceutical Education and Research, Kaul and was interviewed in Dec 2024. There were 2 interview rounds.
Basic quant and comprehension
I applied via Campus Placement and was interviewed in Feb 2024. There were 3 interview rounds.
I am a Lean Consultant with 10 years of experience in process improvement and waste reduction.
10 years of experience in Lean consulting
Specialize in process improvement and waste reduction
Implemented Lean principles in various industries such as manufacturing and healthcare
My short term goal is to improve efficiency and reduce waste in current processes. My long term goal is to become a recognized expert in Lean methodologies.
Short term goal: Implement Lean principles to streamline operations and increase productivity
Short term goal: Identify and eliminate non-value added activities to reduce waste
Long term goal: Obtain Lean Six Sigma certification to enhance skills and credibility
Long t...
In 5 years, I see myself as a senior Lean Consultant leading a team of consultants and working on high-impact projects.
Leading a team of consultants
Working on high-impact projects
Continuing to develop expertise in Lean methodologies
Mentoring junior consultants
Possibly pursuing advanced certifications in Lean management
Strengths include problem-solving and communication skills. Weaknesses include time management. Improving by setting priorities and using tools like calendars.
Strengths: problem-solving skills, communication skills
Weaknesses: time management
Improvement: set priorities, use tools like calendars
I enjoy hiking, reading, and playing the guitar in my free time.
Hiking: I love exploring nature trails and challenging myself with different terrains.
Reading: I enjoy diving into fiction and non-fiction books to expand my knowledge and imagination.
Playing the guitar: I find relaxation and creativity in strumming chords and learning new songs.
Yes, I am able to withstand peer pressure during company hours and manage any tangling issues effectively.
I believe in open communication and addressing issues directly with my peers
I stay focused on the task at hand and do not let peer pressure distract me
I am confident in my abilities and decisions, which helps me handle any conflicts calmly
I seek guidance from mentors or supervisors if needed to resolve any challeng
I am a Lean Consultant with 10 years of experience in process improvement and waste reduction.
10 years of experience in Lean consulting
Specialize in process improvement and waste reduction
Implemented Lean principles in various industries such as manufacturing and healthcare
My final year project was on implementing lean principles in a manufacturing company to reduce waste and improve efficiency.
Role: Project leader responsible for coordinating team efforts and implementing lean tools
Outcomes: Reduced production lead time by 30%, decreased inventory levels by 20%, and improved overall productivity
Learnings: Gained hands-on experience in applying lean methodologies, problem-solving skills,
Heat treatment process is a method used to alter the physical and sometimes chemical properties of a material through heating and cooling.
Involves heating the material to a specific temperature
Holding it at that temperature for a certain amount of time
Then cooling it at a controlled rate
Common types include annealing, tempering, quenching, and normalizing
5-S is a methodology for organizing a workplace for efficiency and effectiveness by identifying and storing items used, maintaining the area and items, and sustaining the new order.
Sort - Separate needed tools, parts, and instructions from unneeded items.
Set in order - Arrange items so they are easy to use and label them to show where items belong.
Shine - Clean the work area and equipment regularly.
Standardize - Establ...
Some common lean tools implemented at the shop floor include 5S, value stream mapping, kanban, and kaizen.
5S - Sort, Set in order, Shine, Standardize, Sustain
Value stream mapping - Identifying value-added and non-value-added activities in the process
Kanban - Visual signaling system to trigger production or replenishment
Kaizen - Continuous improvement through small incremental changes
Gemba walk is a Lean management practice where managers go to the actual workplace to observe processes, identify waste, and engage with employees.
Gemba walk involves going to the actual workplace where value is created
The purpose is to observe processes, identify waste, and engage with employees
It helps in understanding the current state of operations and opportunities for improvement
Examples include observing product...
I am a Lean Consultant with 10 years of experience in process improvement and waste reduction.
Experienced in implementing Lean methodologies to streamline processes and increase efficiency
Skilled in conducting value stream mapping and root cause analysis
Proficient in leading cross-functional teams to drive continuous improvement
Certified in Lean Six Sigma with a track record of delivering cost savings and quality impro
I have a small family consisting of my parents and my younger sister.
Father - Occupation: Engineer
Mother - Occupation: Teacher
Younger sister - Occupation: Student
Yes, I am comfortable with travelling and have experience working in various locations.
I have experience travelling for work in my previous roles.
I am adaptable and enjoy experiencing new cultures and environments.
I am willing to travel for client meetings, workshops, and training sessions.
I understand the importance of being flexible and responsive to travel requirements in a consulting role.
I enjoy hiking, reading, and playing the guitar in my free time.
Hiking: I love exploring nature trails and challenging myself with new hikes.
Reading: I enjoy getting lost in a good book, especially fiction and self-improvement genres.
Playing the guitar: I find playing music to be a relaxing and creative outlet for me.
SQL aggregation and join queries for data analysis.
Use GROUP BY clause for aggregation
Use aggregate functions like SUM, AVG, COUNT, etc.
Use JOIN clause to combine data from multiple tables
Types of joins in SQL include inner join, left join, right join, and full outer join.
Inner join: Returns rows when there is a match in both 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.
Full outer join: Returns all rows when there is a match in either table.
You can import data in Power BI using API by connecting to the API endpoint and specifying the required parameters.
Use the 'Get Data' option in Power BI to connect to the API endpoint
Specify the required authentication method (e.g. API key, OAuth)
Select the data you want to import and transform it as needed
Refresh the data periodically to keep it up to date
Extract numbers from strings in SQL
Use the SQL function REGEXP_REPLACE to remove non-numeric characters
Use the SQL function REGEXP_SUBSTR to extract numbers from strings
Consider using regular expressions to handle different number formats
Window functions in SQL are used to perform calculations across a set of table rows related to the current row.
Window functions operate on a set of rows related to the current row
They can be used to calculate running totals, ranks, and averages
Common window functions include ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE()
They are typically used with the OVER() clause to define the window frame
Joins are used to combine rows from two or more tables based on a related column between them.
Inner Join: Returns rows when there is a match in both 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.
Full Outer Join: Returns rows when there is a match in either table.
Cross Join: Retur
Order of execution in SQL refers to the sequence in which different clauses are processed in a SQL query.
1. FROM clause is processed first to retrieve data from the specified tables.
2. WHERE clause is processed next to filter the rows based on specified conditions.
3. GROUP BY clause is processed to group the rows based on specified columns.
4. HAVING clause is processed to filter the grouped rows based on specified cond...
Use indexes, limit columns in SELECT, avoid using SELECT *, optimize joins
Use indexes on columns frequently used in WHERE clauses
Limit columns in SELECT to only those needed
Avoid using SELECT * to retrieve all columns
Optimize joins by using INNER JOIN instead of OUTER JOIN when possible
I applied via Walk-in and was interviewed in Jul 2024. There were 2 interview rounds.
posted on 30 Jan 2025
I applied via Referral and was interviewed in Feb 2024. There were 3 interview rounds.
Interview experience
based on 11 reviews
Rating in categories
Associate Consultant
4
salaries
| ₹3.6 L/yr - ₹8.4 L/yr |
Full Stack Developer
4
salaries
| ₹4 L/yr - ₹5 L/yr |
Client Servicing Executive
3
salaries
| ₹2.4 L/yr - ₹3.3 L/yr |
Creative Lead
3
salaries
| ₹3.6 L/yr - ₹5.5 L/yr |
Senior Graphic Designer
3
salaries
| ₹3 L/yr - ₹4.2 L/yr |
McKinsey & Company
BCG
KPMG India
Deloitte