Add office photos
i
Cognizant
CompareProud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Cognizant Gcp Data Engineer Interview Questions and Answers for Experienced
Cognizant Gcp Data Engineer Interview Experiences for Experienced
2 interviews found
Selected
I applied via Naukri.com and was interviewed in Nov 2023. There was 1 interview round.
(1 Question)
- Q1. What is GCP Bigquery, Architecture of BQ, Cloud composer, What Is DAG . Visualization studio like Looker, data studio.
- Ans.
GCP BigQuery is a serverless, highly scalable, and cost-effective data warehouse for analyzing big data sets.
BigQuery is a fully managed, petabyte-scale data warehouse that enables super-fast SQL queries using the processing power of Google's infrastructure.
BigQuery's architecture includes storage, Dremel execution engine, and SQL layer.
Cloud Composer is a managed workflow orchestration service that helps you create, s...
Interview Preparation Tips
Having good knowledge of GCP Bigquery and Data transfer service for streaming and batch data.
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in Apr 2022. There were 3 interview rounds.
(1 Question)
- Q1. GCP Services, What is use of Bigquery? What is Pubsub,Dataflow,cloud storage. Question related previous roles and responsibility.
- Ans.
Bigquery is a cloud-based data warehousing tool used for analyzing large datasets quickly. Pubsub is a messaging service, Dataflow is a data processing tool, and Cloud Storage is a scalable object storage service.
Bigquery is used for analyzing large datasets quickly
Pubsub is a messaging service used for asynchronous communication between applications
Dataflow is a data processing tool used for batch and stream processin...
(1 Question)
- Q1. What is your Salary expectations?
Interview Preparation Tips
Skills evaluated in this interview
Gcp Data Engineer Jobs at Cognizant
Interview questions from similar companies
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
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 Naukri.com and was interviewed before Nov 2021. There were 2 interview rounds.
(2 Questions)
- 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...
- 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
Interview Preparation Tips
- Bigquery
- Python
- SQL
- Terraform
- SDLC
Skills evaluated in this interview
Selected
I applied via Naukri.com and was interviewed in Mar 2024. There was 1 interview round.
(2 Questions)
- Q1. Tell. me about youself
- Q2. Sql question , pyspark questions
Data Engineer Interview Questions & Answers
Societe Generale Global Solution Centre
Anonymous
posted on 19 Nov 2024
Selected
I applied via Naukri.com and was interviewed in May 2024. There was 1 interview round.
1. Questions on spark basica
2. Sql coding questions
3. Java or scala basics
Selected
I applied via Naukri.com and was interviewed in Aug 2023. There were 4 interview rounds.
I will do tha study for all company cases
I will give aptitude test
(7 Questions)
- Q1. I will try to solved all technical issue
- Q2. Asked tha questions to releted data entry operator
- Q3. I take my work time
- Q4. Slove tha query who give me dara
- 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
- Q6. Asked how to do group discussion.
- Q7. How can slove tha all data questions
Interview Preparation Tips
Daniyal Shaikh
(1 Question)
- Q1. Data Sceince related questions
I applied via Naukri.com and was interviewed in Sep 2022. There were 2 interview rounds.
(2 Questions)
- Q1. This is any questions. Computer basic knowledge. Data entry Opreter.
- Q2. Advance excel knowledge.
Interview Preparation Tips
Cognizant Interview FAQs
Some of the top questions asked at the Cognizant Gcp Data Engineer interview for experienced candidates -
Tell us how to improve this page.
Cognizant Interviews By Designations
- Cognizant Programmer Analyst Interview Questions
- Cognizant Programmer Analyst Trainee Interview Questions
- Cognizant Associate Interview Questions
- Cognizant Senior Associate Interview Questions
- Cognizant Processing Executive Interview Questions
- Cognizant Software Engineer Interview Questions
- Cognizant Senior Processing Executive Interview Questions
- Cognizant 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
Cognizant Gcp Data Engineer Reviews and Ratings
based on 3 reviews
Rating in categories
|
Associate
72.4k
salaries
|  ₹5.1 L/yr - ₹16 L/yr |
|
Programmer Analyst
55.4k
salaries
| ₹2.4 L/yr - ₹9.7 L/yr |
|
Senior Associate
48.2k
salaries
| ₹9 L/yr - ₹27 L/yr |
|
Senior Processing Executive
28.6k
salaries
| ₹1.8 L/yr - ₹9 L/yr |
|
Technical Lead
17.5k
salaries
| ₹5.9 L/yr - ₹24.1 L/yr |
TCS
Infosys
Wipro
Accenture
Calculate your in-hand salary
- Home >
- Interviews >
- Cognizant Interview Questions >
- Cognizant Gcp Data Engineer Interview Questions for Experienced
