Upload Button Icon Add office photos
Engaged Employer

i

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

_VOIS Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

_VOIS Gcp Data Engineer Interview Questions and Answers

Updated 15 May 2024

_VOIS Gcp Data Engineer Interview Experiences

1 interview found

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 Apr 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Bigquery realated and airflow
  • Q2. Project flow ,basic questions for project realted

Interview Preparation Tips

Topics to prepare for _VOIS Gcp Data Engineer interview:
  • Machine Learning
Interview preparation tips for other job seekers - na

Interview questions from similar companies

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(6 Questions)

  • Q1. SQL: Find keys present in table A but not in B(B is old copy of A)
  • Ans. 

    Use SQL to find keys present in table A but not in table B (old copy of A).

    • Use a LEFT JOIN to combine tables A and B based on the key column

    • Filter the results where the key column in table B is NULL

    • This will give you the keys present in table A but not in table B

  • Answered by AI
  • Q2. SQL: 4th highest salary
  • Q3. Case Study: Using GCP's tool make a pipeline to transfer file from one GCS bucket to another
  • Ans. 

    Use GCP Dataflow to transfer files between GCS buckets

    • Create a Dataflow pipeline using Apache Beam to read from source bucket and write to destination bucket

    • Use GCS connector to read and write files in Dataflow pipeline

    • Set up appropriate permissions for Dataflow service account to access both buckets

  • Answered by AI
  • Q4. Case Study: A new joiner in IT, how will you explain flow of project and ownership of work. Considering my YOE 3 years
  • Q5. Explain your project, and reasons behind why did you choose airflow over other orchestration tool.
  • Q6. Discuss other orchestration tool in GCP
  • Ans. 

    Cloud Composer is another orchestration tool in GCP

    • Cloud Composer is a fully managed workflow orchestration service built on Apache Airflow

    • It allows you to author, schedule, and monitor workflows that span across GCP services

    • Cloud Composer provides a rich set of features like DAGs, plugins, and monitoring capabilities

    • It integrates seamlessly with other GCP services like BigQuery, Dataflow, and Dataproc

  • Answered by AI

Skills evaluated in this interview

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

(4 Questions)

  • Q1. Which of these 2 select * from table and select * from table limit 100 is faster
  • Ans. 

    select * from table limit 100 is faster

    • Using 'select * from table' retrieves all rows from the table, which can be slower if the table is large

    • Using 'select * from table limit 100' limits the number of rows retrieved, making it faster

    • Limiting the number of rows fetched can improve query performance

  • Answered by AI
  • Q2. Explain scd and Merge in bigquery
  • Ans. 

    SCD stands for Slowly Changing Dimension and Merge is a SQL operation used to update or insert data in BigQuery.

    • SCD is used to track changes to data over time in a data warehouse

    • Merge in BigQuery is used to perform insert, update, or delete operations in a single statement

    • Example: MERGE INTO target_table USING source_table ON condition WHEN MATCHED THEN UPDATE SET col1 = value1 WHEN NOT MATCHED THEN INSERT (col1, col2)

  • Answered by AI
  • Q3. Architecture of bigquery
  • Ans. 

    BigQuery is a fully managed, serverless data warehouse that enables scalable analysis over petabytes of data.

    • BigQuery uses a columnar storage format for efficient querying.

    • It supports standard SQL for querying data.

    • BigQuery allows for real-time data streaming for analysis.

    • It integrates with various data sources like Google Cloud Storage, Google Sheets, etc.

    • BigQuery provides automatic scaling and high availability.

  • Answered by AI
  • Q4. Dataflow function to split sentence
  • Ans. 

    Dataflow function to split sentence

    • Use the Split transform in Dataflow to split the sentence into words

    • Apply ParDo function to process each word individually

    • Use regular expressions to handle punctuation and special characters

  • Answered by AI

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
6-8 weeks
Result
Selected Selected

I applied via Company Website and was interviewed in Sep 2023. There were 3 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Bigquery architecture, Advanced SQL question scenario based, cloud storage questions,pubsub,dataflow
Round 2 - Technical 

(1 Question)

  • Q1. Used cases on bigquery and sql
  • Ans. 

    BigQuery is used for analyzing large datasets and running complex queries, while SQL is used for querying databases.

    • BigQuery is used for analyzing large datasets quickly and efficiently

    • SQL is used for querying databases to retrieve specific data

    • BigQuery can handle petabytes of data, making it ideal for big data analysis

    • SQL can be used to perform operations like filtering, sorting, and aggregating data

  • Answered by AI
Round 3 - HR 

(1 Question)

  • Q1. Salary discussion and location discussion

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Not Selected

I applied via Company Website and was interviewed before Mar 2023. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. What are sql joins explain About bigquery related
  • Ans. 

    SQL joins are used to combine rows from two or more tables based on a related column between them.

    • SQL joins are used to retrieve data from multiple tables based on a related column between them

    • Types of SQL joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

    • In BigQuery, joins can be performed using standard SQL syntax

    • Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column

  • Answered by AI
  • Q2. Bigquery, GCS related
Round 2 - One-on-one 

(1 Question)

  • Q1. About project related questions

Skills evaluated in this interview

Gcp Data Engineer Interview Questions & Answers

TCS user image KOMARI CHAITANYA

posted on 3 Oct 2024

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Company Website and was interviewed before Oct 2023. There were 3 interview rounds.

Round 1 - Coding Test 

Need to write codes based on the scenarios

Round 2 - Technical 

(2 Questions)

  • Q1. Reverser a number
  • Ans. 

    Reverse a given number

    • Convert the number to a string

    • Reverse the string

    • Convert the reversed string back to a number

  • Answered by AI
  • Q2. Recursion function for factorial
  • Ans. 

    Recursion function to calculate factorial of a number

    • Define a function that takes an integer as input

    • Base case: if input is 0, return 1

    • Recursive case: return input multiplied by factorial of input-1

    • Example: factorial(5) = 5 * factorial(4) = 5 * 4 * factorial(3) = ... = 5 * 4 * 3 * 2 * 1 = 120

  • Answered by AI
Round 3 - HR 

(2 Questions)

  • Q1. Why you choose tcs
  • Ans. 

    I chose TCS for its reputation, global presence, diverse opportunities, and focus on innovation.

    • TCS is a renowned company with a strong reputation in the IT industry

    • TCS has a global presence with offices in multiple countries, providing opportunities for international exposure

    • TCS offers diverse opportunities for career growth and development in various domains

    • TCS is known for its focus on innovation and cutting-edge te

  • Answered by AI
  • Q2. What is your notice period
  • Ans. 

    I am currently on a 30-day notice period.

    • My notice period is 30 days.

    • I am required to work for 30 more days before leaving my current position.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Learn

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Easy
Process Duration
2-4 weeks
Result
Selected Selected

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

Round 1 - Technical 

(3 Questions)

  • Q1. String is palindrome or not
  • Ans. 

    Check if a string is a palindrome or not

    • Compare the string with its reverse to check for palindrome

    • Ignore spaces and punctuation marks when comparing

    • Examples: 'racecar' is a palindrome, 'hello' is not

  • Answered by AI
  • Q2. Create gcs bucket using python
  • Ans. 

    Use Python to create a GCS bucket

    • Import the necessary libraries like google.cloud.storage

    • Authenticate using service account credentials

    • Use the library functions to create a new bucket

  • Answered by AI
  • Q3. Write a python code to trigger a dataflow job in cloud function
  • Ans. 

    Python code to trigger a dataflow job in cloud function

    • Use the googleapiclient library to interact with the Dataflow API

    • Authenticate using service account credentials

    • Submit a job to Dataflow using the projects.locations.templates.launch endpoint

  • Answered by AI

Skills evaluated in this interview

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 were 2 interview rounds.

Round 1 - One-on-one 

(7 Questions)

  • Q1. Explain your project
  • Ans. 

    Developed a data pipeline to ingest, process, and analyze customer feedback data for a retail company.

    • Used Google Cloud Platform services like BigQuery, Dataflow, and Pub/Sub for data processing.

    • Implemented data cleansing and transformation techniques to ensure data quality.

    • Created visualizations and dashboards using tools like Data Studio for stakeholders to easily interpret the data.

  • Answered by AI
  • Q2. GCP bigquery architecture
  • Q3. Gcp object versioning
  • Q4. Gcp storage class types
  • Ans. 

    GCP offers different storage classes for varying performance and cost requirements.

    • Standard Storage: for frequently accessed data

    • Nearline Storage: for data accessed less frequently

    • Coldline Storage: for data accessed very infrequently

    • Archive Storage: for data stored for long-term retention

  • Answered by AI
  • Q5. Sql optimisation techniques
  • Ans. 

    SQL optimization techniques focus on improving query performance by reducing execution time and resource usage.

    • Use indexes to speed up data retrieval

    • Avoid using SELECT * and instead specify only the columns needed

    • Optimize joins by using appropriate join types and conditions

    • Limit the use of subqueries and instead use JOINs where possible

    • Use EXPLAIN to analyze query execution plans and identify bottlenecks

  • Answered by AI
  • Q6. Sql coding date format and joins related questions
  • Q7. Partitioning and cluster by
Round 2 - One-on-one 

(2 Questions)

  • Q1. Advanced sql recursive cte and python code using lambda function to explode the list
  • Q2. Project explanation and daily activity and challenge faced in project

Interview Preparation Tips

Topics to prepare for Tech Mahindra Gcp Data Engineer interview:
  • SQL
  • PYSPARK
  • GCP
  • PYTHON
Interview preparation tips for other job seekers - Practice SQL and Python coding extensively; they are evaluating our problem-solving approach and logic, as well as the depth of knowledge we possess.

I applied via Walk-in and was interviewed in Mar 2022. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. What is big query, topics on python

Interview Preparation Tips

Interview preparation tips for other job seekers - GCP, python, big query airflow and also using python scripting

Interview Questionnaire 

3 Questions

  • Q1. About my self and my experience.
  • Q2. What's the reason for leaving previous job?
  • Q3. Technical question depends on process.

_VOIS Interview FAQs

How many rounds are there in _VOIS Gcp Data Engineer interview?
_VOIS interview process usually has 1 rounds. The most common rounds in the _VOIS interview process are Technical.
How to prepare for _VOIS Gcp 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 _VOIS. The most common topics and skills that interviewers at _VOIS expect are GCP, ActiveX, Program Management, Python and Sharepoint.
What are the top questions asked in _VOIS Gcp Data Engineer interview?

Some of the top questions asked at the _VOIS Gcp Data Engineer interview -

  1. project flow ,basic questions for project real...read more
  2. bigquery realated and airf...read more

Tell us how to improve this page.

_VOIS Gcp Data Engineer Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.5k Interviews
Infosys Interview Questions
3.6
 • 7.7k Interviews
Wipro Interview Questions
3.7
 • 5.7k Interviews
Tech Mahindra Interview Questions
3.5
 • 3.9k Interviews
HCLTech Interview Questions
3.5
 • 3.8k Interviews
Genpact Interview Questions
3.8
 • 3.1k Interviews
LTIMindtree Interview Questions
3.8
 • 3k Interviews
Jio Interview Questions
3.9
 • 1.7k Interviews
Bharti Airtel Interview Questions
4.0
 • 844 Interviews
DXC Technology Interview Questions
3.7
 • 819 Interviews
View all

_VOIS Gcp Data Engineer Reviews and Ratings

based on 1 review

5.0/5

Rating in categories

3.0

Skill development

4.0

Work-life balance

3.0

Salary

5.0

Job security

5.0

Company culture

3.0

Promotions

4.0

Work satisfaction

Explore 1 Review and Rating
Deputy Manager
624 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Assistant Manager
547 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Executive
547 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Manager
294 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Manager
155 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare _VOIS with

Bharti Airtel

4.0
Compare

Jio

3.9
Compare

TCS

3.7
Compare

Infosys

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