Fivetran Software Development Engineer 3 Interview Questions and Answers

1 hour duration. Sliding window problem. On hacker rank platform. Expected to write a working code and solve it optimally/scalable solution.

Q1. Again a coding test. LLD + hash map. 1 hour on hacker rank.
Add your answer

Q1. Types of filters
Ans. 
Types of filters include low-pass, high-pass, band-pass, and band-stop filters.
• Low-pass filter allows frequencies below a certain cutoff frequency to pass through.

• High-pass filter allows frequencies above a certain cutoff frequency to pass through.

• Band-pass filter allows a specific range of frequencies to pass through.

• Band-stop filter blocks a specific range of frequencies from passing through.
Answered by AI
Add your answer

Q1. Project Details
Add your answer

Q1. Mimic Dataframe Merge
Ans. 
Implement a function to mimic the functionality of merging two DataFrames in Python.
• Create a function that takes two DataFrames as input.

• Merge the two DataFrames based on a common column or index.

• Handle different types of joins like inner, outer, left, and right joins.

• Return the merged DataFrame as output.
Answered by AI
Add your answer
Q2. Improve above case by case
Add your answer

1 hour - Find longest palindromic substring

Question on dsa and string theory along with oops concepts

Q1. Question on java strings and arrays
Add your answer

Q1. Basic javascript questions and node js questions and problem solving skills
View 7 more answers

Q1. Architecture of the projects/products worked. integration between the two systems and in depth/ES6 features on JavaScript
Ans. 
I have worked on projects with scalable architecture and integrated multiple systems using ES6 features in JavaScript.
• Developed a microservices-based architecture for a healthcare platform using Node.js and React

• Integrated payment gateway systems with e-commerce websites using REST APIs

• Implemented ES6 features like arrow functions, template literals, and destructuring for cleaner code

• Used Webpack for bundling and Babel...read more
Answered by AI
Add your answer

Q1. Technical knowledge on architecture and AWS
Add your answer

Q1. How was i managed work in previous employer. and achievements
Add your answer

Q1. There was simple DSA question ,
Add your answer

Q1. Composer dependency management
Add your answer

System design of atm

Q1. Salary, location, flexibility
Add your answer

The assessment included a written test comprising multiple-choice questions (MCQs) based on technical knowledge and aptitude. Each correct answer was awarded 1 mark, while incorrect answers incurred a penalty of -0.25 marks. The subsequent section featured two coding questions and two SQL queries, for which candidates were required to write the complete code.

Q1. Diff between HTTP and HTTPS
Ans. 
HTTP is unsecured protocol while HTTPS is secured protocol using SSL/TLS encryption.
• HTTP stands for Hypertext Transfer Protocol, while HTTPS stands for Hypertext Transfer Protocol Secure.

• HTTP operates on port 80, while HTTPS operates on port 443.

• HTTP does not encrypt data, while HTTPS encrypts data using SSL/TLS.

• HTTPS provides authentication and data integrity, while HTTP does not.

• Example: http://www.example.com vs htt
Answered by AI
Add your answer