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

      Amherst

      Engaged employer

      About
      Reviews
      Pay and benefits
      Jobs
      Interviews
      Interviews
      Related searches: Amherst reviews | Amherst jobs | Amherst salaries | Amherst benefits
      Amherst interviewsAmherst Database Developer interviewsAmherst interview


      Glassdoor

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

      Employers

      • Free Employer Account
      • Employer Centre
      • Employers Blog

      Information

      • Help
      • Guidelines
      • Terms of Use
      • Privacy and 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. Glassdoor LLC. "Glassdoor," "Worklife Pro," "Bowls" and logo are proprietary trademarks of Glassdoor LLC.

      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 personalised job recommendations and updates by starting your searches.

      Top companies for "Compensation and Benefits" near you

      avatar
      Citi
      3.6★Compensation and benefits
      avatar
      J.P. Morgan
      3.8★Compensation and benefits
      avatar
      Morgan Stanley
      3.6★Compensation and benefits
      avatar
      Allianz
      3.6★Compensation and benefits

      Database Developer Interview

      16 Sept 2022
      Anonymous interview candidate
      No offer
      Negative experience
      Difficult interview

      Application

      I interviewed at Amherst

      Interview

      My initial call with the recruiter went great. He was extremely personable and happy to answer my questions. He was really impressed with my skills and experience, and eager to move me along in the interview process. Next I interviewed with the hiring manager who was not personable at all and was strangely judgmental the entire interview. He asked me about very specific SQL functions which we didn't use on my prior team so I didn't know a lot about them off the top of my head. He asked me to explain how I would use a SQL construct and then when I gave an example of how I used them every day, he said that he never used them. He also asked a lot of questions about my knowledge of accounting. I've worked in financial data warehouses so I'm familiar with finance from a data perspective, but I'm not an accountant. He was not impressed with my lack of accounting knowledge. But the worst part was when he asked me about my very first job out of college 8 years ago. I explained it was a basic data entry position and not very relevant to database development, but he grilled me for details. It was 8 years ago, I can't remember what applications they used. It felt as though every question was meant to be a "gotcha." Shockingly, I was asked back for a 3rd interview, which I almost didn't accept. I spoke with a product owner and a data operations manager. They talked a lot about culture, but then they started asking me about my accounting knowledge again. They also gave very contradictory answers about how collaborative their culture was, but they expected everyone to be autonomous.

      Interview questions [3]

      Question 1

      What is the difference between RANK, DENSE_RANK, and ROW_NUMBER?
      Answer question

      Question 2

      What is a CTE and how would you use it? (After giving my answer, he said he never uses CTEs in their codebase, so why ask about them?)
      Answer question

      Question 3

      What is your experience in accounting?
      Answer question
      1