J'ai postulé via une autre source. J'ai passé un entretien chez DevNatives (Islâmâbâd, ) en sept. 2020
Entretien
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.
Questions d'entretien [1]
Question 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?