Discussion started with ETL flow to SQL Queries. Testing questions were : difference between star and snowflax, ETL flow in current project. SQL questions were : Set operators, Difference between union and union all, Delete,drop and truncate. Asked to write queries on given scenarios. scenarios were based on Sub string, In string, Replace, Translate, Minus. Gave 3 select statements and asked how it works. group by and having function flow
project explanation and compensation details ?
Unix based question
What COUNT(*) returns?
Describe the differences between the types of joins in a relational SQL database.
Standard interview and technical questions.
2nd highest salary from table
My Name
Mostly specific questions about SSIS / SSRS tables, indexes, data flows (this was the first panel). The second panel was more about communication, why I want to leave my high paying job, etc.
I do not recall any difficult or unexpected questions
Viewing 251 - 260 interview questions