Apollo Hospitals Data Engineer Interview Questions and Answers

There were 2 SQL queries based on rank function and count aggregation. 1 python program based on array.

Q1. 2 sql questions. Was asked which technology I worked on- aws redshift.
Add your answer
Q2. Architecture of redshift. keys in redshift.
Ans. 
Redshift is a cloud-based data warehousing solution by AWS. It uses columnar storage and massively parallel processing.
• Redshift is based on PostgreSQL and uses SQL for querying data.

• It uses columnar storage which is optimized for analytical queries.

• Redshift is a massively parallel processing (MPP) system, which means it can distribute queries across multiple nodes for faster processing.

• It uses key-based sharding to dis...read more
Answered by AI
Add your answer
Q3. 1 python program on sliding window technique .
Ans. 
Sliding window technique is used to solve problems where we need to find a substring of a certain length in a larger string.
• Define the window size and slide it over the string

• Use two pointers to keep track of the start and end of the window

• Examples: Maximum sum subarray of size K, Longest substring with K distinct characters
Answered by AI
Add your answer

Q1. 3 sql queries. architecture for a data pipeline to display hour per activity in last 24 hra on a smartwatch .
Ans. 
Design a data pipeline to display hourly activity on a smartwatch for the last 24 hours using SQL queries.
• Create a table to store activity data with columns for timestamp and activity type.

• Use a SQL query to aggregate activity data by hour for the last 24 hours.

• Display the results on the smartwatch using a suitable visualization.
Answered by AI
Add your answer

Q1. What have been doing in your current role
Add your answer
Q2. Letting them know about the normal workflow and additional to that job what am i doing that will help for my growth
Add your answer

Q1. Basics of python and javascript
Add your answer

Q1. About family and relocation
Add your answer
Q2. Relocation and family members
Add your answer

Q1. RDD, Datafram, dataset difference
Add your answer
Q2. Find the 2nd hightest salary
Add your answer
Q3. What is ADF in azure
Ans. 
ADF in Azure stands for Azure Data Factory, a cloud-based data integration service that allows you to create, schedule, and manage data pipelines.
• Azure Data Factory (ADF) is used to orchestrate and automate data movement and data transformation.

• It supports a wide range of data sources, including Azure Blob Storage, Azure SQL Database, and on-premises data sources.

• ADF allows you to create data pipelines using a visual i...read more
Answered by AI
Add your answer

Q1. In depth project based qiestions
Add your answer

Simple coding test related to fundamental of programming

Q1. Question related to UI/UX, Promises, JS fundamentals
Add your answer

Q1. Detailed discussion on questions related to last round
Add your answer

Q1. Basic salary discussion and policies discussion
Add your answer

Q1. Tell me about your self
Ans. 
I am a detail-oriented individual with strong data entry skills and a passion for accuracy.
• Experienced in data entry tasks such as inputting information into databases

• Proficient in using Microsoft Excel and other data entry software

• Strong attention to detail and ability to maintain accuracy in high-volume data entry tasks
Answered by AI
Add your answer
Q2. Why we should hair you
Add your answer

Q1. Tell me about your self
Ans. 
I am a detail-oriented individual with strong data entry skills and a passion for accuracy.
• Experienced in data entry tasks such as inputting information into databases

• Proficient in using Microsoft Excel and other data entry software

• Strong attention to detail and accuracy in data entry work

• Ability to work efficiently under pressure and meet deadlines
Answered by AI
Add your answer
Q2. Why we should hire you
Ans. 
I am detail-oriented, efficient, and have a strong background in data entry.
• I have a proven track record of accurately entering data in a timely manner.

• I am proficient in using data entry software and have a fast typing speed.

• I have excellent attention to detail and can spot errors quickly to ensure data accuracy.
Answered by AI
Add your answer