Upload Button Icon Add office photos

Filter interviews by

American Broadcasting Company Data Engineer Interview Questions and Answers

Updated 16 Jan 2025

American Broadcasting Company Data Engineer Interview Experiences

4 interviews found

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 25 Sep 2024

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. What is hive , scala
  • Ans. 

    Hive is a data warehouse infrastructure tool while Scala is a programming language for data analysis and processing.

    • Hive is a data warehouse infrastructure built on top of Hadoop for querying and managing large datasets.

    • Scala is a programming language that is concise, expressive, and integrates well with big data tools like Apache Spark.

    • Both Hive and Scala are commonly used in big data processing and analytics projects

  • Answered by AI
  • Q2. What is spark context
  • Ans. 

    Spark context is the main entry point for Spark functionality and represents the connection to a Spark cluster.

    • Main entry point for Spark functionality

    • Represents connection to a Spark cluster

    • Used to create RDDs, broadcast variables, and accumulators

  • Answered by AI

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 16 Jan 2025

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

Valid parentheses in python

Data Engineer Interview Questions Asked at Other Companies

asked in Cisco
Q1. Optimal Strategy for a Coin Game You are playing a coin game with ... read more
asked in Sigmoid
Q2. Next Greater Element Problem Statement You are given an array arr ... read more
asked in Sigmoid
Q3. Problem: Search In Rotated Sorted Array Given a sorted array that ... read more
asked in Cisco
Q4. Covid Vaccination Distribution Problem As the Government ramps up ... read more
asked in LTIMindtree
Q5. 1) If you are given a card with 1-1000 numbers and there are 4 bo ... read more

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 10 Oct 2023

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
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 - Technical 

(2 Questions)

  • Q1. Types of joins in sql
  • Ans. 

    Types of joins in SQL include inner join, left join, right join, and full outer join.

    • Inner join: returns rows when there is a match in both tables

    • Left join: returns all rows from the left table and the matched rows from the right table

    • Right join: returns all rows from the right table and the matched rows from the left table

    • Full outer join: returns all rows when there is a match in either table

  • Answered by AI
  • Q2. Best practices used in sql
  • Ans. 

    Best practices in SQL include using indexes, optimizing queries, normalizing data, and using stored procedures.

    • Use indexes to improve query performance

    • Optimize queries by avoiding unnecessary joins and using appropriate WHERE clauses

    • Normalize data to reduce redundancy and improve data integrity

    • Use stored procedures for frequently executed tasks to improve performance

  • Answered by AI

Skills evaluated in this interview

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 27 May 2024

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Referral and was interviewed before May 2023. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Spark rddd , data frame and data set difference

Interview Preparation Tips

Interview preparation tips for other job seekers - easy to modereate

American Broadcasting Company interview questions for designations

 Data Analyst

 (8)

 Data Scientist

 (2)

 Senior Data Analyst

 (1)

 Software Engineer

 (17)

 Softwaretest Engineer

 (6)

 Test Engineer

 (5)

 QA Engineer

 (4)

 Devops Engineer

 (3)

Interview questions from similar companies

Interview Preparation Tips

Round: Test
Tips: Prepare well.

Round: Interview
Tips: The Basics should be good.

Round: Interview
Experience: The Advanced level.

General Tips: Just be yourself. Maintain a good CGPA. Focus as much as you can on internships. They Matter a big deal.
Skills: Adobe Photoshop, Quantitative Ability, Logical Reasoning, Data Interpretation
College Name: IIT KHARAGPUR
Motivation: One of the best companies to work for. Great growth.

Interview Questionnaire 

3 Questions

  • Q1. What is a Tree/binary search tree, How to perform add, delete operation in BST, whats the time complexity, asked to write complete code on paper
  • Ans. 

    BST is a binary tree where left child is smaller and right child is greater. Add/delete ops maintain this property.

    • BST is a data structure used for searching, sorting, and storing data

    • Add operation: Traverse the tree and find the appropriate position to insert the new node

    • Delete operation: Find the node to be deleted, replace it with its inorder successor or predecessor, and delete the successor/predecessor node

    • Time co...

  • Answered by AI
  • Q2. Make a copy of linked list with a random pointer pointing to random node in the linked list, asked to write pseudo code for it
  • Ans. 

    Copy a linked list with random pointers to random nodes in the list.

    • Create a new node for each node in the original list

    • Map the original nodes to their corresponding new nodes

    • Copy the value of the original node to the new node

    • Copy the random pointer of the original node to the new node using the mapping created earlier

  • Answered by AI
  • Q3. Some SQL basic sql queries

Interview Preparation Tips

Round: Resume Shortlist
Experience: On the basis of CV they shortlisted approx 30 candidates for SDE position.
Tips: Must verify your CV from your seniors/batchmates.  
Include all the projects, intern work or hall activities or anything you have done on your own which is related to or interest of company. If you know any back-end/front-end (javascript, php, mysql etc) language do mention. I think the cv shortlist was completely based on previous work and technical skills related to Web Development/Design mentioned in the CV.

Round: Technical Interview
Experience: I had one interview for approx. an hour, it includes both Technical and HR round, well mostly technical. Interview starts with tell me something about yourself.  Asked in detailed about algorithms/web based projects mentioned in CV, make sure that whatever you have written you have complete knowledge about it. Asked to code few basic algorithms questions. Do mention about small project if you have done related to web development.
If interviewer says if you want to ask any question, its always better to ask one or two question.
Tips: Prepare tell me something about yourself way before your placement starts, a month or so. Write it down on a piece of paper, keep it to less than 120 sec, 90-100 sec is good. 
A basic format would be like, your introduction, schooling (doesn't matter but if you have something good to say about), give an overview of your project/work experience mentioned in your CV.  
You should cover all the necessary and important parts written in your cv in this question. If something interest the interviewer your interview can start from those topic you mentioned.
Just make sure whatever you have written in your CV, you have full knowledge of it. Interviewer is going to take you from summary of the project to how you have actually coded some particular function or stored data.
Interviewer will give you enough time to think and give answer, so don't just be in hurry and say anything randomly.
While writing code keep telling what you are doing, just don't sit and code silently, interviewer might say and give hints if you are doing it wrong.
Ask question if you have any doubt, or to frame the question properly. Cause most of the time questions are of one line and you're suppose to assume a lot of things so its better to ask questions and get it clarified, it may happens that interviewer wants to ask something else and you are solving something else.
If you don't know something its better to say no.

General Tips: Interviewer wanna see how you think and if you can code or not, so take your time, think properly, keep telling what you are thinking, interviewer will probably gives hints/help you to solve the problem.
Skills: SQL, Algorithms, Data Strucutre, C++, PHP
College Name: IIT Kharagpur
Motivation: Interested in coding, love web development stuffs.

Skills evaluated in this interview

Interview Questionnaire 

4 Questions

  • Q1. Tell me about yourself
  • Ans. 

    I am a software engineer with experience in developing web applications and a passion for problem-solving.

    • Experienced in developing web applications using languages such as Java, Python, and JavaScript

    • Proficient in using frameworks such as Spring, Django, and React

    • Skilled in problem-solving and troubleshooting

    • Strong communication and collaboration skills

    • Passionate about learning new technologies and keeping up with ind

  • Answered by AI
  • Q2. Walk me through your resume
  • Ans. 

    I have experience in software development and have worked on various projects using different technologies.

    • Started my career as a software developer at XYZ company

    • Developed web applications using Java and Spring framework

    • Worked on a project for a client in the healthcare industry, developing a patient management system

    • Implemented RESTful APIs using Node.js and Express

    • Contributed to open source projects on GitHub

    • Current...

  • Answered by AI
  • Q3. Some logical puzzles
  • Q4. Some case studies

Interview Preparation Tips

Round: Resume Shortlist
Experience: They look for entrepreneur enthusiasm in the candidate.

Round: Interview
Experience: There were three interview rounds.

General Tips: In the ascending order of importance, the role of following in getting shortlisted:
1 CGPA
2 Academic Achievements
3 Technical Skills example coding etc.
4 Internships
5 Projects
6 PoRs
7 Extra, co-curricular activities
Skill Tips: Prepare yourself by going through everything on LAN and on the placement website (study material). 
Also, attended the soft skills workshop.
College Name: IIT MADRAS
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Campus Placement and was interviewed before Oct 2022. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Do not use an unprofessional email address such as cool_boy@email.com. It shows a lack of professionalism by the candidate.
View all tips
Round 2 - Technical 

(1 Question)

  • Q1. Asked about the projects from the resume. It was based on Python. The project was stock prediction using ml. They mainly asked about the concepts used. And they also asked the equations related to data sci...
Round 3 - HR 

(1 Question)

  • Q1. I didn't qualified for this round

Interview Preparation Tips

Interview preparation tips for other job seekers - revise datascience course throughly and go through your resume projects
Interview experience
5
Excellent
Difficulty level
-
Process Duration
Less than 2 weeks
Result
Selected Selected

I was interviewed before Sep 2023.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Basic java understanding questions
  • Q2. Few basic SQL questions and mongodb questions

Interview Preparation Tips

Interview preparation tips for other job seekers - interviewer was polite and understood the knowledge of concepts.
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
2-4 weeks
Result
Not Selected

I applied via LinkedIn and was interviewed in Oct 2024. There were 2 interview rounds.

Round 1 - Coding Test 

Technical aspects about linked list,trees, stacks

Round 2 - Group Discussion 

Topic related to humanities

American Broadcasting Company Interview FAQs

How many rounds are there in American Broadcasting Company Data Engineer interview?
American Broadcasting Company interview process usually has 1-2 rounds. The most common rounds in the American Broadcasting Company interview process are Technical, Resume Shortlist and Coding Test.
What are the top questions asked in American Broadcasting Company Data Engineer interview?

Some of the top questions asked at the American Broadcasting Company Data Engineer interview -

  1. Types of joins in ...read more
  2. best practices used in ...read more
  3. spark rddd , data frame and data set differe...read more

Tell us how to improve this page.

American Broadcasting Company Data Engineer Interview Process

based on 4 interviews

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

HDFC Bank Interview Questions
3.9
 • 2.1k Interviews
PVR Inox Interview Questions
4.0
 • 163 Interviews
Abbott Interview Questions
4.1
 • 147 Interviews
Kantar Interview Questions
3.5
 • 96 Interviews
Tata Play Interview Questions
4.0
 • 70 Interviews
Times Internet Interview Questions
3.6
 • 63 Interviews
Aptara Interview Questions
3.3
 • 62 Interviews
DISH TV Interview Questions
3.5
 • 59 Interviews
View all
American Broadcasting Company Data Engineer Salary
based on 68 salaries
₹7.2 L/yr - ₹29.4 L/yr
64% more than the average Data Engineer Salary in India
View more details

American Broadcasting Company Data Engineer Reviews and Ratings

based on 4 reviews

3.7/5

Rating in categories

3.7

Skill development

3.8

Work-life balance

3.4

Salary

3.7

Job security

3.7

Company culture

3.7

Promotions

3.7

Work satisfaction

Explore 4 Reviews and Ratings
Manager
1.5k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Engineer
1k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Developer
848 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

SAP Abap Consultant
623 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Team Manager
565 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare American Broadcasting Company with

HDFC Bank

3.9
Compare

Manappuram Finance

3.9
Compare

PVR Inox

4.0
Compare

Abbott

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