1. I applied through the Siemens career portal for the specific role.
2. The next day, I received an email confirming the acceptance of my application and an HR representative asked if I was available for an interview.
3. There was a technical interview round, lasting about 40 minutes, which included coding, logical, and theoretical questions.

Tell me about yourself and your projects. Also, what tech stack are you using in your day-to-day work?

Which AWS services have you used (Hands-On)?

Tell me one use case and one limitation of an AWS Lambda function.

How many types of storage classes are available in AWS S3?

Describe the use case of PARTITION in terms of SQL or Data Warehouse.

Python Coding Questions:

1. Reverse a string in Python.
2. Take integer input from the 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 the 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 an 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.