Upload Button Icon Add office photos

Filter interviews by

CAPG Data Engineer Interview Questions and Answers

Updated 29 Jun 2024

CAPG Data Engineer Interview Experiences

1 interview found

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 29 Jun 2024

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. What is spark archteturiee?
  • Ans. 

    Spark architecture refers to the structure and components of Apache Spark, a distributed computing framework.

    • Spark architecture includes components like Driver, Executor, and Cluster Manager.

    • Driver is responsible for converting user code into tasks and scheduling them on Executors.

    • Executors are responsible for executing tasks and storing data in memory or disk.

    • Cluster Manager is responsible for managing resources acros...

  • Answered by AI
  • Q2. Differenece between dag and linegae graph
  • Ans. 

    DAG is a directed acyclic graph representing dependencies between tasks, while lineage graph shows the data flow path.

    • DAG is a graph with nodes representing tasks and edges representing dependencies between tasks.

    • Lineage graph shows the data flow path from source to destination.

    • DAG is used in workflow management systems like Apache Airflow, while lineage graph is used in data lineage tracking.

    • Example: In a DAG, task B ...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Pratice the basic theory and interview questions properly

Skills evaluated in this interview

Interview questions from similar companies

I applied via Campus Placement and was interviewed before Jan 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. First question in hr interview is tell about yourself then the hr asked questions what I mentioned in my resume. So put the information in resume what you known well. My unique talent is I'm a stage spea...

Interview Preparation Tips

Interview preparation tips for other job seekers - Be bold, be confident, don't put irrelevant information in your resume update yourself relating to your studies

I applied via Campus Placement and was interviewed before Feb 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Hr

Interview Preparation Tips

Interview preparation tips for other job seekers - You should be true to what you are putting before the interviewer . Try to put your ideas Add something you did well in your career like in projects /research which you know very well and versed in concepts about it for open interview so that interviewer can get bandwidth where he can ask questions from. This is simply a key .

I applied via Campus Placement and was interviewed before Jul 2020. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Description of project
  • Ans. 

    The project involved designing and implementing a new network infrastructure for a large corporation.

    • Conducted a thorough analysis of the existing network infrastructure

    • Designed a new network architecture that met the company's needs

    • Implemented the new network infrastructure with minimal disruption to business operations

    • Tested and optimized the new network to ensure optimal performance

    • Provided ongoing support and maint

  • Answered by AI
  • Q2. Your previous experince

Interview Preparation Tips

Interview preparation tips for other job seekers - Well prepare for your resume

I applied via Campus Placement and was interviewed before Feb 2020. There was 1 interview round.

Interview Questionnaire 

4 Questions

  • Q1. 1.Tell me about yourself.
  • Q2. 2. Some basic questions from DBMS, iot and cloud.
  • Q3. 3. Explain your project ( technology u have used and what is it).
  • Q4. 4. Are you willing to relocate.

Interview Preparation Tips

Interview preparation tips for other job seekers - HR was nice and friendly. Overall it was a NYC experience.
All the best guys.

I applied via Naukri.com and was interviewed in Jul 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. The questions were on front end web development questions with managerial interview

Interview Preparation Tips

Interview preparation tips for other job seekers - The overall experience was good. The interview was on technical and managerial skills based on the experience gained.

I applied via Campus Placement and was interviewed before Nov 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Concepts of Oops

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare with basic concepts of OOPS.Explain final year project.
Be confident.

I appeared for an interview before Jun 2021.

Round 1 - Coding Test 

(2 Questions)

Round duration - 180 minutes
Round difficulty - Easy

It was an mcq + coding round. There were aptitude and ouput based question in mcq. And coding questions were easy

  • Q1. 

    Find the Duplicate Number Problem Statement

    Given an integer array 'ARR' of size 'N' containing numbers from 0 to (N - 2). Each number appears at least once, and there is one number that appears twice. Yo...

  • Ans. 

    Find the duplicate number in an array of integers from 0 to (N-2).

    • Iterate through the array and keep track of the frequency of each number using a hashmap.

    • Return the number with a frequency greater than 1 as the duplicate number.

    • Time complexity can be optimized to O(N) using Floyd's Tortoise and Hare algorithm.

  • Answered by AI
  • Q2. 

    Reverse String Operations Problem Statement

    You are provided with a string S and an array of integers A of size M. Your task is to perform M operations on the string as specified by the indices in array A...

  • Ans. 

    Given a string and an array of indices, reverse substrings based on the indices to obtain the final string.

    • Iterate through the array of indices and reverse the substrings accordingly

    • Ensure the range specified by each index is non-empty

    • Return the final string after all operations are completed

  • Answered by AI
Round 2 - Video Call 

Round duration - 60 Minutes
Round difficulty - Easy

It was technical + hr round. there were 2 people as interviewer. They stated from intro and asked some basic puzzles and hr questions. After that they asked about my projects, technologies and some ds algo and dbms questions.

Interview Preparation Tips

Eligibility criterianaAccenture interview preparation:Topics to prepare for the interview - Data Structures, Pointers, OOPS, System Design, Algorithms, Dynamic ProgrammingTime required to prepare for the interview - 6 MonthsInterview preparation tips for other job seekers

Tip 1 : Practice aptitude
Tip 2 : Focus on practicing coding
Tip 3 : Learn from mistakes

Application resume tips for other job seekers

Tip 1 : Mention some projects that you have done
Tip 2 : Try to have skills that are required for the role

Final outcome of the interviewSelected

Skills evaluated in this interview

I applied via Campus Placement and was interviewed before Aug 2021. There were 2 interview rounds.

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 - Coding Test 

Easy DSA questions and some questions on resume

Interview Preparation Tips

Interview preparation tips for other job seekers - Don't join if you are a fresher and want to grow as a developer. I had resigned that time I am writing this review

I applied via Campus Placement and was interviewed in Mar 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. How do you get the second to last element from a SQL table?
  • Ans. 

    To get the second to last element from a SQL table, use the OFFSET-FETCH clause.

    • Use the ORDER BY clause to sort the table in descending order.

    • Use the OFFSET-FETCH clause to skip the last row and fetch the second to last row.

    • Example: SELECT column_name FROM table_name ORDER BY column_name DESC OFFSET 1 ROWS FETCH NEXT 1 ROWS ONLY;

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Practice by building a simple full stack web application.

Skills evaluated in this interview

CAPG Interview FAQs

How many rounds are there in CAPG Data Engineer interview?
CAPG interview process usually has 1 rounds. The most common rounds in the CAPG interview process are One-on-one Round.
What are the top questions asked in CAPG Data Engineer interview?

Some of the top questions asked at the CAPG Data Engineer interview -

  1. Differenece between dag and linegae gr...read more
  2. What is spark archteturi...read more

Tell us how to improve this page.

CAPG Data Engineer Interview Process

based on 1 interview

Interview experience

3
  
Average
View more

Data Engineer Interview Questions from Similar Companies

View all
Senior Consultant
31 salaries
unlock blur

₹12.5 L/yr - ₹25 L/yr

Consultant
9 salaries
unlock blur

₹6.1 L/yr - ₹18 L/yr

Senior Software Engineer
9 salaries
unlock blur

₹7.7 L/yr - ₹33.6 L/yr

Analyst
8 salaries
unlock blur

₹2.8 L/yr - ₹5.5 L/yr

Software Engineer
8 salaries
unlock blur

₹4 L/yr - ₹16 L/yr

Explore more salaries
Compare CAPG with

TCS

3.7
Compare

Accenture

3.8
Compare

Wipro

3.7
Compare

Cognizant

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