fifthnote - An Ensemble Health Partners Company ETL Developer Interview Questions and Answers

Q1. SQL group by, Java opps
Add your answer

There will be two sessions in first round , first there will be 60+ of aptitude and second session will be of reasoning which consists of 15 questions ,but overall they will give you 90 mins of time to complete all the questions and result will be displayed immediately whether you qualified for next round or not

There will be coding round after qualifying the first round and these will be hard , many of students will disqualify in this round

Most of the questions from the quant ,they covered mostly train problems , work and time ,pipes,simple interest,profit and loss

Comprehensive questions covered wide range of topics

Coding was typically

Q1. What programming language were used to develop the test.
Add your answer

Q1. About work life balance
Add your answer

Q1. Can you tell me about yourself?
Add your answer
Q2. What is your experience in your current company?
Ans. 
I have 5 years of experience in my current company working in various roles.
• Started as a junior associate and worked my way up to a senior position

• Led multiple projects and teams, showcasing strong leadership skills

• Implemented new strategies that resulted in increased efficiency and productivity

• Received recognition for outstanding performance and contributions to the company
Answered by AI
Add your answer

Aptitude,Python,java,dbms snippets

Q1. 3 SQL basic questions
Add your answer
Q2. 2 python codes and algorithms
Add your answer

There were 90 questions that need to solved in 60 min. Only eligible to next round if qualified in this round

Q1. Overriding in java
Ans. 
Overriding in Java allows a subclass to provide a specific implementation of a method that is already provided by its superclass.
• Inheritance is a key concept in overriding, where a subclass inherits methods from its superclass.

• To override a method, the method in the subclass must have the same name, return type, and parameters as the method in the superclass.

• The @Override annotation can be used to ensure that a method ...read more
Answered by AI
Add your answer
Q2. Inheritance in java
Ans. 
Inheritance in Java allows a class to inherit properties and behaviors from another class.
• Allows for code reusability and promotes the concept of 'is-a' relationship

• Subclass inherits fields and methods from superclass

• Can override methods in subclass to provide specific implementation

• Super keyword is used to access superclass methods and fields

• Example: class Dog extends Animal {}
Answered by AI
Add your answer

Q1. Introduction of yourself
Ans. 
I am a software developer with 5 years of experience in Java, Python, and SQL.
• Experienced in Java, Python, and SQL programming languages

• Worked on developing web applications using frameworks like Spring and Django

• Familiar with database management systems like MySQL and PostgreSQL
Answered by AI
Add your answer
Q2. SQL based questions
Add your answer

Q1. Suggests few places in Hyderabad
Ans. 
Hyderabad is a vibrant city with a mix of historical landmarks, modern attractions, and delicious food options.
• Charminar - iconic monument in the heart of the city

• Golconda Fort - historic fort with stunning architecture

• Hussain Sagar Lake - picturesque lake with a giant Buddha statue

• Ramoji Film City - world's largest film studio complex

• Birla Mandir - beautiful temple dedicated to Lord Venkateswara
Answered by AI
Add your answer
Q2. Favourite tv show
Ans. 
My favourite TV show is Game of Thrones.
• Epic fantasy series with complex characters and storylines

• Based on the book series 'A Song of Ice and Fire' by George R.R. Martin

• Known for its shocking plot twists and intense battles
Answered by AI
Add your answer

Aptitude test based on quantitative,logical,dsa,java,python mcqs