Upload Button Icon Add office photos

Filter interviews by

Synoptek Senior Data Engineer Interview Questions and Answers

Updated 30 Jul 2024

1 interview found

Sort by: Popular

Senior Data Engineer Interview Questions

user image Anonymous

posted on 30 Jul 2024

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

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

2 Interview Rounds

1

One-on-one Round (4 Questions)

  • Q1. SQL and Python basics and live coding of SQL queries
  • Q2. Establishing connection to any DB using Python
  • Q3. Difference between BigQuery and BIgTable, what is partitioning in BQ
  • Q4. Questions on GCP
2

HR Round (2 Questions)

  • Q1. Tell me about yourself - where everything about the company was clearly explained and all details regarding my experience were asked
  • Q2. Expected CTC and the reason for change

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare the basics of Python and SQL. Also your projects that you have worked on so that you can explain. Be honest.

Interview questions from similar companies

Interview experience
1
 Bad
Difficulty level
 -
Duration
 6-8 weeks
Result
 -

I applied via Referral and was interviewed in Jan 2024.

1 Interview Round

1

Technical Round (1 Question)

  • Q1. There was no technical questions all very basic not for senior data engineer role questions only 3 questions( what is DB, Data Mart, Data warehouse)and he said ...read more

Interview Preparation Tips

Interview preparation tips for other job seekers - I would says it is totally based on luck some people are sitting in interview panel with not even intention to take interview. I had very bad experience of 5mins discussion it is not a technical round felt like phone screening
Interview experience
3
 Average
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
 Not Selected

I applied via campus placement at Army Institute of Technology, Pune and was interviewed in Oct 2024.

3 Interview Rounds

1

Coding Test Round

There was a coding round and out of 75 students 28 got selected for next round

2

Technical Round (2 Questions)

  • Q1. Total on resume and basic coding questions like write code for different sorting algorithms.
  • Q2. Explain your project in detail and asking cross questions regarding project.
3

Technical Round (1 Question)

  • Q1. I was rejected in round 2.

Interview Preparation Tips

Interview preparation tips for other job seekers - Go through your resume thoroughly, and have a basic DSA knowledge.
Interview experience
3
 Average
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
 Not Selected

I applied via Campus Placement and was interviewed in Sep 2024.

1 Interview Round

1

Technical Round (6 Questions)

  • Q1. What do u mean by data
  • Q2. What is preprocessed data
  • Q3. What do u mean by info
  • Q4. How to copy from 2 tables and paste in 3rd one in sql
  • Q5. Reverse string using any language you know
  • Q6. A puzzle question was asked but i don't remeber it.

Skills evaluated in this interview

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

I applied via campus placement at SRM university (SRMU) and was interviewed in May 2024.

5 Interview Rounds

1

Aptitude Test Round

Assusual apti questions from every topics

2

Coding Test Round

1. 1 coding Question we can use java, python etc to solve and
2. another 1 sql question

3

Coding Test Round

One question based on any one data structure (in my case I solved stack &queue combinely)

4

Telephonic Call Round (3 Questions)

  • Q1. They ask about Ur background qualifications and verify
  • Q2. And then explain the process of company and ask everything is ok for us like bond etc
  • Q3. Then sheduled interview on the next day
5

HR Round (11 Questions)

  • Q1. She(hr) introduced herself
  • Q2. Then she asked me to introduce myself
  • Q3. What are the programming languages u know ( I said I'm strong in java)
  • Q4. Rate Urself in it out of 5
  • Q5. She asked me to explain lambda expressions in java
  • Q6. Explain detaily about Four pillars of oops
  • Q7. Share Ur screen and get this output (pattern program)
  • Q8. Shorterm and long-term goals
  • Q9. If your assigned to a task how can you complete it
  • Q10. Exception handling concept (she specifically asked about throw, throws, finally keyword)
  • Q11. Explain about Static keyword

Interview Preparation Tips

Interview preparation tips for other job seekers - Actually she not even have my resume I think, she asked everything about my biodata, so what your telling in selfintro is matters ...so be prepared for the technical skills that your going tell her, Best of luck

Skills evaluated in this interview

Interview experience
4
 Good
Difficulty level
 -
Duration
 -
Result
 -

1 Interview Round

1

Technical Round (2 Questions)

  • Q1. What are different KPI's
  • Q2. Differentiate loc and iloc in pandas
Interview experience
4
 Good
Difficulty level
 -
Duration
 -
Result
 -

2 Interview Rounds

1

Aptitude Test Round

Easy applitute question with 1 coding question at the end

2

Technical Round (3 Questions)

  • Q1. String builder vs string buffer
  • Q2. Final keyword in oops
  • Q3. Bsf graph explanation

Interview Preparation Tips

Interview preparation tips for other job seekers - Nice interview

Skills evaluated in this interview

Interview experience
3
 Average
Difficulty level
 Easy
Duration
 Less than 2 weeks
Result
 Not Selected

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

2 Interview Rounds

1

Technical Round (1 Question)

  • Q1. Basic to medium questions related to DotNet Core MVC, SQL Server, etc
2

Technical Round (1 Question)

  • Q1. Completely unprofessional behavior of the interviewer. - No Introduction Direct start asking questions. - Asking too many misleading questions (First ask what y...read more

Data Engineer Interview Questions

Saama Technologies user image Gautamee Jakinkar

posted on 29 May 2024

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

I applied via Campus Placement and was interviewed in Apr 2024.

2 Interview Rounds

1

Assignment Round

It was a written test where theoretical SQL questions were asked like primary key, foreign key, set operators and some queries

2

Technical Round (1 Question)

  • Q1. All SQL Concepts like Join, normalization, trigger, stored procedure, keys, drop truncate del difference, where having difference, Aggregate scaler window funct...read more

Interview Preparation Tips

Topics to prepare for Saama Technologies Data Engineer interview:
  • SQL
  • Python
  • Pyspark
Interview preparation tips for other job seekers - Clear your concepts deeply with examples sothat you can able to explain it..
Interview experience
4
 Good
Difficulty level
 Moderate
Duration
 -
Result
Selected  Selected

3 Interview Rounds

1

Assignment Round

Object Detection on a subset of COCO dataset having Cars and Person classes

2

Technical Round (1 Question)

  • Q1. Technical discussion on Machine Learning, Deep Learning Concepts and coding round.
3

Technical Round (1 Question)

  • Q1. Technical discussion on Deep Learning and Computer Vision.

Synoptek Interview FAQs

How many rounds are there in Synoptek Senior Data Engineer interview?
Synoptek interview process usually has 2 rounds. The most common rounds in the Synoptek interview process are One-on-one Round and HR.
What are the top questions asked in Synoptek Senior Data Engineer interview?

Some of the top questions asked at the Synoptek Senior Data Engineer interview -

  1. Difference between BigQuery and BIgTable, what is partitioning in...read more
  2. Expected CTC and the reason for cha...read more
  3. SQL and Python basics and live coding of SQL quer...read more

Tell us how to improve this page.

People are getting interviews through

based on 1 Synoptek interview
Job Portal
100%
Low Confidence
?
Low Confidence means the data is based on a small number of responses received from the candidates.
Senior Software Engineer
45 salaries
unlock blur

₹5.7 L/yr - ₹23 L/yr

Software Engineer
44 salaries
unlock blur

₹4.8 L/yr - ₹16.3 L/yr

Associate Software Engineer
24 salaries
unlock blur

₹5.2 L/yr - ₹10.1 L/yr

Software Developer
23 salaries
unlock blur

₹4.8 L/yr - ₹8 L/yr

Support Engineer
23 salaries
unlock blur

₹3.3 L/yr - ₹9 L/yr

Explore more salaries
Compare Synoptek with

Wipro

3.7
Compare

TCS

3.7
Compare

HCLTech

3.6
Compare

Tech Mahindra

3.6
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