TCS Gcp Data Engineer Interview Questions and Answers for Freshers

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
Add your answer
Q2. SQL: 4th highest salary
Add your answer
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
Add your answer
Q4. Case Study: A new joiner in IT, how will you explain flow of project and ownership of work. Considering my YOE 3 years
Add your answer
Q5. Explain your project, and reasons behind why did you choose airflow over other orchestration tool.
Add your answer
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
Add your answer

Q1. Technical questions
Add your answer
Q2. Tell me about yourself
Add your answer
Q3. Questions on SQL queries
Add your answer
Q4. Python questions
Add your answer
Q5. DBT/snowflake questions
Add your answer

Q1. What is scd type 2?
Ans. 
SCD type 2 is a method used in data warehousing to track historical changes by creating a new record for each change.
• SCD type 2 stands for Slowly Changing Dimension type 2

• It involves creating a new record in the dimension table whenever there is a change in the data

• The old record is marked as inactive and the new record is marked as current

• It allows for historical tracking of changes in data over time

• Example: If a cust...read more
Answered by AI
Add your answer
Q2. Pyspark question read CSV from folder and add column in each csv file and write it to different location.
Add your answer

Q1. ML and deep learning questions
Add your answer

Q1. Projects discussion
Add your answer
Q2. Chatgpt architecture
Add your answer

Q1. What is L1 and L2 Regularization?
Ans. 
L1 and L2 regularization are techniques used in machine learning to prevent overfitting by adding penalty terms to the cost function.
• L1 regularization adds the absolute values of the coefficients as penalty term to the cost function.

• L2 regularization adds the squared values of the coefficients as penalty term to the cost function.

• L1 regularization can lead to sparse models by forcing some coefficients to be exactly zer...read more
Answered by AI
View 1 more answer

A="bala",b="Babu";
Print=A+b
O/p:
balababu

Python is a computer programming language use to build up software and websites designed by Rossum appear in 20 Feb 1991
1.Numpy is a python libraries working with arrays.
2.pandas is used to read the data sets.
3.matplotlib libraries for visualisation.
4.mission learning is divided into two parts.
*Supervised learning
*Unsupervised learning
5.deep learning is used to create artificial neurons.
6.advance excel is used for graphs and calculate the whole members at same time lot of useful things that have.
7mysql is mainly used for store the data.

Python, numpy, pandas, mission learning, deep learning, basic statistics, advance excel, MySQL

Python, numpy, pandas, mission learning, deep learning, basic statistics, advance excel, MySQL

Q1. Why we use mission learning Mission learning used for analysis the data's and we can able to predict and we add some additional algorithm it's mainly used for prediction and AI.
Ans. 
Mission learning is used for data analysis and prediction with additional algorithms for AI.
• Mission learning is a subset of machine learning that focuses on predicting outcomes based on data analysis.

• It involves using algorithms to learn patterns and make predictions based on new data.

• Examples include image recognition, natural language processing, and recommendation systems.
Answered by AI
Add your answer
Q2. Deep learning uses: Deep learning Mainly used for creating artificial neurons in the neural network. Deep learning is very aid about the mission how to work and artificial intelligence helps also
Add your answer
Q3. Statistics: Statistics is used for mathamatics operation and it helps to prediction. Example: We started to calculate how many persons live in between 20to25 age. That time statistics is very help to reduc...read more
Add your answer

I don't know idea about group discussion

Basic DP, Array Questions

Q1. Resume Walkthrough and Discussion, Medium level coding questions
Add your answer

Q1. Discussion with Manager
Add your answer

Q1. Normal HR round
Add your answer

Q1. Tell me your self
Ans. 
I am a detail-oriented individual with strong data entry skills and experience in various industries.
• I have worked as a data entry operator for 2 years at XYZ company

• I am proficient in Microsoft Excel and have experience in data analysis

• I have excellent typing speed and accuracy

• I am a quick learner and can adapt to new software and systems easily
Answered by AI
View 1 more answer
Q2. About your family members
Add your answer
Q3. About our company
Add your answer
Q4. Freshers or experienced
Add your answer