Fivetran logo

Fivetran Software Engineer Interview Questions
& Process

Real candidates share what happened, how many rounds they had,
and how the experience turned out.

Based on 67 interview experiences · FREE TO READ

3.1 Rounds average
Average Typical difficulty
70.1% Positive experience

Candidate interview experiences

First-hand accounts from people who interviewed at Fivetran.

Showing 3 of 67
Fivetran logo
Fivetran

Software Engineer

Engineering · a year ago

Mid Average Neutral experience No offer 3 rounds
Interview process
Recruiter call Phone screen Technical screen Offer
Interview formats
Behavioral Technical Coding

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.

Confirmed questions2 questions
  • 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.
Fivetran logo
Fivetran

Software Engineer

Engineering · a year ago

Senior Average Negative experience No offer 1 round
Interview process
Recruiter call
Interview formats
Other

I applied online for the senior software engineer position. A recruiter reached out to me about my availability, and I provided it. When we joined the call, the recruiter dropped off after about a minute. I sent follow-up emails because I didn't know what was happening. I waited for 40 minutes and then left the meeting. The recruiter messaged later that day saying their laptop restarted, and they didn't even bother to call me about the issue. They then asked for another availability, and I gave them three different slots. I still haven't heard back from the recruiter. Because of this, I had to reschedule another interview, which was such a waste of time and disheartening for a job seeker.

Confirmed questions0 questions

No confirmed questions were included in this interview report.

Fivetran logo
Fivetran

Software Development Engineer

Engineering · a year ago

Entry Average Positive experience No offer 4 rounds
Interview process
Take home Technical screen Technical screen Technical screen Panel
Interview formats
Coding Coding Coding Behavioral

Basically there were four rounds total. The questions were kinda medium level LeetCode style, so it was manageable. Round 1 was an Online Assessment with two medium coding questions. Round 2 was a Coding Round with two more medium questions. Round 3 was focused on Low-Level Design. Round 4, the Hiring Manager round, included both behavioral questions and coding.

Confirmed questions3 questions
  • Tell me about a question involving a DAG.
  • Can you explain a question that used Binary Search?
  • How would you design an app like booking.com?

Fivetran Software Engineer 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

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

Could you discuss the pros and cons of normalizing versus denormalizing a database?

Read reports

Can you design an app similar to Cowin for vaccine rollout?

Read report

Given two arrays for arrival times and desired door direction (in/out), determine when each person uses the door, ensuring no simultaneous use. The door defaults to 'in'. If multiple people try to use it at once, the prior direction takes priority. If no one is using it, it resets to 'in'. Aim for linear time complexity. Please share your estimated interview time and years of experience if you solve this.

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 do you approach analyzing the complexity of a software solution?

Read report

Formats, difficulty and experience

Across all 67 Fivetran interview reports.

Interview formats

Coding 36.5%
Behavioral 25.4%
Technical 22.3%
System Design 13.7%
Other 1.5%

Interview difficulty

Easy 10.4%
Average 67.2%
Difficult 22.4%

Candidate experience

Neutral 9%
Positive 70.1%
Negative 20.9%