Upload Button Icon Add office photos

Filter interviews by

Evernorth Health Services Senior Data Engineer Interview Questions and Answers

Updated 19 Oct 2024

1 interview found

Sort by: Popular

Senior Data Engineer Interview Questions

user image narasimha palutla

posted on 19 Oct 2024

Interview experience
3
 Average
Difficulty level
 -
Duration
 -
Result
 -

1 Interview Round

1

One-on-one Round (2 Questions)

  • Q1. How to read a text file as one column in pysaprk and get the word counts
  • Q2. Sql question to read the data between perticular range of min and max value of records

Skills evaluated in this interview

Interview questions from similar companies

Interview experience
4
 Good
Difficulty level
 Easy
Duration
 Less than 2 weeks
Result
 No response

I applied via Naukri.com and was interviewed in Nov 2024.

1 Interview Round

1

Technical Round (6 Questions)

  • Q1. Can you introduce yourself and describe your current project experience?
  • Q2. Decorators in python
  • Q3. What is the SQL query to group by employee ID in order to combine the first name and last name with a space?
  • Q4. What are constructors in Python?
  • Q5. Indexing in sql
  • Q6. Why spark works well with parquet files?

Skills evaluated in this interview

Interview experience
5
 Excellent
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
Selected  Selected

I applied via Naukri.com and was interviewed in Nov 2024.

2 Interview Rounds

1

Technical Round (2 Questions)

  • Q1. All questions based on databricks and some pyspark , python , SQL only.
  • Q2. Learn windows function implementation in databricks note book.
2

HR Round (1 Question)

  • Q1. This round about your salary discussion around.

Interview Preparation Tips

Topics to prepare for Accenture Senior Data Engineer interview:
  • Python
  • Pyspark
  • SQL
  • Databricks
Interview preparation tips for other job seekers - Please prepare for pyspark, python , SQL , databricks for practice to switch your job to big data engineer
Interview experience
3
 Average
Difficulty level
 -
Duration
 -
Result
 -

2 Interview Rounds

1

Technical Round (2 Questions)

  • Q1. Sql query to write max salary
  • Q2. What is dense rank in sql
2

Technical Round (2 Questions)

  • Q1. What is spark cluster
  • Q2. How hive works in hdfs

Skills evaluated in this interview

Interview experience
5
 Excellent
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
Selected  Selected

I was interviewed in Aug 2024.

3 Interview Rounds

1

Coding Test Round

Python and sql tasks

2

Technical Round (2 Questions)

  • Q1. Project related questions
  • Q2. Coding questions on pyspark windows
3

One-on-one Round (1 Question)

  • Q1. Managerial discussions, mostly in and around the previous projects
Interview experience
4
 Good
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
 No response

I was interviewed in Sep 2024.

1 Interview Round

1

Technical Round (3 Questions)

  • Q1. Coding in pyspark
  • Q2. Databricks optimisation technique
  • Q3. Aqe details in databricks

Skills evaluated in this interview

Senior Data Engineer Interview Questions

Cognizant user image Manoj Karan Singh

posted on 26 Oct 2024

Interview experience
4
 Good
Difficulty level
 Moderate
Duration
 2-4 weeks
Result
 Not Selected

I applied via Naukri.com and was interviewed in Sep 2024.

1 Interview Round

1

Coding Test Round

Spark Optimization, Transformation, DLT, DL, Data Governance
Python
SQL

Interview Preparation Tips

Interview preparation tips for other job seekers - Ingestion, Integration, Spark, Optimization, Python, SQL, Data Warehouse
Interview experience
4
 Good
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
Selected  Selected

I applied via Naukri.com and was interviewed in May 2024.

2 Interview Rounds

1

Technical Round (1 Question)

  • Q1. All medium level theory and SQL, python/pyspark code.
2

Technical Round (1 Question)

  • Q1. More in detail about tools and technologies, project handling, agile, CICD, scenario based.
Interview experience
4
 Good
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
 -

I applied via LinkedIn and was interviewed in Feb 2024.

3 Interview Rounds

1

Technical Round (2 Questions)

  • Q1. How to work with nested json using pyspark
  • Q2. How to implement scd2 step by step
2

Technical Round (2 Questions)

  • Q1. Write a SQL query to select data from table 2 where data exists in table 1
  • Q2. After performing joins how many records would be retrieved for inner, left, right and outer joins
3

HR Round (1 Question)

  • Q1. About previous company and reason for leaving

Interview Preparation Tips

Interview preparation tips for other job seekers - Don't be afraid of giving interviews. Prepare well attend confidently if you clear it's an opportunity if you don't it's an experience!!

Skills evaluated in this interview

Interview experience
4
 Good
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
 No response

I applied via Recruitment Consulltant and was interviewed in Mar 2024.

2 Interview Rounds

1

One-on-one Round (1 Question)

  • Q1. How the files will be read in AWS GLUE
2

Technical Round (2 Questions)

  • Q1. How to get duplicate records
  • Q2. How to get the second highest salary

Skills evaluated in this interview

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.

Software Engineering Advisor
3 salaries
unlock blur

₹32 L/yr - ₹52 L/yr

Explore more salaries
Compare Evernorth Health Services with

TCS

3.7
Compare

Accenture

3.9
Compare

Wipro

3.7
Compare

Cognizant

3.8
Compare

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview