i
HCL Healthcare
Filter interviews by
Top trending discussions
I applied via Job Portal
Health safety, leadership, research project,
Neurosurgery cases emergency elective operations,
In a year, I aim to have gained more experience in consulting, developed strong client relationships, and taken on more leadership responsibilities.
Continue to build expertise in various industries and consulting methodologies
Establish and nurture strong relationships with clients to ensure satisfaction and repeat business
Seek opportunities to lead projects and teams to further develop leadership skills
I applied via Company Website and was interviewed before May 2021. There were 2 interview rounds.
Physical education is the study of physical activity and its effects on the body and mind.
Physical education involves the study of anatomy, physiology, and biomechanics.
It also includes the study of nutrition and how it affects physical performance.
Physical education can help prevent and manage chronic diseases such as obesity, diabetes, and heart disease.
Examples of physical education activities include sports, dance,...
The psychology of father's name refers to the impact of a father's name on an individual's psychological development and identity.
The father's name can influence a person's sense of identity and belonging.
It can shape their self-perception and how they relate to others.
The cultural and societal significance of the father's name can also play a role.
For example, in some cultures, carrying the father's name can confer a ...
Sigmund Freud is considered the father of child psychology.
Sigmund Freud is known for his work in psychoanalysis and his theories on child development.
He believed that early childhood experiences greatly influence adult personality and behavior.
Freud introduced concepts like the Oedipus complex and the stages of psychosexual development.
His work laid the foundation for modern child psychology and influenced many subseq
I applied via Naukri.com and was interviewed in Dec 2023. There were 2 interview rounds.
Power bi assignment was given to solve
Optimization techniques in SQL involve using indexes, query optimization, and proper database design.
Use indexes on columns frequently used in WHERE clauses to speed up query performance
Avoid using SELECT * and instead specify only the columns needed in the query
Optimize queries by using appropriate join types and conditions
Normalize database tables to reduce redundancy and improve query efficiency
Sub queries in SQL are queries nested within another query to retrieve data based on the result of the outer query.
Sub queries can be used in SELECT, INSERT, UPDATE, and DELETE statements.
They can be used to filter results, retrieve data from multiple tables, or perform calculations.
Example: SELECT * FROM table1 WHERE column1 = (SELECT column2 FROM table2 WHERE condition);
Types of joins in SQL include inner join, left join, right join, and full outer join.
Inner join: Returns rows when there is a 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 outer join: Returns all rows when there is a match in either table
Time intelligence functions in Power BI are used to analyze and compare data based on time periods.
Time intelligence functions help in calculating year-to-date, month-to-date, and other time-based calculations.
Functions like TOTALYTD, SAMEPERIODLASTYEAR, and PARALLELPERIOD are commonly used for time intelligence in Power BI.
These functions allow for easy comparison of data across different time periods and help in tren
Row level security in Power BI allows users to restrict access to specific rows of data based on their role or criteria.
Row level security can be implemented by creating roles in Power BI and defining rules to filter data based on user roles.
Users can be assigned to specific roles which determine the data they have access to.
Row level security helps in ensuring data privacy and compliance with regulations.
For example, ...
Reduce material cost by optimizing procurement, minimizing waste, and improving production efficiency.
Analyze procurement process to identify cost-saving opportunities
Negotiate with suppliers for better pricing and terms
Implement lean manufacturing principles to minimize waste
Improve production efficiency through automation and process optimization
Explore alternative materials or suppliers
Reduce product complexity to s
To improve contribution margin, focus on increasing revenue and reducing variable costs.
Increase prices or sales volume
Reduce direct material or labor costs
Improve production efficiency
Eliminate unprofitable products or services
Implement cost-saving measures
Negotiate better supplier contracts
Key performance areas include leadership, strategic planning, team management, financial management, and project execution.
Leadership: Ability to inspire and motivate teams towards achieving goals.
Strategic planning: Developing long-term plans to drive business growth.
Team management: Ensuring effective collaboration and communication within the team.
Financial management: Budgeting, forecasting, and monitoring financia...
I applied via Naukri.com and was interviewed before Jul 2020. There was 1 interview round.
based on 1 interview
Interview experience
based on 4 reviews
Rating in categories
Staff Nurse
35
salaries
| ₹0 L/yr - ₹0 L/yr |
General Physician
34
salaries
| ₹0 L/yr - ₹0 L/yr |
Dietician
33
salaries
| ₹0 L/yr - ₹0 L/yr |
Front Office Executive
26
salaries
| ₹0 L/yr - ₹0 L/yr |
Personal Health Coach
11
salaries
| ₹0 L/yr - ₹0 L/yr |
Apollo Hospitals
Fortis Healthcare
Max Healthcare
Manipal Hospitals