Upload Button Icon Add office photos

Filter interviews by

Evernorth Health Services Senior Data Engineer Interview Questions and Answers

Updated 19 Oct 2024

Evernorth Health Services Senior Data Engineer Interview Experiences

1 interview found

Senior Data Engineer Interview Questions & Answers

user image narasimha palutla

posted on 19 Oct 2024

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. How to read a text file as one column in pysaprk and get the word counts
  • Ans. 

    Read a text file as one column in pyspark and get word counts

    • Use SparkContext to read the text file and create a DataFrame with one column

    • Split the text column into words using split() function

    • Use groupBy() and count() functions to get the word counts

  • Answered by AI
  • Q2. Sql question to read the data between perticular range of min and max value of records
  • Ans. 

    Use SQL's WHERE clause to filter records between specified min and max values.

    • Use the SELECT statement to choose the columns you want.

    • Utilize the WHERE clause to specify the range: WHERE column_name BETWEEN min_value AND max_value.

    • Example: SELECT * FROM table_name WHERE age BETWEEN 20 AND 30;

    • You can also use greater than and less than operators: WHERE column_name >= min_value AND column_name <= max_value.

  • Answered by AI

Skills evaluated in this interview

Top trending discussions

View All
Interview Tips & Stories
2w
toobluntforu
·
works at
Cvent
Can speak English, can’t deliver in interviews
I feel like I can't speak fluently during interviews. I do know english well and use it daily to communicate, but the moment I'm in an interview, I just get stuck. since it's not my first language, I struggle to express what I actually feel. I know the answer in my head, but I just can’t deliver it properly at that moment. Please guide me
Got a question about Evernorth Health Services?
Ask anonymously on communities.

Interview questions from similar companies

I applied via Naukri.com and was interviewed before Aug 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Technical questions : 1)oops concepts 2)plsql cursors, triggers, procedures 3)quick sort algorithm

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared with your resume. None of the questions were asked out of resume.

Senior Data Engineer Interview Questions Asked at Other Companies

asked in 7 Eleven
Q1. Write a query to get the customer with the highest total order va ... read more
asked in 7 Eleven
Q2. There are 10 million records in the table and the schema does not ... read more
asked in KFintech
Q3. Given infinite coins of some currency of denominations : 1,2,5,10 ... read more
asked in 7 Eleven
Q4. How do you handle data pipelines when the schema information keep ... read more
asked in 7 Eleven
Q5. Difference between Parquet and ORC file. Why industry uses parque ... read more

Interview Questionnaire 

2 Questions

  • Q1. Tell me about yourself
  • Q2. Reverse string
  • Ans. 

    Reversing a string involves rearranging its characters in the opposite order, which can be done using various methods.

    • Use built-in functions: In Python, you can reverse a string with slicing: `reversed_string = original_string[::-1]`.

    • Iterative approach: Loop through the string from the end to the beginning and build a new string.

    • Using recursion: Define a function that calls itself with a smaller substring until it reac...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Average level interview
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 - Coding Test 

Good Practice

Interview Preparation Tips

Interview preparation tips for other job seekers - Good Practice of Coding.......

I applied via Approached by Company and was interviewed before May 2021. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. They will ask about your past experience and current project details in detail.
  • Ans. Just give the proper answer about your past experience very Convincingly and confidently.
  • Answered Anonymously
  • Q2. Few technical questions they will ask.
  • Ans. If you already prepared for your interview, then you can answer the basic technical questions and you will get selected.
  • Answered Anonymously
Round 2 - Technical 

(1 Question)

  • Q1. As this was the client round. Deep technical questions about relevant experience.
  • Ans. Just answer to all the questions whatever they ask in very confident manner and should have manageable comm skill to clear the client round.
  • Answered Anonymously

Interview Preparation Tips

Interview preparation tips for other job seekers - Just don't wait for the perfect time. Perfect time is a Myth. Just go for it.

I applied via Recruitment Consulltant and was interviewed before Nov 2021. 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 - Assignment 

MCQ's and Coding Problem - 1 related with Java, RDBMS, JS

Round 3 - Technical 

(1 Question)

  • Q1. Basic Question on Java and Project related questions
Round 4 - HR 

(1 Question)

  • Q1. Introduction, Discussion regarding the roles and salary negotiation.

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare with basics and be confident with the answers.

I applied via Recruitment Consultant and was interviewed in Aug 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. String builder and string buffer When we create Arrays and when we create linked lists Treeset in Java Java 8 features Static keyword Dynamic method dispatch How to make a immutable cla...
  • Ans. 

    Questions related to Java programming language concepts and features.

    • StringBuilder and StringBuffer are used for efficient string manipulation.

    • Arrays are fixed in size while linked lists can grow dynamically.

    • TreeSet is a sorted set implementation in Java.

    • Java 8 introduced lambda expressions, streams, and functional interfaces.

    • Static keyword is used to create class-level variables and methods.

    • Dynamic method dispatch is ...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Just be confident and rock!

Skills evaluated in this interview

Are these interview questions helpful?

Interview Questionnaire 

2 Questions

  • Q1. Apigee
  • Q2. Interal architecture

Interview Questionnaire 

1 Question

  • Q1. Where do you see yourself in 5 years.

Interview Questionnaire 

1 Question

  • Q1. Company hostory

Interview Preparation Tips

Interview preparation tips for other job seekers - Communication skills

Evernorth Health Services Interview FAQs

How many rounds are there in Evernorth Health Services Senior Data Engineer interview?
Evernorth Health Services interview process usually has 1 rounds. The most common rounds in the Evernorth Health Services interview process are One-on-one Round.
What are the top questions asked in Evernorth Health Services Senior Data Engineer interview?

Some of the top questions asked at the Evernorth Health Services Senior Data Engineer interview -

  1. How to read a text file as one column in pysaprk and get the word cou...read more
  2. Sql question to read the data between perticular range of min and max value of ...read more

Tell us how to improve this page.

Overall Interview Experience Rating

3/5

based on 1 interview experience

Senior Lead Analyst
36 salaries
unlock blur

₹16 L/yr - ₹35 L/yr

Senior Business Analyst
27 salaries
unlock blur

₹19.7 L/yr - ₹25 L/yr

Senior Software Engineer
25 salaries
unlock blur

₹20.2 L/yr - ₹40 L/yr

Associate Advisor
22 salaries
unlock blur

₹30 L/yr - ₹39 L/yr

Product Manager
19 salaries
unlock blur

₹22.2 L/yr - ₹35 L/yr

Explore more salaries
Compare Evernorth Health Services with

TCS

3.6
Compare

Accenture

3.7
Compare

Wipro

3.7
Compare

Cognizant

3.7
Compare
write
Share an Interview