Candidatei-me online. O processo levou 6 semanas. Fui entrevistado pela Beyond, Inc. em abr. de 2018
Entrevista
The first Phone screening happened on last week of March with the hiring manager. The second interview was a technical SQL white boarding via webex happened a week after. This time it was more of a panel interview (7-8 people) and I wasn’t told that it will be a panel interview. So anyways it was an hour SQL white boarding which I did good. Then after a week’s follow up I was told that the team is finishing up other interviews. This update continued for almost a month. Then I was informed that I am one of the top choice and there are multiple roles with different other teams and I have to appear for another interview with another hiring manager. This time again there was phone screening (technical and behavioural) with couple of members from that team. Following week (May 1st week) I receive a rejection mail saying they got a stronger candidate. They had applied my profile through 3-4 position and suddenly they got candidates to fill all of their positions, seemed unrealistic. Felt like wasted a lot of time with them.
Perguntas de entrevista [1]
Pergunta 1
Mostly SQL Questions (joins, rank, row nums, subqueries), Tuning queries, Data Modeling, Data Warehousing Concepts, Unix,
Candidatei-me online. O processo levou 3 dias. Fui entrevistado pela Beyond, Inc. (Salt Lake City, UT) em abr. de 2016
Entrevista
I was basically searching for ETL Developer positions and came to know about this position in Glassdoor. Though the required tools and technologies were Oracle Golden Gate, Oracle Data Integrator and Microstrategy, somehow I have applied for the position as I wanted to take a chance as I am basically an Informatica ETL developer. Recruiter emailed me saying that the hiring panel was impressed by my resume ( I did not fake anything in my resume just stuck to the Informatica part).
I have answered all the questions with examples but they have sent me a automated reject mail the next day after the interview. I believe they rejected me because of my less hands on experience using the above mentioned tools except Informatica Powercenter.
Perguntas de entrevista [1]
Pergunta 1
1. How did you come know about the position?
2. Why did you leave your current job and why are you interested in this position?
3. Tell me about yourself
4. Describe your professional experience, explain your roles and responsibilities in the previous/current job.
5. How would you rate yourself in SQL out of 10?
6. Describe SCD Type 2 and Type 3 dimensions with examples.
7. What is CDC (Change Data Capture)? Can you explain with examples?
8. Explain about conformed, degenerate and junk dimensions with examples
9. Explain Fact less fact table, Transaction fact table and Accumulated snapshot fact table with examples
10. What is Ralph Kimball’s Data Warehouse approach?
11. Explain Snow Flake schema and Star schema with examples? Which one of the both schemas are normalized and de-normalized? Which schema design would you prefer in a real time environment?
12. Is Star schema preferred or Snow flake schema preferred? Explain and support your answer.
13. With what type of Schema have your worked previously?
14. Are you aware of Analytic functions in PL/SQL? List out different analytic functions and explain why are they used in real time?
15. What is RowNumber function in PL/SQL?
16. What are Rank and Dense Rank functions in PL/SQL? Explain the difference between them?