Mu Sigma Data Engineer Interview Questions, Process, and Tips

Q1. Pyspark, sql, Python.
Add your answer

Q1. Python, dsa,PySpark
Add your answer

Q1. Simple questions
Add your answer

Q1. Windows function on sql
Ans. 
Window functions in SQL are used to perform calculations across a set of table rows related to the current row.
• Window functions are used to calculate values based on a set of rows related to the current row

• They do not cause rows to become grouped into a single output row like aggregate functions

• Common window functions include ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE()
Answered by AI
Add your answer

Q1. Pandas questions
Add your answer

Q1. Asked regarding the previous project
Add your answer

Python problem questions
SQL problem questions

Q1. 1. Difference between shallow copy and deep copy 2. How can you merge two dataframes with different column names 3. Regex question to find all the characters and numbers of particular length size 4. Spark ...read more
Ans. 
1. Shallow copy creates a new object but does not duplicate nested objects. Deep copy creates a new object and duplicates all nested objects. 2. Merging dataframes with different column names requires renaming columns. 3. Regex can be used to find characters and numbers of a specific length. 4. Spark fundamentals involve understanding distributed computing and data processing.
• Shallow copy: new object with same referenc...read more
Answered by AI
Add your answer

Q1. 1. Design data architecture for a particular scenario 2. Spark optimisation questions for the given scenario
Add your answer

Q1. This was my director round where all the business related ettiquitess, emotional quotient and plans to remain in the society.
Add your answer

Q1. Basic salary discussion and company policies
Add your answer

Aws, scala and cloud concept

Q1. Python question
Add your answer

General Aptitude test and 3 Medium level coding questions

Q1. Sortr an array of 0,1
Ans. 
Sort an array of 0s and 1s
• Use a sorting algorithm like counting sort or two-pointer approach

• Count the number of 0s and 1s and then reconstruct the array

• Example: Input array = ['0', '1', '0', '1', '1'], Output array = ['0', '0', '1', '1', '1']
Answered by AI
Add your answer
Q2. Matrix traversal in spiral Manner
Ans. 
Matrix traversal in spiral manner involves visiting each element of a matrix in a spiral order.
• Start by traversing the outermost layer of the matrix from top left to top right, then top right to bottom right, bottom right to bottom left, and finally bottom left to top left.

• Continue this process for the inner layers until all elements are visited.

• Keep track of the boundaries of the matrix to know when to switch directio
Answered by AI
Add your answer

Q1. What is pip in python
Ans. 
pip is a package manager for Python that allows you to install and manage libraries and dependencies.
• pip is used to install Python packages from the Python Package Index (PyPI)

• It can also be used to uninstall packages, upgrade packages, and list installed packages

• Example: 'pip install numpy' installs the numpy package
Answered by AI
Add your answer
Q2. Questions on join
Add your answer

Leet Code Medium, string, list, tuple