Schiller Healthcare India Manager / Sr Manager - Administration Interview Questions and Answers for Experienced

General aptitude questions, analytical and logical reasoning

Q1. Can you explain the Design diagram for your previous project
Add your answer
Q2. Explain any performance improvement you made in your project
Add your answer

Q1. Basic C# and oops questions , mostly on inheritance , abstraction ,encapsulation , properties
Add your answer
Q2. Coding questions related to strings finding longest substring without repeating characters , find the count of vowels in string with using dictionary kr hash ( used ascii value approach)
Add your answer

Q1. Mostly on project .
Add your answer
Q2. Was asked about design patterns , had to create a design for a simple . How would I structure all the folders classes , interfaces logics etc .
Add your answer

Convert Number to words

Q1. SOLID principles with real time examples
Ans. 
SOLID principles are a set of guidelines for writing maintainable and scalable code.
• Single Responsibility Principle: A class should have only one reason to change.

• Open/Closed Principle: A class should be open for extension but closed for modification.

• Liskov Substitution Principle: Subtypes should be substitutable for their base types.

• Interface Segregation Principle: Clients should not be forced to depend on interfaces ...read more
Answered by AI
Add your answer

Nice aptitude questions of logical reasons and data interpretation

Q1. Why should we hire you?
Add your answer
Q2. What does your previous colleagues describe you?
Add your answer
Q3. Self introduction
Add your answer
Q4. General questions from resume
Add your answer

SWOT ANALYSIS OF A NEW PRODUCT IN THE MARKET

RESEARCH ASSIGNMENT ON THE TB SPACE

Q1. Do you know adobe analytics
Ans. 
Yes, I am familiar with Adobe Analytics and have experience using it for data analysis.
• I have used Adobe Analytics to track website traffic and user behavior

• I have created custom reports and dashboards using Adobe Analytics

• I am proficient in extracting insights from Adobe Analytics data to drive business decisions
Answered by AI
Add your answer
Q2. Explain example of window function
Ans. 
Window functions are used to perform calculations across a set of table rows related to the current row.
• Window functions are applied to a set of rows related to the current row in a query result.

• They can be used to calculate running totals, averages, ranks, and more.

• Examples include ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE().
Answered by AI
Add your answer

Q1. Explain example of window function
Ans. 
Window functions are used to perform calculations across a set of table rows related to the current row.
• Window functions are used in SQL to perform calculations within a specific window or subset of rows.

• They allow you to perform aggregate functions like SUM, AVG, COUNT, etc. over a specific range of rows.

• Examples include ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE().
Answered by AI
Add your answer
Q2. A question using aggregate function and case when in sql
Add your answer