Siemens Healthineers 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. Explain different types of HL7 messages
Add your answer
Q2. Difference between 1C 2C 3C attribute types in DICOM
Add your answer

Q1. Basic C# and oops questions , mostly on inheritance , abstraction ,encapsulation , properties
Add your answer
Q2. Coding questions related to strings finding longest substring without repeating characters , find the count of vowels in string with using dictionary kr hash ( used ascii value approach)
Add your answer

Q1. Mostly on project .
Add your answer
Q2. Was asked about design patterns , had to create a design for a simple . How would I structure all the folders classes , interfaces logics etc .
Add your answer

Q1. Self introduction
Add your answer
Q2. Preferences in life about your studies
Add your answer

Q1. Studies based from your overall whole randomly topic wise Qs
Add your answer
Q2. Base on your studies
Add your answer

Group discussion was amazing not to muuch difficult but based on anylitical or logical questions based
GD surrounds was lite not stressed.
Some hobbies question round

Must everyone to speak atleast on one question

Q1. Type of Filters in Tableau.
Ans. 
Tableau offers various types of filters including quick filters, context filters, and data source filters.
• Quick filters allow users to easily filter data by selecting values from a list.

• Context filters are applied before other filters, affecting the data visible to subsequent filters.

• Data source filters limit the data available to Tableau by filtering data at the data source level.

• Other types of filters include extract...read more
Answered by AI
Add your answer
Q2. Types of refresh in Tableau
Ans. 
There are two types of refresh in Tableau: Extract Refresh and Data Source Refresh.
• Extract Refresh: Refreshes the data in Tableau extract, which is a snapshot of data from the original data source.

• Data Source Refresh: Refreshes the data directly from the original data source.

• Examples: Extract Refresh is useful when working with large datasets to improve performance, while Data Source Refresh ensures real-time data upda
Answered by AI
Add your answer
Q3. Difference in Extract and live connection.
Ans. 
Extract connection imports data into Tableau workbook while live connection directly connects to data source.
• Extract connection creates a static snapshot of data in Tableau workbook.

• Live connection directly queries data from the source in real-time.

• Extract connection is useful for large datasets or when offline access is needed.

• Live connection is beneficial for real-time data analysis and dynamic updates.

• Example: Extra...read more
Answered by AI
Add your answer

Dsa and mcq dsa question were med to hard

Q1. Technical on resume and opps and sql
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