Fivetran Senior Software Engineer 2 Interview Questions and Answers

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

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

Q1. Confidential to disclose
Add your answer

Q1. Confidential not to disclose
Add your answer

Q1. Confidential not to disclose
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. How can we improve the performance of a Front End System
Ans. 
Improving Front End System Performance
• Optimize images and reduce their size

• Minimize HTTP requests and use caching

• Use lazy loading for images and videos

• Reduce the number of DOM elements

• Use a Content Delivery Network (CDN)

• Minimize the use of external scripts and plugins

• Use asynchronous loading for scripts

• Optimize CSS and JavaScript files

• Use browser caching

• Implement server-side rendering
Answered by AI
Add your answer
Q2. What is Event Loop and give an example on how it works.
Ans. 
Event Loop is a mechanism that allows JavaScript to handle multiple tasks simultaneously.
• Event Loop is a part of JavaScript runtime that continuously checks the call stack and the task queue.

• It prioritizes the tasks in the queue and pushes them to the call stack when it's empty.

• This allows JavaScript to handle I/O operations and other asynchronous tasks without blocking the main thread.

• Example: setTimeout() function ad...read more
Answered by AI
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