Bread Financial Senior Data Engineer Interview Questions and Answers

Q1. Spark optimisation
Add your answer

Java coding questions, basic Java questions.

Q1. Java basics questions.
Add your answer
Q2. Live coding.
Add your answer

Q1. Discussion on previous experience and projects.
Add your answer
Q2. System design question
Add your answer

Q1. Questions on SQL, Java advanced, personal projects, Java frameworks, UI based questions, Agile methodologies.
Add your answer
Q2. Interview discussion with the whole team.
Add your answer

Q1. Benefits discussion.
Add your answer
Q2. Salary discussion.
Add your answer

Sql, python, statistical questions

Q1. How daily work looks like?
Ans. 
Daily work involves analyzing data, creating reports, and communicating findings to stakeholders.
• Reviewing and cleaning data sets

• Creating visualizations and dashboards

• Conducting statistical analysis

• Communicating insights to non-technical stakeholders
Answered by AI
Add your answer
Q2. Most ise tools?
Ans. 
Some of the most commonly used tools for data analysis include Excel, Python, R, Tableau, and SQL.
• Excel is widely used for data manipulation and analysis.

• Python and R are popular programming languages for data analysis and machine learning.

• Tableau is a powerful data visualization tool.

• SQL is essential for querying databases and extracting data.
Answered by AI
Add your answer

4 sql tasks on 3 tables. Joins, subqueries

It consist of 4 DSA ques and few quiz and opps concept based ques
1st was string based Medium level ques.
2nd was a ques based on 2 pointer
And other 2 was from Vector and Linked list easy ques

Q1. It was stock buy and sell ques on leetcode where we need to find Max profit and what day to buy and sell
Add your answer
Q2. 2d array ques to print natural numbers in spiral form
Ans. 
Print natural numbers in spiral form using a 2D array.
• Create a 2D array with dimensions n x n.

• Initialize variables for row and column boundaries.

• Iterate through the array in a spiral pattern, filling in natural numbers.
Answered by AI
Add your answer
Q3. Hard level linked list ques
Add your answer

Q1. Describe projects
Ans. 
I have worked on various projects including developing web applications, creating mobile apps, and implementing machine learning algorithms.
• Developed a web application for a retail company to manage inventory and sales data

• Created a mobile app for a fitness tracking platform to track user's exercise routines

• Implemented machine learning algorithms for a recommendation system in an e-commerce website
Answered by AI
Add your answer
Q2. Knowledge testing on ML frameworks
Add your answer

Had a overall personality, technical & problem solving test with AVP

Q1. Types of Window Function
Ans. 
Window functions are used in SQL to perform calculations across a set of table rows related to the current row.
• Types include ROW_NUMBER(), RANK(), DENSE_RANK(), NTILE(), LAG(), LEAD(), FIRST_VALUE(), LAST_VALUE(), etc.

• They allow for calculations to be performed on a specific subset of rows within a query result set.

• Window functions are commonly used for running totals, moving averages, and ranking data.
Answered by AI
Add your answer
Q2. Difference between Joins with examples
Ans. 
Joins are used to combine rows from two or more tables based on a related column between them.
• Inner Join: Returns rows when there is a match in both tables.

• Left Join: Returns all rows from the left table and the matched rows from the right table.

• Right Join: Returns all rows from the right table and the matched rows from the left table.

• Full Outer Join: Returns rows when there is a match in one of the tables.

• Cross Join:
Answered by AI
Add your answer

Technical sql questions

Oops concept and sql db questions

Q1. Dependency injection
Add your answer

MVVM was asked and swift questions