Skip to contentSkip to footer
  • Community
  • Jobs
  • Companies
  • Salaries
  • For Employers
      Notifications

      Loading...

      Elevate your career

      Discover your earning potential, land dream jobs, and share work-life insights anonymously.

      employer cover photo
      employer logo
      employer logo

      Chewy

      Engaged Employer

      About
      Reviews
      Pay & benefits
      Jobs
      Interviews
      Interviews
      Related searches: Chewy reviews | Chewy jobs | Chewy salaries | Chewy benefits | Chewy conversations
      Chewy interviewsChewy Data Warehouse Engineer interviewsChewy interview
      Company Bowl sample

      Want the inside scoop on your own company?

      Check out your Company Bowl for anonymous work chats.

      Bowls

      Get actionable career advice tailored to you by joining more bowls.

      Followed companies

      Stay ahead in opportunities and insider tips by following your dream companies.

      Job searches

      Get personalized job recommendations and updates by starting your searches.



      Glassdoor

      • About / Press
      • Awards
      • Blog
      • Research
      • Contact Us
      • Guides

      Employers

      • Free Employer Account
      • Employer Center
      • Employers Blog

      Information

      • Help
      • Guidelines
      • Terms of Use
      • Privacy & Ad Choices
      • Do Not Sell Or Share My Information
      • Cookie Consent Tool
      • Security

      Work With Us

      • Advertisers
      • Careers
      Download the App

      • Browse by:
      • Companies
      • Jobs
      • Locations
      • Communities
      • Recent Posts

      Copyright © 2008-2026. Indeed, Inc. "Glassdoor," "Worklife Pro," "Bowls," and logo are proprietary trademarks of Indeed, Inc.

      Data Warehouse Engineer Interview

      Sep 24, 2021
      Anonymous Interview Candidate
      No offer
      Negative experience
      Difficult interview

      Application

      I applied online. The process took 4 weeks. I interviewed at Chewy in Sep 2021

      Interview

      The interview process was very slow. The recruiter did a horrible job coordinating the schedule & he was very disrespectful & unprofessional throughout the interview process. Before the first round screening, I submitted my availability & got an confirmation email with specific time & date for the 1st round interview. The recruiter called a day early without any notice & went thro my background & gave me an assessment link as next step. The assessment is simply couple multiple choice questions on HackerRank. Not difficult but tricky in term of small syntax error etc. After I submitted the assessment, it took over a week for the next round. The recruiter informed me that the next round would be a 1h technical round & No more details mentioned in the email. I simply followed up and tried to get more information in term of format & languages in the technical screening. The response from recruiter was "a resume review & overall introduction to some of the great things we are doing here at Chewy"! very helpful LOL... This round is quite technical with A LOTS of Data Warehouse design & performance tuning & SQL syntax & DW tools questions. Some regular behavior questions in the end as well. After the technical round, no response from the recruiter for the next step. I had to follow up after almost a week & in the meantime I got a offer. I informed the recruiter my status & tried to have him accelerate the process. It was not a smooth process for scheduling as usual. Finally the panel interviews scheduled a day before I need to get back to the other company. The panel round was about 3.5 hours with technical product manager, hiring manager, a senior member in the team, director of the team (45 min with each person), and a 15min wrap up with the recruiter. This round was quite intensive with a mix of DWE typical technical questions & behavior questions (a lots questions on how to handle priorities). The team is looking for a much more technical candidate for this role. After all the 45min rounds with the team, the recruiter was supposed to wrap up the interview for 15min. Guess what, HE DID NOT SHOW UP to the zoom call & NO RESPONSE to my emails either. I waited on the zoom for extra 10min but it is a NO SHOW in the end. Obviously I need to get back to the other company the second day and hoping to get some sort of response from Chewy. But the recruiter did not respond at all knowing that this is a time-sensitive situation. The day after I accepted the other offer, the recruiter sent an formal rejection email WITHOUT ANY APOLOGY FOR A NO SHOW!! To be honest, I like Chewy as a company, but come on! Please hire better people doing the recruiting job! This is literally the worst experience I ever had with any recruiters. The bare minimal principle -- be respectful & professional!

      Interview questions [1]

      Question 1

      What's slowly changing dimension? What's row based vs column based database? How do you diagnose the code that's running very slow? what kinds of performance tuning techniques you know? Tell me a time that you said no to the customer & what happened & how did you handle it?
      Answer question

      Jobs at Chewy

      57 jobs in United States
      Business Intelligence Manager, Pharmacy Operations
      Pittston, PA
      View job
      Business Intelligence Manager, Pharmacy Operations
      Louisville, KY
      View job
      Business Intelligence Engineer II
      Boston, MA
      ·
      $162K - $181K /yr
      (Employer provided)
      View job
      Data Engineer II
      Bellevue, WA
      ·
      $145K - $181K /yr
      (Employer provided)
      View job
      Software Engineer III
      Plantation, FL
      ·
      $141K - $225K /yr
      (Employer provided)
      View job

      Chewy interviews FAQs

      • Candidates applying for Data Warehouse Engineer roles take an average of 28 days to get hired, when considering 1 user submitted interviews for this role. To compare, the hiring process at Chewy overall takes an average of 18 days.
      • Common stages of the interview process at Chewy as a Data Warehouse Engineer according to 1 Glassdoor interviews include:

        Phone interview:  20%

        IQ intelligence test:  20%

        Group panel interview:  20%

        Presentation:  20%

        One on one interview:  20%

      • Here are the most commonly searched roles for interview reports -

        1. Customer Service Representative(564) ;
        2. Customer Service Representative (CSR)(214) ;
        3. Fulfillment Specialist(135) ;
        4. Pharmacy Technician(109) ;
        5. Forklift Operator(75) ;
        6. Warehouse Associate(66) ;
        7. Area Manager(59) ;
        8. Software Engineer(58) ;
        9. Order Picker
      (56) ;
    • Warehouse Worker(53) ;
    • Fulfillment Associate(51) ;
    • Operations Manager(45) ;
    • Customer Service(41) ;
    • Associate Director(40) ;
    • Manager(39) .
    • View all Data Warehouse Engineer Jobs