Presidio Solutions Pvt Ltd Senior Data Engineer Interview Questions and Answers

Round duration - 40 minutes
Round difficulty - Medium

Asked about time complexity of algorithm, puzzles, DBMS, cutting edge technologies etc. What are indexes?

Q1. 
Flip Bits Problem Explanation
Given an array of integers ARR of size N, consisting of 0s and 1s, you need to select a sub-array and flip its bits. Your task is to return the maximum count of 1s that can b...read more
Ans. 
Given an array of 0s and 1s, find the maximum count of 1s by flipping a sub-array at most once.
• Iterate through the array and keep track of the maximum count of 1s obtained by flipping a sub-array.

• Consider flipping a sub-array from index i to j and calculate the count of 1s in the resulting array.

• Return the maximum count of 1s obtained by flipping a sub-array at most once.
Answered by AI
Add your answer

Round duration - 20 minutes
Round difficulty - Medium

Asked 1 standard algorithm

Q1. 
Number of Islands Problem Statement
You are provided with a 2-dimensional matrix having N rows and M columns, containing only 1s (land) and 0s (water). Your goal is to determine the number of islands in t...read more
Ans. 
Count the number of islands in a 2D matrix of 1s and 0s.
• Iterate through the matrix and perform depth-first search (DFS) to find connected 1s.

• Mark visited cells to avoid redundant traversal.

• Increment island count whenever a new island is encountered.
Answered by AI
Add your answer

Aptitude+coding was asked. Consider this as the very important selection criteria

Design test . Its very likely to be easy

Q1. Technical +HR was the last round. 1. Asked about SAP. 2.Basic python and oops concepts. 3.What does incture do 4. Will you accept any role we assign 5. How will your mechanical degree help us
Ans. Tell you are willing to later in training period you can request them to change your roles
Answered Anonymously
Add your answer
Q2. Why did you shift to mechanical
Add your answer
Q3. Be specific about this answer
Add your answer

Easy and good English passage reading

Q1. Projects coding dbms queries basic coding
Add your answer

Q1. SQL problems to solve nth highest salary
Ans. 
Use SQL query with subquery to find nth highest salary
• Use ORDER BY and LIMIT to get the nth highest salary

• Use a subquery to exclude the top n-1 salaries before selecting the nth highest salary
Answered by AI
Add your answer

Q1. GCP big query Architecture
Add your answer

Basics of SQL, Python

Experience based questions, SQL and Python

Q1. Tell me about the projects you worked on
Ans. 
I have worked on projects involving building data pipelines, optimizing data storage, and developing machine learning models.
• Built data pipelines using Apache Spark and Airflow

• Optimized data storage by implementing partitioning and indexing strategies

• Developed machine learning models for predictive analytics
Answered by AI
Add your answer
Q2. Based on experience some questions related to projects.
Add your answer