Aller au contenuAller au pied de page
  • Emplois
  • Entreprises
  • Salaires
  • Pour les employeurs

      Boostez votre carrière

      Découvrez votre salaire potentiel, décrochez des emplois de rêve et partagez vos témoignages de manière anonyme.

      employer cover photo
      employer logo
      employer logo

      Petal

      Est-ce votre entreprise ?

      À propos
      Avis
      Salaires et avantages
      Emplois
      Entretiens
      Entretiens
      Recherches associées: Avis sur Petal | Offres d’emploi chez Petal | Salaires chez Petal | Avantages sociaux chez Petal
      Entretiens chez PetalEntretiens d’embauche pour Senior Data Engineer chez PetalEntretien chez Petal


      Glassdoor

      • À propos
      • Récompenses
      • Blog
      • Nous contacter
      • Guides

      Employeurs

      • Compte employeur gratuit
      • Centre employeur
      • Blog pour les employeurs

      Informations

      • Aide
      • Règles de la communauté
      • Conditions d'utilisation
      • Confidentialité et choix publicitaires
      • Ne pas vendre ni partager mes informations
      • Outil de consentement aux cookies

      Travailler avec nous

      • Annonceurs
      • Carrières
      Télécharger l'application

      • Parcourir par :
      • Entreprises
      • Emplois
      • Lieux

      Copyright © 2008-2026. Glassdoor LLC. « Glassdoor », son logo, « Worklife Pro » et « Bowls » sont des marques déposées de Glassdoor LLC.

      Entreprises suivies

      Tenez-vous au courant des dernières opportunités et profitez de conseils d’initiés en suivant les entreprises de vos rêves.

      Recherche d’emplois

      Obtenez des recommandations et des mises à jour personnalisées en démarrant vos recherches.

      Entretien pour Senior Data Engineer

      2 févr. 2021
      Candidat à l'entretien anonyme
      Aucune offre
      Expérience négative
      Entretien facile

      Candidature

      J'ai postulé via un recruteur. J'ai passé un entretien chez Petal en janv. 2021

      Entretien

      To start had a 30 minute phone call with one of their tech recruiters and went over what i was looking for along with what what the role and company was all about. I should start by saying - the mission seem solid, maybe just the folks they have interviewing are trying to serve some self purpose (get their own people in) or just are not experienced enough. Next were all the tech rounds with two members of the data engineering team. First one was with a guy on the data eng team that gave me a couple schemas and had a bunch of sql questions. There are always multiple ways of going about any question - if he wanted something specific he should have asked about it. I answered all the questions correctly and thoughtfully. I constantly checked to ensure he was ok with my solution (which he was) and it made sense. He actually was not really familiar with common concepts in sql (even case statements, as he took 10 mins to try and walk through my solution in his head bc he didnt get it lol). I dont believe he was quite qualified to interview me as he didn't know basics. From the feedback i got this is the interview where i was told my sql is not strong enough. This interview is where my negative feedback stems from, it is frustrating i was penalized bc the interviewer was not knowledgeable and qualified. Second interview was pretty good in my opinion, it was a higher level design problem. Guy seemed pretty straight forward and as if he knew what was going on. Great conversation - nothing negative here. I was told a couple days later that the first tech round did not go how they wanted and they would not be moving forward. My advice for the organization. Please have qualified engineers conduct interviews. It is a complete waste of my time to work on an at home assignment (which the more i think of it, might have just been something they needed done and farmed out to interviewers) and multiple interviews if I can't be judged by a competent engineer.

      Questions d'entretien [9]

      Question 1

      SCHEMAS: cards customer_id (INT) card_number (VARCHAR) open_date (DATE) 3612 4733-8080 2/15/2020 1825 5743-6687 2/3/2020 1825 4521-3390 5/15/2020 transactions transaction_id (INT) card_number transaction_datetime (UTC) transaction_amount (DECIMAL) 2214 5743-6687 02/20/2020 17:00 122.76 2652 5743-6687 02/27/2020 08:15 3.63 3456 4521-3390 06/02/2020 13:44 89.17 daily_customer_addresses customer_id home_address state report_date 2051 123 Main St NY 08/29/2020 2051 123 Main St NY 08/30/2020 2051 123 Main St NY 08/31/2020
      1 réponse

      Question 2

      Q: How many cards has customer '1544' had?
      Répondre à cette question

      Question 3

      Q: Which customers have not made any transactions with any card?
      Répondre à cette question

      Question 4

      Q: By customer by month, what is the total value of transactions?
      Répondre à cette question

      Question 5

      Q: Given the card table, and given that a customer can only have one open card at any given time, how would you determine each card's close_date?
      Répondre à cette question

      Question 6

      Q: What is each customer's current card_number?
      Répondre à cette question

      Question 7

      Q: List all transactions that were, at the time of the transaction, the largest transaction to date.
      Répondre à cette question

      Question 8

      Q: Using the daily_customer_addresses table, provide all the contiguous date ranges when customer '2051' lived on 123 Main St.
      Répondre à cette question

      Question 9

      SYSTEM DESIGN: This model isn’t very user friendly for analysts. We want to build an analytical model within Redshift. Here are some of the questions these analysts might want to answer: 1.) How many applications were approved? How many yesterday? 2.) How many of these applications were manually decisioned? 3.) How many potential customers dropped off between Prequalification and Application? 4.) What is our distribution of customers by income?
      Répondre à cette question
      6

      Autres retours d’entretien d’embauche pour un poste comme Senior Data Engineer chez Petal

      Entretien pour Senior Data Engineer

      11 déc. 2020
      Candidat à l'entretien anonyme
      Aucune offre
      Expérience négative
      Entretien moyen

      Candidature

      J'ai postulé en ligne. J'ai passé un entretien chez Petal en oct. 2020

      Entretien

      A 30 minute background call with a recruiter followed by a take home data loading and transformation assignment. If you pass the take home then the recruiter will schedule a full day face to face meeting over Zoom with about 11 people over a span of 6+ hours

      Questions d'entretien [5]

      Question 1

      Tell me about the time you had a challenge in a project
      Répondre à cette question

      Question 2

      Tell me about the time you disagreed with someone on your team
      Répondre à cette question

      Question 3

      SQL aggregation and window function questions applied to a certain dataset
      Répondre à cette question

      Question 4

      Can you design a sql script and report pipeline given a couple of tables?
      Répondre à cette question

      Question 5

      SQL: Calculate moving average of a metric
      Répondre à cette question
      1

      Entretien pour Senior Data Engineer

      20 janv. 2019
      Candidat à l'entretien anonyme
      New York, NY
      Aucune offre
      Expérience négative
      Entretien difficile

      Candidature

      J'ai postulé via un recruteur. Le processus a pris 1 semaine. J'ai passé un entretien chez Petal (New York, NY) en janv. 2019

      Entretien

      A recruiter from the company contacted me for the position of a senior data engineer in New York. He scheduled me with someone for a CoderPad exercise. I was called three minutes late. The call lasted about thirty minutes.

      Questions d'entretien [1]

      Question 1

      Write a constant-time Python 3 implementation of LRU cache. Use any Python data structures. The provided unit tests must pass. You have 15 minutes.
      2 réponse(s)

      Meilleures entreprises pour « Rémunération et avantages » près de chez vous

      avatar
      Amazon
      3.7★Rémunération et avantages
      avatar
      Google
      4.5★Rémunération et avantages
      avatar
      Amazon Web Services
      3.9★Rémunération et avantages
      avatar
      TikTok
      3.6★Rémunération et avantages