Smith & Nephew Healthcare Data Entry Operator Interview Questions and Answers

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

Easy but time limit was the main issue to address

Hard coding test on hacker earth platform no cameras and plagiarism tester will be on

Q1. What time intelligence functions can be used for ytd and qtd analysis
Ans. 
Time intelligence functions like YTD (Year-to-Date) and QTD (Quarter-to-Date) can be used for YTD and QTD analysis in data analytics.
• YTD analysis can be done using functions like YTD() or TOTALYTD() to calculate values from the beginning of the year up to the selected date.

• QTD analysis can be done using functions like QTD() or TOTALQTD() to calculate values from the beginning of the quarter up to the selected date.

• Thes...read more
Answered by AI
Add your answer
Q2. Difference between import and direct query
Ans. 
Import brings data into Power BI for further analysis, while direct query connects to data source in real-time.
• Import: Data is loaded into Power BI for analysis, improving performance but requiring periodic refreshes.

• Direct Query: Connects to data source in real-time, allowing for up-to-date information but potentially slower performance.

• Import is suitable for smaller datasets, while direct query is better for large da
Answered by AI
Add your answer

Q1. Prepare the reasoning skills
Add your answer

Q1. Pharma related knowledge
Add your answer

Q1. Need deep knowledge about the PVC and large volume parentals
Add your answer

Q1. Tell me about yourself
Ans. 
Experienced manager with a background in team leadership and project management.
• Over 5 years of experience in managing teams and projects

• Strong communication and problem-solving skills

• Proven track record of meeting deadlines and exceeding goals
Answered by AI
Add your answer
Q2. Why do you want to come here
Ans. 
I am drawn to the company's innovative approach and strong reputation in the industry.
• Impressed by company's track record of success

• Excited about opportunities for growth and development

• Align with company values and culture
Answered by AI
Add your answer

Q1. Technical architecture of any one project
Ans. 
The technical architecture of Project X involved a microservices-based approach with containerization using Docker and orchestration with Kubernetes.
• Utilized microservices architecture for scalability and flexibility

• Implemented containerization using Docker for easy deployment and management

• Utilized Kubernetes for orchestration and scaling of containers

• Used RESTful APIs for communication between microservices
Answered by AI
Add your answer
Q2. Functional explanation of any one project
Ans. 
Implemented a new CRM system to streamline customer interactions and improve data management.
• Identified key requirements for the CRM system through stakeholder interviews

• Collaborated with IT team to customize the system to meet specific business needs

• Conducted user training sessions to ensure smooth adoption of the new system
Answered by AI
Add your answer

Q1. Questions from gallup database
Add your answer
Q2. HR related questions
Add your answer

1 hr. General Accounting, Case studies etc.

Q1. Generic question on FP&A
Add your answer
Q2. Budget Vs. Forecast etc
Ans. 
Budget vs. Forecast involves comparing planned vs. predicted financial outcomes.
• Budget is a financial plan for a specific period, while forecast is a prediction of future financial outcomes.

• Budget is typically set at the beginning of a period, while forecasts are updated regularly based on new information.

• Budgets are usually more rigid and set in stone, while forecasts are more flexible and subject to change.

• Discrepanc...read more
Answered by AI
Add your answer
Q3. How to conduct budget
Ans. 
Budgeting involves planning and managing financial resources to achieve organizational goals.
• Identify financial goals and objectives

• Estimate income and expenses

• Allocate funds to different departments or projects

• Monitor and track spending

• Adjust budget as needed based on actual financial performance
Answered by AI
Add your answer
Q4. Do you have any process transition exp
Ans. 
Yes, I have experience in process transition.
• Led a team through a software system upgrade

• Managed the transition of a project from development to production

• Implemented new processes for a more efficient workflow
Answered by AI
View 2 more answers
Q5. How to manage multiple stakeholders
Ans. 
Managing multiple stakeholders involves effective communication, prioritization, and relationship-building.
• Establish clear communication channels with each stakeholder

• Understand the needs and expectations of each stakeholder

• Prioritize stakeholders based on their impact on the project

• Build strong relationships with stakeholders through regular updates and feedback

• Resolve conflicts and address concerns promptly
Answered by AI
View 1 more answer