Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by GSPANN Technologies Team. If you also belong to the team, you can get access from here

GSPANN Technologies Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

GSPANN Technologies Big Data Engineer Interview Questions and Answers

Updated 28 Feb 2024

GSPANN Technologies Big Data Engineer Interview Experiences

2 interviews found

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

I applied via Recruitment Consulltant and was interviewed in Jan 2024. There were 3 interview rounds.

Round 1 - Assesment Test 

(1 Question)

  • Q1. 40 question from sql, pyspark, python, airflow, hadoop
Round 2 - Technical 

(1 Question)

  • Q1. Proper Project Discussion, Challenges and Complexity SQL basics like join, sub query Pyspark basic joins About Airflow AWS services you know
Round 3 - Technical 

(1 Question)

  • Q1. Project discussion SQL query writing Python coding Pyspark Coding Orchestration tools

Interview Preparation Tips

Interview preparation tips for other job seekers - Be strong in basics and have knowledge and experience on latest technology.
I just lacked the later.

I applied via Recruitment Consultant and was interviewed in Sep 2020. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Understanding of any Cloud
  • Q2. Be thorough with Python and Pyspark and SQL

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well on SQL, Python, Spark and cloud is mandatory for BIgData Engineer role.

Big Data Engineer Interview Questions Asked at Other Companies

Q1. Difference between partitioning and bucketing. Types of joins in ... read more
asked in TCS
Q2. What optimization techniques have you utilized in your projects? ... read more
Q3. Checking whether a fibonacci number is present between a particuk ... read more
asked in TCS
Q4. What is the difference between lineage and directed acyclic graph ... read more
asked in TCS
Q5. What is the difference between cache and persistence?

Big Data Engineer Jobs at GSPANN Technologies

View all

Interview questions from similar companies

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

Very Good. Easy question asked

Round 2 - Coding Test 

Moderate Question Asked

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well before Interview
Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Oct 2023. There were 2 interview rounds.

Round 1 - Coding Test 

The word count program test case has to be successful

Round 2 - HR 

(1 Question)

  • Q1. Asked about my roles and responsibilities
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Naukri.com and was interviewed in Nov 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Tableau Questions 1. Difference between dimensions and measures. 2. What is RLS? 3. What are the functions you can assign in RLS? 4. Explain what is drill down approach. 5. What is LOD? 6. What is a calcul...
  • Q2. SQL Questions 1. In employee table find the 2nd highest salary. 2. Find the highest average salary in department 3. Given two tables(sales & product) find total sales per category 4. Two questions to find ...

Interview Preparation Tips

Topics to prepare for TEKsystems Data Analyst interview:
  • SQL
  • Tableau
  • DBMS
Interview preparation tips for other job seekers - Practice SQL interview questions and tableau interview questions from GfG and DataLemur.
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

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

Round 1 - One-on-one 

(2 Questions)

  • Q1. Azure Scenario based questions
  • Q2. Pyspark Coding based questions
Round 2 - One-on-one 

(2 Questions)

  • Q1. ADF, Databricks related question
  • Q2. Spark Performance problem and scenarios
  • Ans. 

    Spark performance problems can arise due to inefficient code, data skew, resource constraints, and improper configuration.

    • Inefficient code can lead to slow performance, such as using collect() on large datasets.

    • Data skew can cause uneven distribution of data across partitions, impacting processing time.

    • Resource constraints like insufficient memory or CPU can result in slow Spark jobs.

    • Improper configuration settings, su...

  • Answered by AI

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-

I applied via Campus Placement

Round 1 - Aptitude Test 

Based on SQL , statistics , python , cognitive

Round 2 - Technical 

(2 Questions)

  • Q1. Based on AI/Ml and based on cv
  • Q2. Based on projects
Round 3 - HR 

(2 Questions)

  • Q1. How to handle toxic work culture?
  • Ans. 

    Address toxic work culture by open communication, setting boundaries, seeking support, and considering leaving if necessary.

    • Open communication with colleagues and management about issues

    • Set boundaries to protect your mental and emotional well-being

    • Seek support from HR, a mentor, or a therapist if needed

    • Consider leaving the toxic work environment if the situation does not improve

  • Answered by AI
  • Q2. 5 strength and weakness

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident in interviews and try to calm ur mind!
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(1 Question)

  • Q1. Spark basic question , hive related questions.

Interview Preparation Tips

Interview preparation tips for other job seekers - Good question asked, It covers sql , spark and python.
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. What is Databricks, and how does it differ from Azure Data Factory?
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
No response

I applied via Naukri.com and was interviewed in Oct 2024. There was 1 interview round.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Incremental load in pyspark
  • Ans. 

    Incremental load in pyspark refers to loading only new or updated data into a dataset without reloading the entire dataset.

    • Use the 'delta' function in pyspark to perform incremental loads by specifying the 'mergeSchema' option.

    • Utilize the 'partitionBy' function to optimize incremental loads by partitioning the data based on specific columns.

    • Implement a logic to identify new or updated records based on timestamps or uni...

  • Answered by AI
  • Q2. Drop duplicates

Skills evaluated in this interview

GSPANN Technologies Interview FAQs

How many rounds are there in GSPANN Technologies Big Data Engineer interview?
GSPANN Technologies interview process usually has 3 rounds. The most common rounds in the GSPANN Technologies interview process are Technical.
How to prepare for GSPANN Technologies Big Data Engineer interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at GSPANN Technologies. The most common topics and skills that interviewers at GSPANN Technologies expect are Big Data, Python, Spark, SCALA and Hadoop.
What are the top questions asked in GSPANN Technologies Big Data Engineer interview?

Some of the top questions asked at the GSPANN Technologies Big Data Engineer interview -

  1. Project discussion SQL query writing Python coding Pyspark Coding Orchestration...read more
  2. 40 question from sql, pyspark, python, airflow, had...read more
  3. Be thorough with Python and Pyspark and ...read more

Tell us how to improve this page.

GSPANN Technologies Big Data Engineer Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more

Fast track your campus placements

View all
GSPANN Technologies Big Data Engineer Salary
based on 9 salaries
₹2.5 L/yr - ₹11.9 L/yr
37% less than the average Big Data Engineer Salary in India
View more details

GSPANN Technologies Big Data Engineer Reviews and Ratings

based on 2 reviews

4.1/5

Rating in categories

4.0

Skill development

3.1

Work-life balance

3.1

Salary

3.9

Job security

3.1

Company culture

4.0

Promotions

3.0

Work satisfaction

Explore 2 Reviews and Ratings
Senior Software Engineer
456 salaries
unlock blur

₹7.5 L/yr - ₹27 L/yr

Technical Lead
372 salaries
unlock blur

₹11 L/yr - ₹31 L/yr

Software Engineer
299 salaries
unlock blur

₹4 L/yr - ₹15 L/yr

Senior Technical Lead
140 salaries
unlock blur

₹13.1 L/yr - ₹32.8 L/yr

Associate Software Engineer
102 salaries
unlock blur

₹2 L/yr - ₹8.6 L/yr

Explore more salaries
Compare GSPANN Technologies with

TCS

3.7
Compare

Infosys

3.6
Compare

Wipro

3.7
Compare

HCLTech

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