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

Python based EDA assignment

Q1. Nilllllllllllllllllllllllll
Add your answer

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

They will ask general aptitude test

It was 30 minutes aptitude test

Q1. Salary related questions
Add your answer
Q2. Work related questions
Add your answer
Q3. They asked about last job details
Add your answer

Q1. Basic Machine Learning Question
Add your answer
Q2. Ask about Previous work or project
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