AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
American Broadcasting Company Data Engineer Interview Questions and Answers
American Broadcasting Company Data Engineer Interview Experiences
4 interviews found
(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
- 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
Skills evaluated in this interview
(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
- 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
Valid parentheses in python
I applied via Referral and was interviewed before May 2023. There was 1 interview round.
(1 Question)
- Q1. Spark rddd , data frame and data set difference
Interview Preparation Tips
American Broadcasting Company interview questions for designations
Top trending discussions
Interview questions from similar companies
Data Engineer Interview Questions & Answers
Zee Entertainment Enterprises
Anonymous
posted on 30 Aug 2024
Selected
I applied via Approached by Company and was interviewed before Aug 2023. There was 1 interview round.
(1 Question)
- Q1. Kubernetes and Docker
I applied via LinkedIn and was interviewed in Mar 2021. There were 4 interview rounds.
Interview Questionnaire
1 Question
- Q1. Algo & Spark (SQL)
Interview Preparation Tips
I applied via LinkedIn and was interviewed in Oct 2024. There were 2 interview rounds.
Technical aspects about linked list,trees, stacks
Topic related to humanities
I applied via Naukri.com and was interviewed in Mar 2024. There were 2 interview rounds.
(1 Question)
- Q1. All questions based on your resume and recent project you have done including OOPS concept, MVC , Design patterns, SOLID principles
(1 Question)
- Q1. Here test the communications, problem solving skills, Decision making skill, Situation handle, conflict management
I applied via Indeed and was interviewed in Nov 2023. There were 2 interview rounds.
The interview session took 30 minutes
(1 Question)
- Q1. Implement java code to filter given data from a list using the Java Stream API
- Ans.
Implement Java code to filter data from a list using Java Stream API
Use Stream.filter() method to filter data based on a given condition
Use lambda expressions to define the filtering condition
Collect the filtered data using Collectors.toList() method
Interview Preparation Tips
Skills evaluated in this interview
Selected
I applied via Company Website and was interviewed in Jun 2023. There were 3 interview rounds.
Aptitude test in numbers system
(5 Questions)
- Q1. Technical question means skill based
- Q2. Only manual and automation and sql
- Q3. What is the manual testing
- Ans.
Manual testing is the process of testing software manually to identify defects without the use of automation tools.
Manual testing involves testers executing test cases by hand without the use of automation scripts.
Testers verify that the software functions correctly and meets requirements through manual exploration.
Manual testing is time-consuming but allows for thorough testing of user interfaces, usability, and edge ...
- Q4. What is Automaction testing
- Ans.
Automation testing is the use of software to execute test cases and compare actual outcomes with expected outcomes.
Automation testing saves time and effort by automating repetitive tasks.
It helps in increasing test coverage and accuracy.
Popular automation testing tools include Selenium, Appium, and JUnit.
- Q5. Why using in Oracle sql
- Ans.
Using 'IN' in Oracle SQL allows for filtering data based on a list of specific values.
Allows for filtering data based on multiple specific values
Can be used with subqueries to retrieve data from another table
Improves readability and performance compared to multiple OR conditions
Interview Preparation Tips
Skills evaluated in this interview
American Broadcasting Company Interview FAQs
Tell us how to improve this page.
American Broadcasting Company Interviews By Designations
- American Broadcasting Company Software Developer Interview Questions
- American Broadcasting Company Analyst Interview Questions
- American Broadcasting Company Software Engineer Interview Questions
- American Broadcasting Company Intern Interview Questions
- American Broadcasting Company Accountant Interview Questions
- American Broadcasting Company Engineer Interview Questions
- American Broadcasting Company Associate Interview Questions
- American Broadcasting Company Consultant Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Data Engineer Interview Questions
- Big Data Engineer Interview Questions
- Software Engineer Interview Questions
- Senior Software Engineer Interview Questions
- Database Admin Interview Questions
- Data Analyst Interview Questions
- System Engineer Interview Questions
- Associate Software Engineer Interview Questions
- Show more
American Broadcasting Company Data Engineer Interview Process
based on 4 interviews
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
American Broadcasting Company Data Engineer Reviews and Ratings
based on 4 reviews
Rating in categories
|
Software Engineer
1.5k
salaries
|  ₹16.3 L/yr - ₹43 L/yr |
|
Manager
1.5k
salaries
| ₹13 L/yr - ₹49.2 L/yr |
|
Software Developer
911
salaries
| ₹13.5 L/yr - ₹40 L/yr |
|
SAP Abap Consultant
575
salaries
| ₹11.5 L/yr - ₹43.4 L/yr |
|
Team Lead
566
salaries
| ₹10.5 L/yr - ₹40 L/yr |
Manappuram Finance
Hetero
PVR Inox
Abbott
- Home >
- Interviews >
- American Broadcasting Company Interview Questions >
- American Broadcasting Company Data Engineer Interview Questions
