Solicité el puesto por otro medio. Acudí a una entrevista en DevNatives (Islamabad, ) en sept 2020
Entrevista
IT began the usual nice way. I was called for an interview for the position of Bi Developer. The interviewer talked with respect and asked rather more relevant questions and explained the problem they were trying to solve. Interviewer asked technical & relevant questions.
First Interview with Director of Information Technology, CEO .
Second Interview with HR for general question and Salary negotiation.
Preguntas de entrevista [1]
Pregunta 1
1. What is the difference between WHERE and HAVING Clause? And when we use where or Having explain with an example?
2. Write a query to find 3rd Maximum salary ? (Easy one)
3. Explain Normalization Types?
4. What is the difference between OLAP and OLTP?
5. Interviewer Provide me a scenario for query writing, I think it was like " Find those employees whos Average salary is greater than 100k department wise"
6. What is the difference between Union and Union ALL?
7. What is the difference between Delete and Truncate statement?
8. Difference between Fact and Dimensions?
9. Different type of Joins?
10. Types of SCD with Example?
