Piramal Group Interview Questions and Answers

Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity. Facts and dimensions are components of a star schema used in data warehousing.

• Normalization involves breaking down data into smaller, more manageable tables to reduce redundancy and improve data integrity.

• Facts are numerical data that can be analyzed, such as sales revenue or quantity sold.

• Dimensions are descriptive attributes related to the facts, such as product na...read more

High availability orchestrator is a tool that ensures continuous availability of critical systems and applications.

• HA orchestrator is used to minimize downtime and ensure business continuity.

• It monitors the health of systems and applications and automatically switches to a backup system in case of failure.

• Examples of HA orchestrators include Kubernetes, Docker Swarm, and Apache Mesos.

• Orchestrator API is a set of programming interfaces that allow developers to interact with th...read more

Estimating baseline of a demand prediction model involves analyzing historical data and trends to establish a starting point for future predictions.

• Collect and analyze historical demand data to identify patterns and trends

• Use statistical methods such as moving averages or exponential smoothing to calculate a baseline

• Consider external factors like seasonality, promotions, and market trends that may impact demand

• Validate the baseline by comparing it to actual demand data and ad...read more

Random Forest is like a group decision-making process where multiple opinions are combined to make a final decision.

• Random Forest is a machine learning algorithm that builds multiple decision trees and merges them together to get a more accurate and stable prediction.

• Each decision tree in the Random Forest is trained on a random subset of the data and features, and then the final prediction is made by averaging the predictions of all the trees.

• It is like asking multiple peopl...read more

Use CROSS JOIN to combine all rows from both tables

• Use CROSS JOIN to combine all rows from both tables

• Filter the results based on other conditions if needed

Estimate demand of a new product by analyzing market trends, conducting surveys, studying competitors, and considering pricing strategies.

• Conduct market research to understand consumer preferences and buying habits

• Analyze historical sales data of similar products to identify potential demand patterns

• Study competitors' sales and market share to gauge potential demand for the new product

• Consider pricing strategies and promotions to attract customers and drive demand

• Conduct surv...read more

I handle risk by conducting thorough risk assessments, developing mitigation strategies, and closely monitoring potential risks.

• Conducting thorough risk assessments to identify potential risks

• Developing mitigation strategies to minimize the impact of risks

• Closely monitoring potential risks and adjusting strategies as needed