Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by fifthnote - An Ensemble Health Partners Company Team. If you also belong to the team, you can get access from here

Filter interviews by

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

Updated 11 Jan 2022

fifthnote - An Ensemble Health Partners Company ETL Developer Interview Experiences

1 interview found

ETL Developer Interview Questions & Answers

user image Anonymous

posted on 11 Jan 2022

I applied via Recruitment Consultant and was interviewed in Jul 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Sql server basics, ssis lookups, performance tuning

Interview Preparation Tips

Interview preparation tips for other job seekers - Get the basics right and show the zeal to learn something new.

Interview questions from similar companies

Interview Questionnaire 

1 Question

  • Q1. General questions related to current role & project

Interview Preparation Tips

Interview preparation tips for other job seekers - Explain your role & skills with confidence.

I applied via Company Website and was interviewed in Aug 2022. There were 2 interview rounds.

Round 1 - Wonscore test 

(1 Question)

  • Q1. 50 aps in 12 mins. All u need is active speed to answer questions
Round 2 - Aptitude Test 

All those questions were taken from gmatclub website. Try to practice those stuffs

Interview Preparation Tips

Interview preparation tips for other job seekers - They would say that they care about only the approach to solve a question but it isn't true. Literally you have to get the answers for all questions to avoid getting rejected

I applied via Naukri.com and was interviewed in Mar 2022. There were 5 interview rounds.

Round 1 - Aptitude Test 

Fairly easy 12 minutes - 50 questions test covering aptitude and verbal ability

Round 2 - Aptitude Test 

1 hour test covering Aptitude and Logical reasoning and Data interpretation. Half hour asynchronous interview covering mostly situation based questions and guesstimate

Round 3 - Case Study 

An attrition data set was given and the deliverable was to draw as much insights as possible. Analysis using excel was sufficient.

Round 4 - One-on-one 

(1 Question)

  • Q1. The interview dealt mostly with situation based questions around previous work.
Round 5 - One-on-one 

(1 Question)

  • Q1. Very similar to the previous round and some standard HR questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Decent expertise in MS Excel is sufficient to clear the data analysis case study. Data visualization skills would be an added bonus and from there on all the questions would be surrounding your previous work. So be confident in your answers and back it up with real life experiences from your experience.
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Company Website and was interviewed before May 2022. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Aptitude Test 

Online Aptitude test

Round 3 - One-on-one 

(2 Questions)

  • Q1. With the Manager one on one round. Problem solving and analytical skill questions
  • Q2. Basic Problem solving aptitude question
Round 4 - HR 

(1 Question)

  • Q1. Salary Discussion and Location
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Sep 2024. There were 2 interview rounds.

Round 1 - Aptitude Test 

There will be aptitude screening round.

Round 2 - Case Study 

There will be the different case studies , from the pharmaceutical sector.

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed before Apr 2023. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. SQL group by, Java opps
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Campus Placement and was interviewed in Feb 2024. There were 2 interview rounds.

Round 1 - Aptitude Test 

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

Round 2 - Coding Test 

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

Interview Preparation Tips

Interview preparation tips for other job seekers - Time management will play a key role ,given time will be very less ,students must have grip on java and dsa
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Comprehensive questions covered wide range of topics

Round 2 - Coding Test 

Coding was typically

Round 3 - Technical 

(1 Question)

  • Q1. What programming language were used to develop the test.
Round 4 - HR 

(1 Question)

  • Q1. About work life balance
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

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

fifthnote - An Ensemble Health Partners Company Interview FAQs

How to prepare for fifthnote - An Ensemble Health Partners Company ETL Developer interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at fifthnote - An Ensemble Health Partners Company. The most common topics and skills that interviewers at fifthnote - An Ensemble Health Partners Company expect are SSIS, SSRS, T - SQL, Business Intelligence and ETL.

Tell us how to improve this page.

Interview Questions from Similar Companies

ZoomRx Interview Questions
3.0
 • 33 Interviews
Jasper Colin Interview Questions
4.2
 • 23 Interviews
Modak Analytics Interview Questions
3.5
 • 22 Interviews
Gaana Interview Questions
3.8
 • 14 Interviews
Decision Point Interview Questions
3.9
 • 13 Interviews
View all
52% more than the average ETL Developer Salary in India
View more details

fifthnote - An Ensemble Health Partners Company ETL Developer Reviews and Ratings

based on 1 review

5.0/5

Rating in categories

5.0

Skill development

3.0

Work-life balance

4.0

Salary

4.0

Job security

5.0

Company culture

5.0

Promotions

5.0

Work satisfaction

Explore 1 Review and Rating
ETL Developer
11 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Database Developer
10 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Devops Engineer
9 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Data Scientist 2
7 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

SQL Developer
7 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare fifthnote - An Ensemble Health Partners Company with

Saregama India

4.0
Compare

T-Series

3.9
Compare

Gaana

3.8
Compare

Shemaroo Entertainment

3.7
Compare
Did you find this page helpful?
Yes No
write
Share an Interview