Fragen in Vorstellungsgesprächen bei Overstock.com für ETL Developer | Glassdoor.de

Fragen in Vorstellungsgesprächen bei Overstock.com für ETL Developer

Vorstellungsgespräche bei Overstock.com

2 Bewertungen von Vorstellungsgesprächen

Erfahrung

Erfahrung
50%
0%
50%

Einladung zum Vorstellungsgespräch

Einladung zum Vorstellungsgespräch
100%

Schwierigkeit

3,0
Durchschnittl.

Schwierigkeit

Schwer
Durchschnittl.
Leicht

 

ETL Developer-Vorstellungsgespräch

Anonymer Bewerber im Vorstellungsgespräch
Kein Angebot
Negative Erfahrung
Durchschnittl. Gespräch

Bewerbung

Ich habe mich online beworben. Der Vorgang dauerte 6 Wochen. Vorstellungsgespräch absolviert im April 2018 bei Overstock.com.

Vorstellungsgespräch

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.

Fragen im Vorstellungsgespräch

  • Mostly SQL Questions (joins, rank, row nums, subqueries), Tuning queries, Data Modeling, Data Warehousing Concepts, Unix,   Frage beantworten

Andere Bewertungen von Vorstellungsgesprächen für Overstock.com

  1. Hilfreich (1)  

    ETL Developer-Vorstellungsgespräch

    Anonymer Bewerber im Vorstellungsgespräch in Salt Lake City, UT (Vereinigte Staaten von Amerika)
    Kein Angebot
    Positive Erfahrung
    Durchschnittl. Gespräch

    Bewerbung

    Ich habe mich online beworben. Der Vorgang dauerte 3 Tage. Vorstellungsgespräch absolviert im April 2016 bei Overstock.com (Salt Lake City, UT (Vereinigte Staaten von Amerika)).

    Vorstellungsgespräch

    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.

    Fragen im Vorstellungsgespräch

    • 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?   1 Antwort

Verpassen Sie nicht Ihren Traumjob
Laden Sie Ihren Lebenslauf hoch, um sich schnell und einfach für Jobs zu bewerben. Bewerben leicht gemacht!