EXL Service
20+ I-Infotech Interview Questions and Answers
Q1. You have 20 red balls, 14 blue balls. You draw out balls, 2 at a time. If they are of same color, add a blue ball the pile. If the are of different colors, add a red ball to the pile. (i) will the color of the ...
read moreDrawing balls and adding to pile based on color. Will the last ball left be unique and what color?
Drawing 2 balls at a time and adding to pile based on color
If same color, add a blue ball. If different color, add a red ball
Question asks if last ball left will be unique and what color it will be
Q2. You have 3 slices of bread, and a toaster. You can put in 2 slices of bread at a time. Each time, only one side of the bread gets cooked. How much minimum time is needed for cooking 3 slices on both sides ?
Minimum time needed to cook 3 slices of bread on both sides using a toaster with 2 slice capacity at a time.
Cook 2 slices on one side for the first round
Cook the third slice on one side for the second round
Cook the first 2 slices on the other side for the third round
Cook the third slice on the other side for the fourth round
Total minimum time needed is 4 rounds or 2 minutes
Q3. From a deck of cards, you pick out one card at a time, 3 times, with replacement. What's the probability of getting a sequence, where a sequence is defined as consecutive integers drawn in any order ?
Probability of getting a sequence of consecutive integers from a deck of cards drawn 3 times with replacement.
There are 4 possible sequences: 2-3-4, 3-4-5, 4-5-6, 5-6-7
The probability of drawing any one of these sequences is 1/52 * 1/52 * 1/52 = 1/140608
The probability of drawing any sequence (in any order) is 4/140608 = 1/35152
Q4. List all the relevant things if you were to float a tender for ordering tube lights if hypothetically you were the head of the engineering cell of your college ?
Relevant things to consider when floating a tender for ordering tube lights for the engineering cell of a college.
Quantity of tube lights required
Specifications of the tube lights (wattage, color temperature, length, etc.)
Budget allocated for the tender
Delivery timeline
Quality standards and certifications required
Supplier evaluation criteria
Payment terms and conditions
Warranty and after-sales support
Technical support and installation assistance
Sample tube lights for testing a...read more
Q5. If I have to install a light pole on the road, what should its height be? (use logic)
The height of a light pole on the road should be determined based on factors such as road width, lighting requirements, and safety regulations.
Consider the width of the road and the distance between light poles to ensure adequate lighting coverage.
Take into account the height of nearby buildings or structures that may obstruct the light.
Adhere to safety regulations and guidelines regarding the minimum and maximum height of light poles.
Consider the type of lighting fixtures be...read more
Q6. If I have to install an elevator in the Sabarmati building, give me 5-6 factors that I need to consider
Factors to consider when installing an elevator in the Sabarmati building
Building regulations and permits
Structural integrity of the building
Available space and layout
Electrical and mechanical requirements
Safety features and emergency protocols
Maintenance and servicing
Q7. How to cut a cake in 8 equal parts
Cut the cake in half, then cut each half in half again. Repeat once more to get 8 equal parts.
Use a long, sharp knife to make clean cuts.
Start by cutting the cake in half vertically.
Then cut each half in half horizontally.
Repeat the process once more to get 8 equal parts.
Use a cake divider or toothpicks to mark where to cut for even slices.
Q8. how did you identify improvement oppurtunities in process
I identified improvement opportunities in process by analyzing data, observing the process, and gathering feedback from stakeholders.
Analyze data to identify bottlenecks, inefficiencies, and areas for improvement
Observe the process to identify areas where steps can be eliminated or streamlined
Gather feedback from stakeholders to identify pain points and areas for improvement
Use process mapping and flowcharting to visualize the process and identify areas for improvement
Benchma...read more
Q9. What you know about US insurance industry ?
The US insurance industry is a multi-billion dollar industry that provides coverage for various risks and liabilities.
The industry is regulated at the state level
Major types of insurance include health, auto, home, and life insurance
The Affordable Care Act (ACA) has had a significant impact on the health insurance market
Insurance companies use actuarial science to determine premiums and assess risk
The industry is highly competitive with many large and small players
Natural dis...read more
Q10. What is Hypotheses concepts and how to use it? What is value stream mapping? Detail explanation of current project?
Hypotheses concepts are assumptions made to test a theory. Value stream mapping is a tool to visualize and improve processes.
Hypotheses concepts are used in scientific research to test a theory by making assumptions and testing them through experiments.
Value stream mapping is a lean management tool used to visualize and analyze the flow of materials and information in a process.
Current project details are not available.
Q11. Guesstimate- how many seats are there in a plane and train
The number of seats in a plane and train can vary depending on the size and type of the aircraft or train.
Planes can have anywhere from 20 seats in a small private jet to over 600 seats in a large commercial airliner like the Airbus A380.
Trains can have a few dozen seats in a small commuter train to hundreds of seats in a high-speed train like the Shinkansen in Japan.
The number of seats in a plane or train also depends on the class configuration (economy, business, first clas...read more
Q12. Tell me the difference between r square and adjusted r square
R square measures the proportion of variance explained by the independent variables, while adjusted R square penalizes for adding unnecessary variables.
R square increases as more variables are added, even if they are not significant
Adjusted R square increases only if the added variable improves the model more than would be expected by chance
Adjusted R square is always lower than R square
Adjusted R square is a better measure of the goodness of fit of a regression model
Q13. Usage analytics to increase outreach. How ?
Usage analytics can increase outreach by providing insights on user behavior and preferences.
Analyze user data to identify patterns and trends
Use analytics tools to track user engagement and conversion rates
Segment users based on their behavior and preferences
Tailor marketing campaigns and outreach strategies to target specific user segments
Monitor the effectiveness of outreach efforts through analytics metrics
Continuously optimize outreach strategies based on analytics insig...read more
Q14. Case study - Strategy to sell credit cards to Chennai population
Strategy to sell credit cards to Chennai population
Conduct market research to understand the needs and preferences of the Chennai population
Offer attractive rewards and benefits such as cashback, discounts, and reward points
Partner with local businesses to offer exclusive deals and discounts to credit card holders
Create targeted marketing campaigns in local languages and use social media to reach a wider audience
Provide excellent customer service and support to build trust an...read more
Q15. What RCA and CAPA? Tools which are used for quality analysis?
RCA stands for Root Cause Analysis and CAPA stands for Corrective and Preventive Action. Various tools are used for quality analysis such as Fishbone diagram, Pareto chart, Control chart, etc.
RCA is a process used to identify the underlying cause of a problem or an event.
CAPA is a process used to identify, correct, and prevent problems from recurring.
Fishbone diagram is a tool used to identify the possible causes of a problem.
Pareto chart is a tool used to identify the most s...read more
Q16. Guesstimates- Estimate number of kgs of paneer used in banglore per day
Approximately 500 kgs of paneer are used in Bangalore per day.
Estimate the population of Bangalore
Assume average consumption of paneer per person per day
Consider the number of restaurants and households in Bangalore
Factor in the demand for paneer-based dishes in Bangalore
Q17. Number of 0s in 1 to 1000
The number of 0s in 1 to 1000 is 192.
There are 1000 numbers from 1 to 1000.
Every 10 numbers have one 0 in the units place.
Every 100 numbers have ten 0s in the tens place.
Every 1000 numbers have one hundred 0s in the hundreds place.
Therefore, there are 1 + 10 + 100 + 81 = 192 0s in total.
Q18. How do you automate a report using Excel?
Automating a report in Excel involves using macros or VBA code to perform repetitive tasks and generate the report automatically.
Use Excel's built-in macro recorder to record your actions and generate VBA code.
Write VBA code to manipulate data, format cells, and generate charts or tables.
Schedule the report to run at specific times using Excel's built-in scheduling tools or external tools like Windows Task Scheduler.
Consider using Excel add-ins or third-party tools for more a...read more
Q19. How you will proceed to client problem ?
I will follow a structured approach to understand the problem and identify the root cause before proposing a solution.
Listen actively to the client's problem and ask relevant questions to gather more information.
Analyze the information gathered to identify the root cause of the problem.
Propose a solution that addresses the root cause and meets the client's needs.
Collaborate with the client to implement the solution and monitor its effectiveness.
Provide ongoing support to ensu...read more
Q20. Number of cycles sold in India annualy
The annual number of cycles sold in India varies depending on market trends and consumer demand.
The Indian bicycle market is highly competitive with a wide range of brands and models available.
Factors such as rising health consciousness, increasing traffic congestion, and environmental concerns have led to a growing demand for bicycles in India.
According to a report by Research and Markets, the Indian bicycle market is expected to grow at a CAGR of 7.5% during 2020-2025.
Howev...read more
Q21. how to do RPA feasibility
RPA feasibility can be determined by analyzing the process, identifying potential automation opportunities, and evaluating the technology and resources required.
Analyze the process to identify repetitive, rule-based tasks that can be automated
Evaluate the technology and resources required for automation
Assess the potential benefits and ROI of implementing RPA
Consider the scalability and complexity of the process
Perform a pilot test to validate the feasibility of RPA implement...read more
Q22. What is Hypothesis testing
Hypothesis testing is a statistical method used to determine whether a hypothesis about a population is likely to be true or not.
It involves formulating a null hypothesis and an alternative hypothesis
Collecting data and analyzing it using statistical methods
Making a decision to either reject or fail to reject the null hypothesis
Examples include testing the effectiveness of a new drug, or whether a coin is fair or biased
Q23. Pizzas sold at Domino's
Domino's sells a variety of pizzas with different toppings and crusts.
Domino's offers classic pizzas like pepperoni and margherita, as well as specialty pizzas like the Philly Cheese Steak and the Wisconsin 6 Cheese.
Customers can choose from a variety of crusts, including hand-tossed, thin crust, and Brooklyn style.
Domino's also offers gluten-free crust and vegan options.
Pizzas can be customized with additional toppings like mushrooms, onions, and peppers.
Domino's also offers...read more
Q24. Recent developments in analytics
Recent developments in analytics
Advancements in machine learning algorithms
Increased use of artificial intelligence in data analysis
Emergence of big data analytics
Integration of analytics with Internet of Things (IoT)
Growing importance of predictive analytics
Rise of real-time analytics
Q25. Inventory valuation methods
Inventory valuation methods are used to determine the value of goods held for sale or use in production.
FIFO (First-In, First-Out) method assumes that the first items purchased are the first items sold.
LIFO (Last-In, First-Out) method assumes that the last items purchased are the first items sold.
Weighted Average method calculates the average cost of all items in inventory.
Specific Identification method tracks the cost of each individual item in inventory.
Inventory valuation ...read more
Q26. Cumulative sum of sql
Cumulative sum in SQL is the running total of a column's values.
Use the SUM() function with the OVER() clause to calculate the cumulative sum.
The ORDER BY clause is used to specify the order of the rows for the cumulative sum calculation.
Example: SELECT column1, SUM(column2) OVER (ORDER BY column1) AS cum_sum FROM table_name;
Q27. Types of SQL joins
SQL joins are used to combine rows from two or more tables based on a related column between them.
Types of SQL joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
INNER JOIN returns rows when there is at least one 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 JOIN returns rows when there is a match in one of ...read more
Top HR Questions asked in I-Infotech
Interview Process at I-Infotech
Top Consultant Interview Questions from Similar Companies
Reviews
Interviews
Salaries
Users/Month