
Fivetran Interview Questions
& Process
Real candidates share what happened, how many rounds they had,
and how the experience turned out.
Based on 257 interview experiences · FREE TO READ
Which role are you interviewing for?
30 roles · 257 reportsCandidate interview experiences
First-hand accounts from people who interviewed at Fivetran.
Web Analytics Manager
I had 1 recruiter screen, then 1 hiring manager screen which was very thorough and had many technical questions. After that, I moved to the project stage, which involved creating a presentation answering specific questions based on several related datasets. This project was due within 48 hours, a much tighter deadline than usual for a project of this size. I did ask for a small extension. The project was meant to be presented to a panel who would then ask questions. The day after I submitted my project, the recruiter emailed saying they weren't moving forward with the actual interview. Their reasoning was that I got most answers wrong, which I find hard to believe given my extensive QA. They wanted to use their time with more qualified candidates. In my experience as a hiring manager and panelist, I've never canceled an interview, and I found this to be disrespectful and a waste of my time. This experience left a bad impression, and I wouldn't apply to FiveTran again.
- Could you describe the types of websites you've worked on and your experience with GA4?
Senior Site Reliability Engineer
I recently interviewed for this role and unfortunately had a disappointing experience. The interviewer’s tone came across as overly bossy and somewhat intimidating, which made the conversation uncomfortable. Additionally, many of the questions asked were not aligned with the job description. While I understand that interviews can explore adjacent skills, the discussion felt deliberately off-track and did not reflect the core requirements of the role. Overall, the process could benefit from a more professional and candidate-friendly approach, with better alignment between the interview questions and the advertised job responsibilities.
- Questions about EKS.
- Questions about K8s.
Software Engineer
So, first there was this chat with the TA person, just a quick rundown of the job and some basic stuff like if I’m eligible to work and what experience I have. Then, I talked to the hiring manager. That interview was more in-depth about the role and my background, and they asked things like how I deal with tough situations and what my biggest accomplishment was. After that, there was a technical test, a medium-level LeetCode/HackerRank type of thing where I had to code in C. I explained my approach, and the interviewer seemed okay with it, but the problem was a bit tricky, and I couldn't finish all the test cases. I figured it out after the interview and let the interviewer know. The recruiter then mentioned that the position was actually filled two weeks prior, which was confusing since they were still interviewing me. But overall, the process was smooth, and the interviewers were nice.
- Can you share your most significant achievement?
- Solve longencodedstring, given a string like 12#3(5)421(8), where each number is mapped to English letters, count the occurrences of each letter and return resulting array.
Account Manager
I had a great interview experience with Fivetran. The process was well-structured, with clear communication at every stage. The interviewers were professional, engaging, and focused on evaluating both technical expertise and problem-solving skills. A special thanks to Smita Paul, who supported me throughout the process. She was incredibly helpful, always available to answer questions, and ensured a smooth experience. Smita's proactive approach and encouragement made a real difference—I truly believe we need more recruiters like her!
- What challenges did you face in your last job and how did you overcome them?
Fivetran Interview Questions
Quoted word for word from Fivetran interview reports.
“Solve longencodedstring, given a string like 12#3(5)421(8), where each number is mapped to English letters, count the occurrences of each letter and return resulting array.”
Read reports →“Given a bag with 6 items ([1, 1, 1, 2, 2, 3]) and the ability to remove 2 items, find the minimum number of unique IDs left in the bag.”
Read reports →“Can you convert an encoded string to a frequency array? For example, 1224#26# maps to abxz, and 1224#(2)26#(4) maps to abxxzzzz. Please return the frequency array for the given input.”
Read reports →“Can you explain why a negative ARR entry might appear before a renewal in the database?”
Read reports →“Could you solve run-length encoding problems with code that passes all test cases?”
Read report →“Could you discuss the pros and cons of normalizing versus denormalizing a database?”
Read report →“What is the High-Level Design for a feature and the Database design for the system?”
Read report →“Could you design an ETL system for moving data from one SQL database to another?”
Read report →“How can we address client feedback that data movement is a black box, especially considering transparency and potential legal compliance breaches?”
Read report →Formats, difficulty and experience
Across all 257 Fivetran interview reports.