Tide Business Finance Platform Data Engineer Interview Questions and Answers

Q1. Fibonacci sequence
Add your answer
Q2. Databricks cluster questions
Add your answer
Q3. Intermediate SQL questions from datalemur
Add your answer
Q4. Python questions from geeksforgeeks
Add your answer
Q5. ETL information
Add your answer

Q1. Advanced SQL: Window and aggregation
Add your answer

Q1. Python: Shallow copy and deep copy
Add your answer

Q1. Project architecture questions
Add your answer

75 min test with 18 Java theory questions

Q1. Synchronized keyword usage
Ans. 
The synchronized keyword in Java is used to control access to shared resources in a multithreaded environment.
• Synchronized keyword can be used to synchronize access to critical sections of code to prevent race conditions.

• It can be applied to methods or code blocks to ensure only one thread can access them at a time.

• Example: synchronized void myMethod() { // code }

• Example: synchronized(this) { // code }
Answered by AI
Add your answer
Q2. Message Queue types
Add your answer
Q3. Thread Contention
Add your answer
Q4. Java Profiling Tools
Add your answer
Q5. Abstract classes
Add your answer

Normal DSA round from hacker rank

DSA round from hacker rank or leetcode

Q1. With hiring manager
Add your answer

Q1. Same as posted in advice
Add your answer

Q1. Low Level Design: How to do rate limiting for a platform serving 100K requests per second.
Ans. 
Implement rate limiting for a platform serving 100K requests per second.
• Use a token bucket algorithm to limit the rate of incoming requests.

• Set a maximum number of tokens in the bucket to control the rate.

• Refill the bucket at a constant rate to allow bursts of requests.

• Track the timestamp of the last request to enforce the rate limit.

• Consider using a distributed rate limiting system for scalability.

• Monitor and adjust t...read more
Answered by AI
Add your answer

Q1. What techonologies do you know?
Ans. 
I am proficient in SQL, Python, R, Tableau, and Excel for data analysis and visualization.
• SQL

• Python

• R

• Tableau

• Excel
Answered by AI
Add your answer

SQL Coding Tests. You get 3 tables and they ask you to find customer with certain conditions. Not hard

Q1. Technical questions
Add your answer

Q1. Technical Questions
Add your answer

Q1. Salary Discussion
Add your answer