AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Go Digital Technology Consulting
Compare
Filter interviews by
Go Digital Technology Consulting Data Engineer Intern Interview Questions, Process, and Tips
Top Go Digital Technology Consulting Data Engineer Intern Interview Questions and Answers
- Q1. Write a code to remove duplicates from a given list.
- Q2. Whats is Temporary Table in SQL?
- Q3. What are CTE and Views in SQL?
Go Digital Technology Consulting Data Engineer Intern Interview Experiences
3 interviews found
Anonymous
Selected
I applied via Internshala and was interviewed in May 2024. There were 2 interview rounds.
3 Sections Quantity , Logical, Mcq code
(2 Questions)
- Q1. Window function in SQL
- Ans.
Window functions in SQL are used to perform calculations across a set of table rows related to the current row.
Window functions are used to calculate values based on a set of rows related to the current row.
They allow you to perform calculations without grouping the rows into a single output row.
Common window functions include ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE().
- Q2. Python Basics (Loop, functions, pandas)
Skills evaluated in this interview
Pranay Shah
Selected
I applied via Indeed and was interviewed in Dec 2023. There were 5 interview rounds.
General Aptitude test which is for 1 hour.
Coding test on individual preferred language (SQL or Python)
(8 Questions)
- Q1. Once passing the coding test, the interview will be taken as per your preferred language and related topics to SQL, Python, and projects
- Q2. Situation-based SQL Queries.
- Q3. Basic Python code
- Q4. What are CTE and Views in SQL?
- Ans.
CTE stands for Common Table Expression, a temporary result set that can be referenced within a SELECT, INSERT, UPDATE, or DELETE statement. Views are virtual tables created by a query.
CTE is defined using the WITH keyword and can be recursive.
CTEs are mainly used to simplify complex queries, improve readability, and reduce redundancy.
Views are saved queries that act as virtual tables, allowing users to query the view a...
- Q5. What is DDL, DML, & DCL?
- Ans.
DDL stands for Data Definition Language, DML stands for Data Manipulation Language, and DCL stands for Data Control Language.
DDL is used to define the structure of database objects such as tables, indexes, and views.
DML is used to manipulate data within the database, such as inserting, updating, and deleting records.
DCL is used to control access to data within the database, such as granting or revoking permissions.
- Q6. Write a code to remove duplicates from a given list.
- Ans.
Code to remove duplicates from a list of strings
Create a new empty list to store unique elements
Iterate through the given list and add elements to the new list only if they are not already present
Return the new list without duplicates
- Q7. Resume Related questions
- Q8. Whats is Temporary Table in SQL?
- Ans.
Temporary table in SQL is a table that exists temporarily and is automatically deleted when the session ends.
Temporary tables are created using CREATE TEMPORARY TABLE statement.
They are useful for storing intermediate results during complex queries.
Temporary tables are only visible to the current session and are automatically dropped when the session ends.
(2 Questions)
- Q1. General questions from Resume and some basic technical questions.
- Q2. Where do you see yourself in the next 5 years?
(1 Question)
- Q1. General HR discussions
Interview Preparation Tips
- SQL
- Python
- Database
Skills evaluated in this interview
I was interviewed in Sep 2023.
Basics of SQL and Python
Either SQL or Python whatever your preferrence MCQ and coding Test
(1 Question)
- Q1. Basics of SQL and Python and few business case questions.
Interview Preparation Tips
- SQL
- Python
Top trending discussions
Interview questions from similar companies
Selected
I applied via Company Website and was interviewed in Dec 2024. There was 1 interview round.
(4 Questions)
- Q1. What is data entry?
- Ans.
Data entry is the process of entering, updating, or verifying data in a computer system.
Entering data accurately and efficiently
Updating existing data with new information
Verifying data for accuracy and completeness
- Q2. What is your experience with data entry?
- Ans.
I have over 3 years of experience in data entry, including entering, verifying, and updating data in various databases.
Proficient in using Microsoft Excel and other data entry software
Accurate and efficient in typing and data entry tasks
Experience in maintaining confidentiality and data integrity
Handled large volumes of data entry tasks with tight deadlines
- Q3. What is difference between c and c++ ?
- Ans.
C is a procedural programming language while C++ is an object-oriented programming language.
C is a procedural programming language, focusing on functions and procedures.
C++ is an object-oriented programming language, allowing for classes, objects, and inheritance.
C does not support classes and objects, while C++ does.
C++ has features like polymorphism, encapsulation, and inheritance which are not present in C.
C++ is an...
- Q4. How you work msword
- Ans.
I am proficient in using MS Word for data entry tasks.
I am skilled in formatting text, tables, and images in MS Word.
I can create and edit documents, including reports, letters, and spreadsheets.
I am familiar with using templates and styles to maintain consistency in documents.
I am experienced in using features like spell check, track changes, and mail merge.
I am efficient in using keyboard shortcuts to speed up data e
Interview Preparation Tips
- Data Entry
- C
- HTML
(2 Questions)
- Q1. What is the full form of ETL?
- Ans.
ETL stands for Extract, Transform, Load. It is a process used in data warehousing to extract data from various sources, transform it into a consistent format, and load it into a target database.
ETL stands for Extract, Transform, Load
Extract: Involves extracting data from various sources such as databases, applications, and files
Transform: Involves cleaning, filtering, and transforming the extracted data into a consiste...
- Q2. ETL Full form is Exact, Transform, Load.
Interview Preparation Tips
Data Coding, 1hr, series of questions in excel
It was easy to medium level assessment .
I applied via Naukri.com and was interviewed in Aug 2024. There was 1 interview round.
(5 Questions)
- Q1. Why should hire you?
- Q2. What are your salary expectations?
- Q3. What are your strengths?
- Q4. Tell me about your self?
- Q5. What are your hobbies?
Interview Preparation Tips
Distinguish yourself by working hard
(2 Questions)
- Q1. What is overfitting in machine learning?
- Ans.
Overfitting occurs when a machine learning model learns the training data too well, including noise and outliers, leading to poor generalization on new data.
Overfitting happens when a model is too complex and captures noise in the training data.
It leads to poor performance on unseen data as the model fails to generalize well.
Techniques to prevent overfitting include cross-validation, regularization, and early stopping.
...
- Q2. Overfitting accurs when a model learns the details.......etc
- Ans.
Overfitting occurs when a model learns the details and noise in the training data to the extent that it negatively impacts the model's performance on new data.
Overfitting happens when a model is too complex and captures noise in the training data.
It leads to poor generalization and high accuracy on training data but low accuracy on new data.
Techniques to prevent overfitting include cross-validation, regularization, and...
Interview Preparation Tips
Pranav Chowdhary
Code signal , SQL python questions
Take home coding assignment - 10 days analysis and recommendations
(1 Question)
- Q1. 4 rounds - 1 behavioralm 2 case studies 1 presentation
Go Digital Technology Consulting Interview FAQs
Tell us how to improve this page.
Go Digital Technology Consulting Interviews By Designations
- Go Digital Technology Consulting Data Engineer Interview Questions
- Go Digital Technology Consulting Data Engineer Intern Interview Questions
- Go Digital Technology Consulting Associate Software Engineer Interview Questions
- Go Digital Technology Consulting Data Engineering Analyst Interview Questions
- Go Digital Technology Consulting Senior Developer Interview Questions
- Go Digital Technology Consulting Softwaretest Engineer Interview Questions
Interview Questions for Popular Designations
- Data Science Intern Interview Questions
- Data Analyst Intern Interview Questions
- Data Analyst Interview Questions
- Data Engineer Interview Questions
- Data Scientist Interview Questions
- Data Scientist Intern Interview Questions
- Data Entry Operator Interview Questions
- Senior Data Engineer Interview Questions
- Show more
Go Digital Technology Consulting Data Engineer Intern Interview Process
based on 3 interviews
1 Interview rounds
- Aptitude Test Round
Interview Questions from Similar Companies
Fast track your campus placements
|
Data Engineer
37
salaries
|  ₹3.3 L/yr - ₹8.6 L/yr |
|
Software Engineer
9
salaries
| ₹5 L/yr - ₹6.5 L/yr |
|
Associate Data Engineer
9
salaries
| ₹3 L/yr - ₹4.8 L/yr |
|
Associate Engineer
8
salaries
| ₹3 L/yr - ₹6.5 L/yr |
|
Associate Software Engineer
7
salaries
| ₹3.5 L/yr - ₹4.4 L/yr |
TCS
Wipro
Infosys
HCLTech
- Home >
- Interviews >
- Go Digital Technology Consulting Interview Questions >
- Go Digital Technology Consulting Data Engineer Intern Interview Questions
