Jasper Colin Senior Manager Interview Questions and Answers

1. The online test includes questions related to spark and a coding questions.

Q1. Questions related to sql , spark, data structures were asked
Add your answer
Q2. 1. Questions based on window functions (rank, dense_rank)
Add your answer

Q1. Overall discussion of the projects that you have worked on.
Add your answer

Q1. Guesstimate and industry analysis structure
Ans. 
Industry analysis structure involves market sizing, segmentation, competition analysis, and growth projections.
• Start with defining the industry and its key players

• Estimate market size by analyzing relevant data and trends

• Segment the market based on demographics, geography, or other factors

• Analyze competition by identifying major competitors and their market share

• Project growth by considering factors like technological
Answered by AI
Add your answer
Q2. SWOT analysis of EV market
Ans. 
The EV market has strengths in environmental benefits and government incentives, but faces challenges with infrastructure and range limitations.
• Strengths: Environmental benefits, government incentives

• Weaknesses: Infrastructure limitations, range limitations

• Opportunities: Technological advancements, increasing consumer interest

• Threats: Competition from traditional vehicles, lack of charging infrastructure
Answered by AI
Add your answer

Q1. What is difference between function and stored procedure
Ans. 
Functions return a single value, while stored procedures can perform multiple operations and return multiple values.
• Functions return a single value, while stored procedures can return multiple values.

• Functions are called in SQL statements, while stored procedures are called using EXECUTE statement.

• Functions cannot have output parameters, while stored procedures can have output parameters.

• Functions cannot modify server ...read more
Answered by AI
Add your answer
Q2. How to implement custom exception in MVC
Ans. 
Custom exceptions can be implemented in MVC by creating a new class that inherits from Exception class.
• Create a new class that inherits from Exception class

• Override the constructor to pass a custom message to the base Exception class

• Throw the custom exception in the MVC controller or service layer
Answered by AI
Add your answer

Q1. Your past experience
Add your answer
Q2. Why are you interested in this position?
Add your answer

Online reputation related questions with real case studies.

Q1. What is ORM and tell me best practices?
Ans. 
ORM stands for Object-Relational Mapping, a programming technique for converting data between incompatible type systems in object-oriented programming languages.
• ORM helps in mapping objects to database tables and vice versa

• Avoid using ORM for complex queries as it can lead to performance issues

• Use lazy loading to optimize performance by loading data only when needed
Answered by AI
Add your answer
Q2. How do you handle work pressure?
Add your answer

Q1. About the studies and the work related with experience
Add your answer
Q2. About technical round around the work experience
Add your answer

Basic aptitude questions

Q1. Basic questions about rcm
Add your answer

Basic guesstimates and profit-loss case study

Detailed case study on problem solving in pharma supply chain

Q1. Interview with the senior leaders, very friendly and basic HR questions
Add your answer
Q2. Why do you want to work here?
Add your answer
Q3. What differentiates you from others?
Add your answer