fifthnote - An Ensemble Health Partners Company Data Engineer Interview Questions and Answers

50 questions 12 mins

Q1. Quant based questions (P&C,Averages,probability) followed by case study
Add your answer

Two coding questions, one is easy and the other is difficult. Who solved 2nd question was shortlisted for an interview.

Q1. Introduce yourself—questions from OS, DBMS, DSA, Project, and one coding problem.
Add your answer

Q1. We need to complete 40 questions in 20 mins
Add your answer

Question related to Financial Statements, Different between GAAP & NON-GAAP

Q1. General Knowledge questions, Finance related Questions, having a good knowledge of all 3 Financial Statement is a plus point
Add your answer

Q1. Past Company and Family background, Salary related questions
Add your answer

Duration was around 105 minutes
aptitude, python and java were sections in this round

Q1. What are the languages based in sql
Ans. 
Languages based in SQL include T-SQL, PL/SQL, and SQL/PSM.
• T-SQL (Transact-SQL) is Microsoft's proprietary extension to SQL used in SQL Server.

• PL/SQL (Procedural Language/SQL) is Oracle's procedural language extension to SQL.

• SQL/PSM (SQL/Persistent Stored Modules) is a standard for defining stored procedures and functions in SQL.
Answered by AI
Add your answer
Q2. What do you understand by oops concepts
Ans. 
Object-oriented programming concepts that focus on classes and objects
• Encapsulation: bundling data and methods that operate on the data within a single unit

• Inheritance: ability of a class to inherit properties and behavior from another class

• Polymorphism: ability to present the same interface for different data types

• Abstraction: hiding the complex implementation details and showing only the necessary features
Answered by AI
Add your answer
Q3. Sql queries was asked to find the second highest salary
Add your answer
Q4. Java string question based on manipulation
Add your answer

Q1. Tell me about yourself
Add your answer
Q2. What are the projects that you have done
Add your answer
Q3. What are your hobbies and interest and what were your achievement in your school life and college life and was asked about the background check focused on candidate's qualities
Add your answer

Apptitude test is so easy it consists of English, technical mcqs

Q1. SQL rank function
Add your answer
Q2. Difference between count, count(*)
Ans. 
count(*) counts all rows in a table, while count(column_name) counts non-null values in a specific column.
• count(*) counts all rows in a table

• count(column_name) counts non-null values in a specific column

• count(*) is generally used to get the total number of rows in a table

• count(column_name) is used to count non-null values in a specific column
Answered by AI
Add your answer