InFynd Data Engineer Interview Questions and Answers

I was hiring drive. First round was coding test with medium to advanced SQL, data modelling and python questions

Q1. Data model e commerce application
Add your answer
Q2. Higest nth rank and lowest rank if no of employees less than 2
Ans. 
If number of employees is less than 2, highest and lowest rank will be the same.
• If there are less than 2 employees, both highest and lowest rank will be the same.

• For example, if there is only 1 employee, their rank will be 1 which is both the highest and lowest rank.
Answered by AI
Add your answer
Q3. Event session data modeling
Add your answer

Q1. Sql-self join, non equi join, window funtion, consecutive seats, data modeling, stock market maximum profit sql question
Add your answer

Q1. This was hiring manager round. Detailed discussions on project and previous experience
Add your answer

Q1. Strength, weakness and why myntra
Add your answer

Q1. Question on sql and other stuff
Add your answer

Q1. Question on sql and other stuff
Add your answer

Q1. Question on sql and queries
Add your answer

Q1. 1) What is internal mechanism in spark . 2) tungsten project in spark explanation 3) sql problem to check where last two transaction belongs to particular retail
Ans. 
Questions related to Spark internals, Tungsten project, and SQL problem for retail transactions.
• Spark's internal mechanism includes components like Spark Core, Spark SQL, Spark Streaming, and MLlib.

• Tungsten project in Spark aims to improve the performance of Spark by optimizing memory usage and CPU utilization.

• To solve the SQL problem, we can use a query to filter transactions for a particular retail and then use the '...read more
Answered by AI
Add your answer

Q1. 1) scenario based question like , if a. job is launched with single executor will there be shuffling
Add your answer

Hackerrank test with medium level DSA and SQL questions

Q1. SQL joins and window functions
Add your answer
Q2. Big data optimisation techniques
Ans. 
Big data optimisation techniques involve strategies to improve the performance and efficiency of processing large volumes of data.
• Use of distributed computing frameworks like Hadoop and Spark to process data in parallel

• Implementing data compression techniques to reduce storage requirements

• Utilizing indexing and partitioning to optimize query performance

• Applying data pruning and filtering to reduce unnecessary data proc...read more
Answered by AI
Add your answer
Q3. DSA Medium level
Add your answer

Q1. Big data Eco system
Add your answer
Q2. SQL and Python related
Add your answer

Q1. Managerial round on a specific use case designing
Add your answer