Comcast India Engineering Center Interview Questions, Process, and Tips

I was asked to write some codes using goroutines and data structures

Q1. Write a goroutine code which is synced to to another goroutine and waits till the 1st one passes some data to the next one.
Ans. 
Use channels in Go to sync two goroutines passing data between them.
• Create a channel to pass data between the goroutines

• Use a select statement to wait for data to be passed

• Ensure proper synchronization to avoid race conditions
Answered by AI
Add your answer
Q2. Write a code to find the number in a sorted array in with lowest code complexity
Ans. 
Implement binary search to find the number in a sorted array with lowest code complexity.
• Use binary search algorithm to efficiently find the number in the sorted array.

• Compare the target number with the middle element of the array and adjust the search range accordingly.

• Repeat the process until the target number is found or the search range is exhausted.
Answered by AI
Add your answer

Sql queries round. Window functions, grouping, intermediate sql

Q1. Basics of Distributed computing
Add your answer
Q2. Spark optimization techniques
Ans. 
Spark optimization techniques
• Partitioning data to optimize parallelism

• Caching frequently used data to avoid recomputation

• Using broadcast variables to reduce data shuffling

• Avoiding unnecessary transformations

• Tuning memory and executor settings

• Using efficient data formats like Parquet or ORC

• Using appropriate join strategies
Answered by AI
Add your answer
Q3. Hive, Spark architecture, sql order of execution, sql window functions
Add your answer
Q4. Big data on cloud, azure data engineering, azure data bricks fundamentals, git integration, CICD, airflow basics
Add your answer

Q1. Managerial Round, project experience, flexibility, availability to join, attitude towards work, professional integrity
Add your answer
Q2. Commitment to work and time management
Add your answer

2 codings are asked in the test

Q1. Java interview questions and based on resume
Add your answer

Aptitude and coding round

Q1. Puzzle solving questions and asked python basics
Add your answer