Add office photos
i
Tech Mahindra
Compare
Filter interviews by
Tech Mahindra Gcp Data Engineer Interview Questions, Process, and Tips
Top Tech Mahindra Gcp Data Engineer Interview Questions and Answers
- Q1. which of these 2 select * from table and select * from table limit 100 is faster
- Q2. gcp storage class types
- Q3. sql optimisation techniques
Tech Mahindra Gcp Data Engineer Interview Experiences
2 interviews found
Anonymous
I applied via Naukri.com and was interviewed in Nov 2024. There were 2 interview rounds.
(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.
- 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
- 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
- Q6. Sql coding date format and joins related questions
- Q7. Partitioning and cluster by
(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
- SQL
- PYSPARK
- GCP
- PYTHON
Manisa Sarangi
(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
- 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)
- 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.
- 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
Skills evaluated in this interview
Interview questions from similar companies
suresh p
(6 Questions)
- Q1. What are the GCP services used in your project
- Ans.
The GCP services used in our project include BigQuery, Dataflow, Pub/Sub, and Cloud Storage.
BigQuery for data warehousing and analytics
Dataflow for real-time data processing
Pub/Sub for messaging and event ingestion
Cloud Storage for storing data and files
- Q2. What is cloud function
- Ans.
Cloud Functions are event-driven functions that run in response to cloud events.
Serverless functions that automatically scale based on demand
Can be triggered by events from various cloud services
Supports multiple programming languages like Node.js, Python, etc.
- Q3. How to shedule job to trigger every hr in Airflow
- Ans.
To schedule a job to trigger every hour in Airflow, you can use the Cron schedule interval
Define a DAG (Directed Acyclic Graph) in Airflow
Set the schedule_interval parameter to '0 * * * *' to trigger the job every hour
Example: schedule_interval='0 * * * *'
- Q4. Bigquey architecture
- Q5. How display string in reverse using python
- Ans.
Use Python's slicing feature to display a string in reverse order.
Use string slicing with a step of -1 to reverse the string.
Example: 'hello'[::-1] will output 'olleh'.
- Q6. What is pub sub and where are you getting used in your project.
- Ans.
Pub/Sub is a messaging service that allows communication between independent applications.
Pub/Sub is used for real-time messaging and event-driven systems.
It is commonly used for data ingestion, streaming analytics, and event-driven architectures.
Examples of Pub/Sub services include Google Cloud Pub/Sub, Apache Kafka, and Amazon SNS/SQS.
I applied via LinkedIn and was interviewed in Oct 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Questions on SQL Joins and Window Functions
- Q2. GCP Big query and Cloud Storage qs
(2 Questions)
- Q1. About overall IT experience
- Q2. Project experience and services used
- Ans.
I have experience working on projects involving data processing, transformation, and analysis using GCP services like BigQuery, Dataflow, and Dataproc.
Utilized BigQuery for storing and querying large datasets
Implemented data pipelines using Dataflow for real-time data processing
Utilized Dataproc for running Apache Spark and Hadoop clusters for data processing
Worked on data ingestion and transformation using Cloud Stora
I applied via Naukri.com and was interviewed in Oct 2024. There was 1 interview round.
(1 Question)
- Q1. What is Iam what is sa what is bigquery various optimisations joins sql complex query what is qliksense GIThub schema routines schedules delete drop truncate GUI and terraform related spark basics file fo...
- Ans.
IAM is Identity and Access Management, SA is Service Account, BigQuery is a data warehouse, QlikSense is a data visualization tool, GitHub is a version control system, Spark is a distributed computing framework, Airflow is a workflow automation tool, Bigtable is a NoSQL database, Cloud Composer is a managed workflow orchestration service, Pub/Sub is a messaging service.
IAM is used to manage access to resources in Googl...
Interview Preparation Tips
- SQL
- Python
- pyspark
Skills evaluated in this interview
Selected
I applied via Naukri.com and was interviewed in Jun 2024. There was 1 interview round.
(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
- 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
- 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
Skills evaluated in this interview
(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
- 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
- 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
Skills evaluated in this interview
Selected
I applied via Company Website and was interviewed in Sep 2023. There were 3 interview rounds.
(1 Question)
- Q1. Bigquery architecture, Advanced SQL question scenario based, cloud storage questions,pubsub,dataflow
(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
(1 Question)
- Q1. Salary discussion and location discussion
Skills evaluated in this interview
I applied via Company Website and was interviewed before Mar 2023. There were 2 interview rounds.
(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
- Q2. Bigquery, GCS related
(1 Question)
- Q1. About project related questions
Skills evaluated in this interview
I applied via LinkedIn and was interviewed before Nov 2021. There were 3 interview rounds.
(1 Question)
- Q1. Ask about the GCP Projects we did before
(1 Question)
- Q1. Managerial questions with salary discussion
Interview Preparation Tips
Tech Mahindra Interview FAQs
Tell us how to improve this page.
Tech Mahindra Interviews By Designations
- Tech Mahindra Software Engineer Interview Questions
- Tech Mahindra Senior Software Engineer Interview Questions
- Tech Mahindra Customer Service Associate Interview Questions
- Tech Mahindra Associate Software Engineer Interview Questions
- Tech Mahindra Customer Service Executive Interview Questions
- Tech Mahindra Customer Support Associate Interview Questions
- Tech Mahindra Customer Care Executive Interview Questions
- Tech Mahindra Software Developer Interview Questions
- Show more
Interview Questions for Popular Designations
- Data Analyst Interview Questions
- Data Engineer Interview Questions
- Data Scientist Interview Questions
- Data Entry Operator Interview Questions
- Senior Data Engineer Interview Questions
- Senior Data Analyst Interview Questions
- Senior Data Scientist Interview Questions
- Data Science Intern Interview Questions
- Show more
People are getting interviews through
Gcp Data Engineer Interview Questions from Similar Companies
Fast track your campus placements
Tech Mahindra Gcp Data Engineer Reviews and Ratings
based on 1 review
Rating in categories
|
Software Engineer
26.3k
salaries
|  ₹2 L/yr - ₹9.1 L/yr |
|
Senior Software Engineer
21.2k
salaries
| ₹5.5 L/yr - ₹22.5 L/yr |
|
Technical Lead
11.5k
salaries
| ₹9.2 L/yr - ₹38 L/yr |
|
Associate Software Engineer
5.4k
salaries
| ₹1.8 L/yr - ₹6 L/yr |
|
Team Lead
4.9k
salaries
| ₹5.1 L/yr - ₹16.8 L/yr |
Infosys
Cognizant
Accenture
Wipro
Calculate your in-hand salary
- Home >
- Interviews >
- Tech Mahindra Interview Questions >
- Tech Mahindra Gcp Data Engineer Interview Questions
