Can Fin Homes Data Engineer Interview Questions and Answers

Q1. What are the windows functions in sql
Ans. 
Window functions in SQL are used to perform calculations across a set of rows that are related to the current row.
• Window functions are used to calculate running totals, moving averages, and rank values.

• They are applied to a set of rows defined by an OVER clause.

• Examples of window functions include ROW_NUMBER, RANK, DENSE_RANK, and NTILE.
Answered by AI
Add your answer
Q2. Explain CTE in detail
Ans. 
CTE stands for Common Table Expression, a temporary named result set that can be referenced within a SELECT, INSERT, UPDATE, or DELETE statement.
• CTE is defined using the WITH keyword followed by a name and a SELECT statement.

• It can be used to simplify complex queries, improve readability, and reduce code duplication.

• CTE can also be recursive, allowing for hierarchical queries.

• Example: WITH sales AS (SELECT * FROM order...read more
Answered by AI
Add your answer

Q1. What is your expected salary
Add your answer

Q1. Asked about the projects from the resume. It was based on Python. The project was stock prediction using ml. They mainly asked about the concepts used. And they also asked the equations related to data sci...read more
Add your answer

Q1. I didn't qualified for this round
Add your answer

Python based EDA assignment

Q1. Nilllllllllllllllllllllllll
Add your answer

Q1. SQL related PL SQL , Stored PRocedures
Add your answer

Q1. Question on c, like storage classes
Add your answer
Q2. Can communication protocol, UDS protocol.
Add your answer
Q3. C coding on pointers.
Add your answer

Q1. It was more related to my projects
Add your answer
Q2. Asked questions on PCA,KNN and Elbow method .
Add your answer

Q1. Asked SVM and Logistic regression, their applications and real life uses
Add your answer
Q2. Matrix formation of a knockout Tournament
Add your answer