Prepare for and practice interview questions from Seatgeek.

Seatgeek Interview Questions

Seatgeek Interview Guides

Let’s say that your company is running a standard control and variant AB test on a feature to increase conversion rates on the landing page. The PM checks the results and finds a .04 p-value.

How would you assess the validity of the result?

Experiment Validity

Let’s say we have a table with an <code>id</code> and <code>name</code> fields. The table holds over 100 million rows and we want to sample a random row in the table without throttling the database.

Write a query to randomly sample a row from this table.

Input:

<code>big_table</code> table

<table>
<thead>
<tr>
<th>Columns</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>name</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>

Write a query to randomly sample a row from a big table.

Random SQL Sample

Suppose there exists a new airline named Jetco that flies domestically across North America. Jetco recently had a study commissioned that tested the boarding time of every airline, and it came out that Jetco had the fastest average boarding times of any airline.

What factors could have biased this result, and what would you look into?

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

Boarding Times Bias

A new airline came out as the fastest average boarding times compared to other airlines.  What factors could have biased this result and what would you look into?

Seatgeek Salaries by Position

SeatGeek believes live events are powerful experiences that unite humans. With our technological savvy and fan-first attitude we're simplifying and modernizing the ticketing industry. SeatGeek is a technology innovator on a mission to disrupt the $300 billion ticketing industry. We have the product, vision, and team to make life better for performers, venues, and fans, and build a generational consumer brand in the process. All we're missing is you. We are looking for a Software Engineer who is obsessed with solving complex data problems and is excited by the idea of expanding SeatGeek's ecosystem of data tooling, helping teams generate business value through data products. What you'll do <ul><li>Ship code to production many times a day across dozens of services</li><li>Build a new stream ingestion process to efficiently send and store currently live listings as users see them</li><li>Build and maintain our streaming data pipelines</li><li>Create tooling and services that support our machine-learning applications and data products</li><li>Evaluate new technologies and improve our software stack to keep our technological edge</li><li>Communicate and collaborate with different stakeholders, like Data Scientists, Analysts, Software Engineers, and our Product team to produce requirements and detailed designs</li></ul>What you have <ul><li>Experience building business-critical software in a fast-paced environment. We'll be interested in hearing about what you've built and how</li><li>Experience solving complex technical challenges. SeatGeek engineers create custom solutions to unique ticketing problems, including venue mapping, inventory tracking, and event matching. We'll be excited to hear about challenging problems you've solved</li><li>Passion for software craftsmanship and product. You have well-considered opinions about how software should work, and hold yourself and your code to a high standard</li><li>Commitment to your teammates. You enjoy working with a diverse group of people with different experiences and take pride in mentoring and learning from others</li></ul>Our stack You do not need experience with all of these, but we thought you might be curious. What we care about is your experience, skills, and approach to problem solving. Tools can be learned. <ul><li>Languages: Java and Python for general-purpose development</li><li>Frameworks: Airflow, Flink, Spark on EMR clusters for distributed processing</li><li>Stack: Docker containers running on k8s on AWS</li><li>Streaming: Flink, Debezium, and Kafka</li><li>Datastores: Postgres, Redshift and S3</li><li>Other: AWS Lambda, Git, dbt, Docker</li></ul>Perks: <ul><li>Equity stake</li><li>Flexible work environment, allowing you to work as many days a week in the office as you'd like or 100% remotely</li><li>A WFH stipend to support your home office setup</li><li>Unlimited PTO</li><li>Up to 16 weeks of paid family leave</li><li>401(k) matching program</li><li>Health, vision, dental, and life insurance</li><li>Up to $25k towards family building services</li><li>$500 per year for wellness expenses</li><li>Subscriptions to Headspace (meditation), Headspace Care (therapy), and One Medical</li><li>$120 per month to spend on tickets to live events</li><li>Annual subscription to Spotify, Apple Music, or Amazon music</li></ul> The salary range for this role is $165,000-$230,000. Actual compensation packages within that range are based on a wide array of factors unique to each candidate, including but not limited to skill set, years and depth of experience, certifications, and specific location. SeatGeek is committed to providing equal employment opportunities to all employees and applicants for employment regardless of race, color, religion, creed, age, national origin or ancestry, ethnicity, sex, sexual orientation, gender identity or expression, disability, military or veteran status, or any other category protected by federal, state, or local law. As an equal opportunities employer, we recognize that diversity is a positive attribute and we welcome the differences and benefits that a diverse culture brings. Come join us! #LI-Remote

SeatGeek believes live events are powerful experiences that unite humans. With our technological savvy and fan-first attitude we're simplifying and modernizing the ticketing industry. We are looking for a Platform Engineer to join SeatGeek's Cloud Platform team. As a Platform Engineer, you'll improve the systems that power the entirety of SeatGeek's technology ecosystem. As a member of the Cloud Platform team, you will be spearheading the development of cutting edge technologies within SeatGeek's core compute, infrastructure as code, database, and network infrastructure. SeatGeek has more services and deployments than developers, which means automation has to be the norm. This team is the backbone to our Enterprise and Consumer lines of business as we grow our primary and secondary ticketing platforms that support world-class clients such as the Dallas Cowboys, and Manchester City FC. What you'll do <ul><li>Bring a software engineers' mindset to SeatGeeks' unique scaling, workflow automation and resilience challenges</li><li>Build Golden Paths for infrastructure that help accelerate our teams' ability to deliver features quickly and with confidence</li><li>Build and maintain tools that our developers use to observe their applications, and drive initiatives to increase our overall reliability</li><li>Engineer resilient and observable networking infrastructure that supports a diverse set of workloads across multiple regions</li><li>Collaborate with other departments on how to run production systems and deployments with autonomy</li><li>Support teams with expertise in the area of deployment, configuration, routing, monitoring and scalability in all parts of the stack</li><li>Become a force multiplier by mentoring and leading the team around you</li><li>Participate in an on-call schedule to help our customers experience more live</li></ul>Who you are You love building resilient infrastructure but have an even greater love for how it's deployed and managed. You make decisions based on data and are not afraid of experimenting to get the information you need. While checking every item below isn't necessary, you have (or are keen to have!) some of the following: <ul><li>Passion for craftsmanship and product. You have well-considered opinions about how reliable infrastructure should work, and hold yourself and your code to a high standard</li><li>Experience working with AWS</li><li>Experience with Kubernetes, containers, and serverless compute platforms</li><li>Experience with service discovery and routing between microservices</li><li>Experience scripting in an interpreted language (application development and/or Go experience is a plus)</li><li>Experience with Relational and Non-relational databases</li><li>Experience with Configuration Management systems and Infrastructure as Code</li><li>Experience with continuous integration, delivery, testing, and code deployment </li><li>Experience using observability tools to make performance improvements and forecast growth</li><li>Experience improving system architecture, diagnosing shortcomings and implementing evidence-based recommendations </li><li>You can simplify complex topics to better suit a non-technical audience </li><li>Commitment to your teammates. You enjoy working with a diverse group of people with different experiences and take pride in mentoring and learning from others</li></ul>Our stack You do not need experience with all of these, but we thought you might be curious. What we care about is your experience, skills, and approach to problem solving. Tools can be learned. <ul><li>Languages: Go, Python, Bash</li><li>Runtimes: Kubernetes, Docker, ECS/Fargate, Lambda</li><li>Datastores: Postgres, SQL Server, Memcache, Redis, and Elasticsearch</li><li>Service Discovery and Routing: Cilium, Consul, Envoy, CoreDNS</li><li>Monitoring: DataDog</li><li>Incident Management:PagerDuty</li><li>Configuration Management: Chef, Ansible</li><li>Secrets Management: Vault</li><li>Infrastructure as Code: Cloudformation, Terraform</li><li>Cloud Providers: AWS</li><li>Version control: Git</li><li>CI / CD: Gitlab CI</li></ul>Perks <ul><li>Equity stake</li><li>Flexible work environment, allowing you to work as many days a week in the office as you'd like or 100% remotely</li><li>A WFH stipend to support your home office setup</li><li>Unlimited PTO</li><li>Up to 16 weeks of paid family leave</li><li>401(k) matching program</li><li>Health, vision, dental, and life insurance</li><li>Up to $25k towards family building services</li><li>$500 per year for wellness expenses</li><li>Subscriptions to Headspace (meditation), Headspace Care (therapy), and One Medical</li><li>$120 per month to spend on tickets to live events</li><li>Annual subscription to Spotify, Apple Music, or Amazon music</li></ul> The salary range for this role is $165,000-$230,000. Actual compensation packages within that range are based on a wide array of factors unique to each candidate, including but not limited to skill set, years and depth of experience, certifications, and specific location. SeatGeek is committed to providing equal employment opportunities to all employees and applicants for employment regardless of race, color, religion, creed, age, national origin or ancestry, ethnicity, sex, sexual orientation, gender identity or expression, disability, military or veteran status, or any other category protected by federal, state, or local law. As an equal opportunities employer, we recognize that diversity is a positive attribute and we welcome the differences and benefits that a diverse culture brings. Come join us! #LI-Remote

Seatgeek Interview Questions

Seatgeek Interview Guides

Seatgeek Interview Questions

Seatgeek Salaries by Position

Seatgeek Opening Jobs