I applied online. The process took 1 week. I interviewed at Siemens in Apr 2024
Interview
1. I applied through Siemens career portal for the specific role.
2. Next day, I got the mail for acceptance of my application and HR asked me if I am available for the interview
3. There was Technical Interview round for about 40 min, in which coding, logical and theoretical questions asked.
Interview questions [8]
Question 1
Tell me about yourself and your projects. Also, what tech stack you are using in day to day work?
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