Go Digital Technology Consulting Data Engineer Intern Interview Questions, Process, and Tips

3 Sections Quantity , Logical, Mcq code

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().
Answered by AI
Add your answer
Q2. Python Basics (Loop, functions, pandas)
Add your answer

General Aptitude test which is for 1 hour.

Coding test on individual preferred language (SQL or Python)

Q1. Once passing the coding test, the interview will be taken as per your preferred language and related topics to SQL, Python, and projects
Add your answer
Q2. Situation-based SQL Queries.
Add your answer
Q3. Basic Python code
Add your answer
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...read more
Answered by AI
Add your answer
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.
Answered by AI
Add your answer
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
Answered by AI
Add your answer
Q7. Resume Related questions
Add your answer
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.
Answered by AI
Add your answer

Q1. General questions from Resume and some basic technical questions.
Add your answer
Q2. Where do you see yourself in the next 5 years?
Add your answer

Q1. General HR discussions
Add your answer

Basics of SQL and Python

Either SQL or Python whatever your preferrence MCQ and coding Test

Q1. Basics of SQL and Python and few business case questions.
Add your answer