Tech Mahindra Gcp Data Engineer Interview Questions and Answers for Experienced

Q1. Bigquery architecture, Advanced SQL question scenario based, cloud storage questions,pubsub,dataflow
Add your answer

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
Add your answer

Q1. Salary discussion and location discussion
Add your answer

Q1. Explain Google cloud bigquery architecture?
Ans. 
Google Cloud BigQuery is a fully-managed, serverless data warehouse that uses a distributed architecture for processing and analyzing large datasets.
• BigQuery uses a distributed storage system called Capacitor for storing and managing data.

• It uses a distributed query engine called Dremel for executing SQL-like queries on large datasets.

• BigQuery separates storage and compute, allowing users to scale compute resources ind...read more
Answered by AI
View 1 more answer
Q2. Python: list and Tupple differences
Ans. 
List and tuple are both used to store collections of data, but they have some differences.
• Lists are mutable while tuples are immutable

• Lists use square brackets [] while tuples use parentheses ()

• Lists are typically used for collections of homogeneous data while tuples are used for heterogeneous data

• Lists have more built-in methods than tuples
Answered by AI
Add your answer

Q1. Aws sevices you have worked on
Ans. 
I have worked on various AWS services including S3, EC2, Lambda, Glue, and Redshift.
• S3 - Used for storing and retrieving data

• EC2 - Used for running virtual servers

• Lambda - Used for serverless computing

• Glue - Used for ETL (Extract, Transform, Load) processes

• Redshift - Used for data warehousing and analytics
Answered by AI
Add your answer
Q2. Question on python list and dictionary
Add your answer

Q1. Questions on project and skillset
Add your answer

Q1. Machine learning related questions and the theory of its operation
Add your answer

Q1. Tell. me about youself
Add your answer
Q2. Sql question , pyspark questions
Add your answer

I will do tha study for all company cases

I will give aptitude test

Q1. I will try to solved all technical issue
Add your answer
Q2. Asked tha questions to releted data entry operator
Add your answer
Q3. I take my work time
Add your answer
Q4. Slove tha query who give me dara
Add your answer
Q5. Give any response to short time
Ans. 
Respond promptly with concise information
• Provide relevant details quickly

• Avoid unnecessary elaboration

• Be clear and concise in communication
Answered by AI
Add your answer
Q6. Asked how to do group discussion.
Add your answer
Q7. How can slove tha all data questions
Add your answer

Q1. Data Sceince related questions
Add your answer

Basic Questions on python related to strings

Q1. What method to reduce time complexity
Add your answer
Q2. Which technology will suit a particylar situation
Ans. 
Choosing the right technology depends on the specific requirements of the situation.
• Consider the data size and complexity

• Evaluate the processing speed and scalability

• Assess the cost and availability of the technology

• Take into account the skillset of the team

• Examples: Hadoop for big data, Spark for real-time processing, AWS for cloud-based solutions
Answered by AI
Add your answer