OPTUMINSIGHT INDIA Senior Data Engineer Interview Questions and Answers

Analysing General capabilities on coding part

Q1. Coding hands on
Add your answer
Q2. Build an algorithm for ATM withdrawal logic
Ans. 
Algorithm for ATM withdrawal logic
• Determine the maximum amount that can be withdrawn based on account balance and daily withdrawal limit

• Check if the ATM has enough cash to dispense the requested amount

• If the requested amount is greater than the maximum withdrawal limit, reject the transaction

• If the ATM is out of cash, reject the transaction

• If the account balance is insufficient, reject the transaction

• If all conditions ...read more
Answered by AI
Add your answer

Q1. High level coding test
Add your answer
Q2. Train ticket booking algorthim once the ticket got cancelled by some user
Ans. 
Design an algorithm to handle train ticket cancellations and reallocate tickets efficiently.
• Identify the user who canceled the ticket and the details of the ticket.

• Update the database to mark the ticket as available for booking.

• Notify users on the waiting list about the newly available ticket.

• Implement a first-come, first-served policy for rebooking the canceled ticket.

• Consider refund processing for the canceled ticket...read more
Answered by AI
Add your answer
Q3. Build a data model for global warming
Ans. 
A data model for global warming should include various environmental factors and their impact on climate change.
• Include data on greenhouse gas emissions, temperature changes, sea level rise, and extreme weather events.

• Consider the impact of human activities such as deforestation and fossil fuel consumption.

• Incorporate data from various sources such as satellite imagery, weather stations, and scientific studies.

• Use stat...read more
Answered by AI
Add your answer