National Health Mission Data Scientist Interview Questions and Answers

Basic quant and apt questions

Run a model of ML or Dl

Q1. Check your interpersonal skills
Add your answer

Q1. Hr questions about my background with company
Add your answer
Q2. About my technical skills
Add your answer

Q1. Asked about my previous experience details
Add your answer
Q2. Asked about why I changed my job
Add your answer

About hospital and it's services

Power bi assignment was given to solve

Q1. Optimization techniques in sql
Ans. 
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
Answered by AI
Add your answer
Q2. Sub queries in sql
Ans. 
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);
Answered by AI
Add your answer
Q3. Types of Join in sql
Ans. 
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
Answered by AI
Add your answer
Q4. Time intelligence functions in power bi
Ans. 
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
Answered by AI
Add your answer
Q5. Logical questions in aptitude
Add your answer
Q6. Row level security in power bi
Ans. 
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, ...read more
Answered by AI
Add your answer

Basic English Grammar

Q1. Tell me about yourself. What was your role in previous organisation? Tell me about my last trip for 2 minutes.
Ans. 
I am a dedicated professional with experience in project management and team leadership.
• Led a team of 10 project coordinators in my previous organization

• Managed multiple projects simultaneously, ensuring deadlines were met

• Implemented new strategies to improve efficiency and productivity

• Received recognition for outstanding performance in project execution
Answered by AI
Add your answer

Q1. Tell me about your self What was your role in previous organisation
Ans. 
I am a dedicated professional with experience in project management and team leadership.
• Led a team of 10 project coordinators in planning and executing multiple projects simultaneously

• Managed project timelines, budgets, and resources to ensure successful project completion

• Collaborated with cross-functional teams to identify project requirements and deliverables

• Implemented project management best practices to improve ef...read more
Answered by AI
Add your answer

Q1. Why do we need hire you?
Ans. 
I bring a unique blend of skills, experience, and passion that aligns perfectly with your team's goals and values.
• Proven track record: In my previous role, I increased team efficiency by 20% through process improvements.

• Strong communication skills: I effectively collaborated with cross-functional teams to deliver projects on time.

• Adaptability: I quickly learned new software tools, which helped streamline our workflow a...read more
Answered by AI
Add your answer
Q2. No other questions
Add your answer

Q1. Random forest splitting mechanisms details
Ans. 
Random forest uses decision trees to split data into subsets based on feature importance.
• Random forest builds multiple decision trees and selects the best split based on feature importance.

• Each decision tree splits data into subsets based on a randomly selected subset of features.

• The best split is determined by minimizing impurity or maximizing information gain.

• Random forest can handle missing values and outliers.

• Rando...read more
Answered by AI
Add your answer
Q2. ResNet architecture and skip connection related questions
Add your answer

Q1. OCR related bounding box detection from image
Add your answer
Q2. Deep learning based questions and details
Add your answer

Q1. Salary discussion, current salary and expected
Add your answer
Q2. About Optum, why you want to join
Add your answer

Q1. Adf triggers and integration run time
Add your answer
Q2. How to copy data in add pipeline
Ans. 
To copy data in add pipeline, use a copy activity in Azure Data Factory.
• Use Azure Data Factory to create a copy activity in a pipeline.

• Specify the source dataset and sink dataset for the copy activity.

• Map the source and sink columns to ensure data is copied correctly.

• Run the pipeline to copy the data from source to sink.
Answered by AI
Add your answer