Coronis Health Senior Analyst Interview Questions and Answers

After opening and closing doors with multiples of their numbers, which doors are open?

• Doors with odd number factors will be open after 100th time

• Doors with even number factors will be closed after 100th time

• Example: Door 16 will be closed after 100th time as it has factors 2, 4, 8, 16

333 digits can number 166 pages of a book.

• Each page number takes up 2 digits.

• The first page is numbered 01.

• The last page that can be numbered is 166.

• The remaining 2 digits are used for the cover page or other information.

To approach a customer for selling a costly new phone, I would focus on highlighting the unique features, benefits, and value it offers.

• Understand the customer's needs and preferences

• Highlight the unique features and benefits of the phone

• Emphasize the value and long-term benefits of investing in a high-quality phone

• Offer flexible payment options or financing plans

• Provide comparisons with other phones to showcase the su...read more

I will communicate the challenges and suggest alternative solutions.

• I will first analyze the task and identify the challenges.

• I will communicate the challenges to my manager and suggest alternative solutions.

• I will work with my manager to find a feasible solution.

• I will not waste time on a task that cannot be completed.

• For example, if the task requires a budget that is not available, I will suggest alternative ways to ...read more

The question is unclear and lacks context. More information is needed to provide an accurate answer.

• What is the context of the question? Is it related to a specific store or location?

• What is the timeframe for the question? Is it asking for current inventory or historical data?

• Are there any assumptions that can be made based on the information given?

• Without additional information, it is impossible to provide an accurate

ERP is a software that integrates various business processes and functions into a single system.

• ERP stands for Enterprise Resource Planning.

• It helps organizations streamline their operations and improve efficiency.

• Advantages of ERP include centralized data management, improved collaboration, and better decision-making.

• It automates processes like inventory management, financials, human resources, and customer relationsh...read more

DML, DDL, and TCL are terms used in SQL for manipulating and managing data.

• DML (Data Manipulation Language) is used for inserting, updating, and deleting data in a database.

• DDL (Data Definition Language) is used for creating, altering, and dropping database objects such as tables, indexes, and views.

• TCL (Transaction Control Language) is used for managing transactions in a database, including committing or rolling back ...read more

Inner joins, outer joins, and left join are types of SQL joins used to combine data from multiple tables.

• Inner join returns only the matching records from both tables.

• Outer join returns all records from both tables, including non-matching records.

• Left join returns all records from the left table and the matching records from the right table.

• Example: INNER JOIN customers ON orders.customer_id = customers.customer_id

• Exam...read more

Algorithm to optimize EXL interview process

• Identify key performance indicators (KPIs) for the interview process

• Use data analytics to track and analyze the KPIs

• Implement automation and AI to streamline the process

• Incorporate feedback from candidates and interviewers to continuously improve the process

Big data refers to large and complex data sets that cannot be processed using traditional data processing methods.

• Big data involves the collection, storage, and analysis of massive amounts of data

• It requires advanced technologies and tools to process and make sense of the data

• Examples of big data include social media data, sensor data, and financial market data

EXL offers a diverse range of projects and opportunities for growth, with a strong focus on innovation and technology.

• EXL provides a wide variety of projects in different industries, allowing for diverse experience and skill development.

• The company has a strong emphasis on innovation and technology, which aligns with my interests and career goals.

• EXL has a reputation for providing excellent training and development pro...read more

Iterating to check if a number is prime in C language requires justification.

• Iterating through all numbers up to the square root of the number is necessary to check if it is prime.

• The time complexity of this algorithm is O(sqrt(n)), which is efficient for small to medium-sized numbers.

• For larger numbers, more efficient algorithms like the Miller-Rabin primality test can be used.

• The number of iterations required depends...read more

Finding the triangle with max area given sides.

• Use Heron's formula to calculate the area of each triangle.

• Compare the areas and select the triangle with the maximum area.

• For sides 300, 400, 500, area = 60000 sq. units.

• For sides 300, 400, 700, area = 72000 sq. units.

Approximately 8000 balls can be placed with 49% wastage.

• Calculate the volume of the cube (10*10*10) and the volume of one ball (4/3*3.14*(0.5/2)^3)

• Divide the volume of the cube by the volume of one ball to get the maximum number of balls that can fit

• Calculate the volume of the placed balls and subtract it from the volume of the cube to get the wastage

• Wastage percentage can be calculated by dividing the wastage volume b

I want to be a part of EXL because of its reputation for innovation and excellence in the field of business analytics.

• EXL has a strong focus on innovation and technology, which aligns with my interests and skills.

• I am impressed by the company's track record of delivering high-quality solutions to clients across various industries.

• EXL's culture of collaboration and teamwork is something that I value and believe will hel...read more