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

      Vetspire

      Is this your company?

      About
      Reviews
      Pay and benefits
      Jobs
      Interviews
      Interviews
      Related searches: Vetspire reviews | Vetspire jobs | Vetspire salaries | Vetspire benefits
      Vetspire interviewsVetspire Senior Engineer (ETL) interviewsVetspire 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.

      Senior Engineer (ETL) Interview

      1 May 2024
      Anonymous interview candidate
      No offer
      Negative experience
      Average interview

      Application

      I applied online. I interviewed at Vetspire in Mar 2024

      Interview

      I interviewed for this job over a month ago but was ghosted. First round casual conversation, second round takehome, third round technical interview (takehome review + system design), plus final rounds of behavioural/meet the team/culture/founder sign-off The takehome consisted of receiving a binary file, and having to extract the information to export into a CSV file. The information had a caesarean cipher applied to it (specifically ROT13), so what you need to do is read in the file (I did this by pulling all the strings from the file), organizing it by row (the rows are grouped into First Name, Last Name, email + Date (sometimes), and zip code + email), split the rows from the file into different columns, apply the ROT13 shift to get it back to normal, and save that dataframe into a csv. Keep in mind there is a name column missing, and there is sometimes an extra character added to the end of some lines randomly. With this, you should be able to solve it quickly

      Interview questions [1]

      Question 1

      The takehome consisted of receiving a binary file, and having to extract the information to export into a CSV file. The information had a caesarean cipher applied to it (specifically ROT13), so what you need to do is read in the file (I did this by pulling all the strings from the file), organizing it by row (the rows are grouped into First Name, Last Name, email + Date (sometimes), and zip code + email), split the rows from the file into different columns, apply the ROT13 shift to get it back to normal, and save that dataframe into a csv. Keep in mind there is a name column missing, and there is sometimes an extra character added to the end of some lines randomly. With this, you should be able to solve it quickly
      Answer question