UNC REX Healthcare Data Analyst Intern Interview Questions and Answers

Very Easy aptitude..

Q1. Tell me about yourself
Add your answer
Q2. Why do you want to join Google
Add your answer

Q1. You have 3 jars each with labels, one jar is labeled Apples, one is labeled Oranges and one is Apples and Oranges however all the jars are labeled incorrectly. you can pick one fruit from each jar how can ...read more
Add your answer

Q1. Case studies, puzzle , Sql, guesstimate, projects
Add your answer

Q1. Puzzles, probability, work experience
Add your answer

Q1. Python, pyspark
Add your answer

Q1. Behavioral round
Add your answer

Q1. Tell me about yourself
Ans. 
I am a Senior Data Analyst with 5+ years of experience in analyzing complex data sets and providing actionable insights.
• 5+ years of experience in data analysis

• Proficient in statistical analysis and data visualization tools such as Python, R, and Tableau

• Strong problem-solving skills and ability to communicate findings to non-technical stakeholders
Answered by AI
Add your answer
Q2. Asked about recent project
Add your answer
Q3. Types of join in sql
Ans. 
Types of join in SQL include inner join, outer join, left join, right join, and full join.
• Inner join: Returns rows when there is a match in both tables

• Outer join: Returns all rows when there is a match in one of the 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 join: Returns ro
Answered by AI
Add your answer
Q4. Case when statement questions
Add your answer

Business Related case study, signed NDA

Q1. Count number of Parameters in BERT
Add your answer
Q2. 3 sum array problem
Add your answer

They gave a span of 3 days to build an AI-powered webapp

Q1. How would you go about learning a new skill
Add your answer
Q2. Experience in cloud technologies
Ans. 
I have experience working with cloud technologies such as AWS, Azure, and Google Cloud Platform.
• Experience in setting up and managing virtual machines, storage, and networking in cloud environments

• Knowledge of cloud services like EC2, S3, RDS, and Lambda

• Experience with cloud-based data processing and analytics tools like AWS Glue and Google BigQuery
Answered by AI
Add your answer

Q1. Tell me about yourself
Add your answer
Q2. Project details and challenges faced in the project
Ans. 
Developed a predictive model for customer churn in a telecom company
• Collected and cleaned customer data from various sources

• Performed exploratory data analysis to identify key factors influencing churn

• Built and fine-tuned machine learning models to predict customer churn

• Challenges included imbalanced data, feature engineering, and model interpretability
Answered by AI
Add your answer

Q1. Sql windows function
Add your answer
Q2. Joint function, it's application and definition
Ans. 
Joint function refers to the movement and stability of joints in the body.
• Joint function involves the movement of bones at a joint.

• It also includes the stability provided by ligaments and tendons.

• Examples include the knee joint allowing bending and straightening of the leg.

• Another example is the shoulder joint allowing rotation and lifting of the arm.
Answered by AI
Add your answer
Q3. Windows function , definition, application
Add your answer
Q4. Simple coding test online
Add your answer
Q5. Some question on python, tableau
Add your answer