example of a time when you gave exceptional customer service. time when you managed conflict time when you made a mistake time when you went beyond the call of duty time when you took initiative time when gave feedback time when you had to tell someone about a decision that would affect them
Questions regarding optimization and datawarehouse
Q. Most questions about what could be the result from two table data presented before us . Minus , Left outer Join ( Duplicate Twist ) , Union vs Union ALL , ROW_NUMBER () ,Rank () , DENSE_RANK() ..etc , Q.Which Architecture do you use in your Project ( STAR vs SnowFlake - Why SF is not Good ?) Q. What is Surrogate Key Q. How did you validate Data from Stage to EDW - Example Q. What is your Validation Strategy on Large data set Q. SCD Type - Example pls
-Analytical Sql queries -General sql questions -Perfomance tuning -ETL scenario qeustoin.
SQL scenario based queries and unix
Query for finding duplicated records
Oracle queries about aggregate function
Tell me about a time when you were doing a group project and it failed. How did you respond?
Tell me about a time when you showed resiliency
They ask a lot of "tell me about a time...." or "explain how you did/overcame..." to see if you can navigate through a scenario and provide context, outcome, learnings.
Viewing 1011 - 1020 interview questions