Siemens Senior Software Engineer - Data Engineering interview questions

Which AWS services you have used (Hands-On)? Tell me one use case and one limitation of AWS Lambda function?

How many types of Storage Classes available in the AWS S3?

Describe use case of PARTITION in terms of SQL or Data Warehouse?

Python Coding Question: 1. Reverse a string in python. 2. Take integer input from user and check if the given number is prime or not.

SQL Query Writing: **Table EMP** Input Columns: EMPID, DEPID, SAL, DOJ Output Columns: EMPID, DEPID, SAL, DOJ, NEXT_SAL NEXT_SAL can be derived as the salary of immediate next employee in the given records.

SQL Query Writing: **TABLE A** Columns: Col1 col2 Col3 Data: 1 ABCD 987 1 CDER 234 1 MBCV 444 1 VCXDF 345 **TABLE B** Columns: Col1 col4 Col5 Data: 1 cd 123 1 VG 876 1 XX 456 1 CC 765 Task: Implement Inner join, Left Outer join and Full outer join and provide the number of output records for each type of join?

SQL Query Writing: **Table A** Columns: col1 col2 **Table B** Columns: col3 col4 There is no common column to implement the JOIN condition and the Required Output is: col1, col2, col3, col4