Dion Global Solutions Interview Questions and Answers

This usually assesses logical reasoning, mathematical ability, and problem-solving skills. It’s often used to gauge your analytical thinking and ability to work under time pressure.

Q1. Previous experience
Add your answer
Q2. Salary hike and joining date
Add your answer

Q1. BBPS product structure
Add your answer
Q2. Kafka Usage and advantages
Add your answer
Q3. DB usage along with backup of tables and data
Add your answer
Q4. Web logic usage and new setup process
Add your answer
Q5. Apache tomcat server installation and configuration
Add your answer
Q6. Linux basic commands
Add your answer
Q7. How to test an new configuration or bug fix in UAT and testing tools.
Ans. 
To test a new configuration or bug fix in UAT and testing tools, follow these steps.
• Create test cases based on the new configuration or bug fix

• Execute the test cases in the UAT environment to validate the changes

• Use testing tools like Selenium, JIRA, or TestRail to automate and track the testing process

• Collaborate with developers and stakeholders to ensure the changes meet requirements

• Document the test results and prov
Answered by AI
Add your answer

Q1. Desing chatbot using 3rd party providers
Add your answer

Q1. Regarding previous work experience
Add your answer
Q2. Work experience Knowledge of local market Business development plan
Add your answer
Q3. Family history
Add your answer
Q4. Local resources
Add your answer

Q1. Fibonacci sequence
Add your answer
Q2. Databricks cluster questions
Add your answer
Q3. Intermediate SQL questions from datalemur
Add your answer
Q4. Python questions from geeksforgeeks
Add your answer
Q5. ETL information
Add your answer

Q1. Introduce yourself.
Add your answer
Q2. How has your day been?
Add your answer
Q3. How many processes have you gone through till now?
Add your answer
Q4. What projects have you done till now which makes you think you are fit for consulting?
Add your answer
Q5. Could you please explain the CDF project.
Ans. 
The CDF project is a consulting project focused on improving data analysis and decision-making processes.
• The CDF project aims to enhance data analysis and decision-making procedures.

• It involves implementing new tools and techniques for data collection, processing, and visualization.

• The project also includes training employees on data analysis best practices.

• Examples of CDF project outcomes may include improved data acc...read more
Answered by AI
View 1 more answer

Mastercard wants to launch a loyalty product for an e-commerce player. Tell me how you would go about it and how we can select the partner.
[Please note that I stands for Interviewer and C stands for Candidate]

C: Could you give me details about what kind of loyalty product do you have in your mind?

I: This is like Smart Buy which HDFC and Mastercard have launched. (She also told me about the portal and the card's benefits.)

C: (I basically thought of going by 4P approach and wrote down some factors to be considered for each head. communicated this to the interviewer.) Do you want me to evaluate the benefits of launching the loyalty card and what forms of benefits could be provided?

I: No, That's fine. Let us just focus on how you will select the e-commerce partner and which one.

C: I would like to focus on the current offerings on different platforms and then comparing them with some benefits that we could provide. There are some other factors that we need to consider like Flipkart having its own loyalty program- super coins and said that this would cause difficulty in partnering with them.

I: Why are you looking only at Flipkart or Amazon. Do you know what an e-commerce platform means?

C: There are different aggregators in various categories like transport, food, and others, giving examples.

I: Right. Let us pick one and then see why that would be beneficial for us.

C: Let us start with Swiggy. Zomato has a premium membership while Swiggy did not which made it a good partner.

I: That's fine we can close the case here. That will be all from my side.

Q1. Estimate the yearly revenue of Cafeteria & Co.
Ans. 
Estimating the yearly revenue of Cafeteria & Co.
• Analyze the average number of customers per day and multiply it by the average amount spent per customer

• Consider the number of operating days in a year

• Take into account any special events or promotions that may impact revenue

• Review historical financial data and trends

• Consider the competitive landscape and market conditions
Answered by AI
View 1 more answer

Q1. Guesstimate the sale of air purifiers in India.
Ans. 
The sale of air purifiers in India can be estimated based on factors such as population, pollution levels, awareness, and affordability.
• Consider the population of India, which is over 1.3 billion people.

• Take into account the increasing pollution levels in major cities like Delhi and Mumbai.

• Consider the growing awareness among people about the importance of clean air and its impact on health.

• Factor in the affordability ...read more
Answered by AI
View 1 more answer

Let us quickly do a short case as we are short on time. ICICI bank has 1000 customers who use their commercial credit cards. These cards are of 2 types -

1) Purchase cards,
2) Travel & expense cards.

I want you to give me factors to look into by which we can identify which customers (companies) spend less using our cards and which have the potential for more.
[Please note that I stands for Interviewer and C stands for Candidate]

C: We can look into the cash flow and income statements of all 1000 companies and then compare them.

I: That's exactly right. But it is difficult to get this data as all companies might not be listed. Tell me how we can go ahead with the internal data itself.

C: I just wanted to clarify that the internal data referred to spending by different companies or not.

I: Yeah, that is right. We also can get a proxy of revenue for our clients.

C: Then what we can do is take out the ratio of revenue to expenditure for all our clients and further the percentage of their expenses that are made through our cards. We can then benchmark our clients against some high spending companies within our portfolio.

I: That's great Abhishek. That is the right way to go about it. So now ICICI has identified 200 such clients which have the potential to increase their spends. Tell me how we can come up with a strategy to target them.

C: We can further divide the expenses into various heads and then see which company is spending less where and come up with an appropriate pitch for that client.

Q1. Electrical interview
Add your answer
Q2. Electrical lighting mantance
Add your answer
Q3. Electrical connection ,&disconnection
Ans. Electrical motar connection furst notes after disaconnection
Answered Anonymously
Add your answer
Q4. Electrical safty knowdlage
Ans. Electrical safty insulation hand glous
Answered Anonymously
Add your answer
Q5. Electrical machine mantance
Ans. Cheking motor temrechar & tait ness fan cover &Duble Earthing
Answered Anonymously
Add your answer
Q6. Electrical star &stardelta motar daigram
Add your answer
Q7. Elctrical cable gland
Add your answer
Q8. Electrical termanition
Add your answer

2 questions. 1 was basic level. 2 was of medium level.

Q1. An ambiguous problem statement was given. Asking relevant questions revealed the problem to be largest island in a binary matrix. Was asked to code on an ide. And reduce space complexity to O(1).
Add your answer
Q2. Maximum sum path from root to leaf in an N-ary tree. Was asked to design an appropriate data structure. Then code the solution in O(n) time and O(1) space.
Add your answer

Q1. Through discuss of projects. Methods used.
Add your answer
Q2. First missing positive number in an array of integer in O(n) time O(1) space.
Ans. 
Find first missing positive number in an array in O(n) time and O(1) space.
• Traverse the array and mark the presence of each positive integer by changing the sign of the corresponding index.

• Traverse the array again and return the index of the first positive integer.

• If all integers are present, return the length of the array + 1.

• Example: [3, 4, -1, 1] => mark 3rd and 4th index as negative => return 2.

• Example: [1, 2, 0] =...read more
Answered by AI
Add your answer
Q3. Given an integer, print the relevant column name in an excel sheet. Ex: 1- A , 2-B.......... 26-Z , 27-AA, 28-AB........ Was asked code on an ide and test cases were given.
Ans. 
Given an integer, print the relevant column name in an excel sheet.
• Create a string array of alphabets from A to Z

• Use modulo operator to get remainder and divide by 26 to get quotient

• Append the corresponding alphabet to the result string

• Reverse the result string
Answered by AI
Add your answer

Q1. What are your salary expectations?
Add your answer