Testbook.com Data Engineer Interview Questions and Answers for Experienced

SQL two problem statements to be solved in 30 mins
Python two problem statements to be solved in 30 mins
Around 15 MCQ on stats and aptitude

Q1. Python, Excel, SQL and aptitude
Add your answer

Q1. Explain request lifecycle in rails?
Ans. 
Request lifecycle in Rails involves routing, controller actions, rendering views, and responding to the client.
• 1. Request comes in through the browser or API endpoint.

• 2. Rails router determines which controller and action to route the request to.

• 3. Controller action processes the request, interacts with the model, and prepares data for the view.

• 4. View template is rendered with the data from the controller.

• 5. Response ...read more
Answered by AI
Add your answer
Q2. Code Merge Sort using Ruby
Ans. 
Implement Merge Sort algorithm in Ruby
• Divide the array into two halves recursively

• Merge the sorted halves back together

• Use a helper method to merge the two halves
Answered by AI
Add your answer

Q1. Ask some questions about my self and previously what i did and some questions related to company...
Add your answer
Q2. Tell me about your self
Add your answer
Q3. What are the skills you have
Add your answer
Q4. Why are you choose this company
Add your answer

They share some apptitude questions and communication related questions to answer them...

Take a one topic from my self to discuss with other to communicate....how easily

Verbal, logical, Quantative test

Q1. Self introduction
Add your answer

Any general knowledge topic

Q1. Tell me about yourself
Ans. My Name is Sujitha Rajendran.I have completed Master of Business Economics at Ethiraj College for women. I am from Namakkal district and searching for job opportunities now. My Father is a business man. My Mother is a home maker and My Brother is a Software Engineer
Answered by treasuredsangria
Add your answer
Q2. Strength and weakness
Add your answer
Q3. Short term and long term goal
Ans. 
Short term goal is to enhance data analysis skills, long term goal is to become a data science expert.
• Short term goal: Improve proficiency in SQL, Python, and data visualization tools

• Long term goal: Obtain advanced certifications in machine learning and AI

• Short term goal: Complete online courses on statistical analysis and data cleaning

• Long term goal: Lead data science projects and mentor junior analysts
Answered by AI
Add your answer
Q4. Why did you chosen this company?
Ans. My Strength is that I am not only a hard working person but also a smart working person. I am a quick learner and self motivational person. I am a good team player, good listener and good in time management
Answered by treasuredsangria
Add your answer
Q5. Why we want to hire you?
Add your answer
Q6. Salary discussion
Add your answer

Two dynamic programming challenges at the hard level on LeetCode and 10 medium-level SQL challenge.

Python technical SQL basic

SQL, Analytical, Maths

Q1. SQL qsn on some data
Add your answer
Q2. Qsn on LLMs in company
Add your answer