Go Digital Technology Consulting Interview Questions, Process, and Tips

Mainly about SQL and Python

Q1. What are window function in sql ? SQL joins? CTE in sql?
Ans. 
Window functions are used to perform calculations across a set of rows in a table.
• Window functions operate on a subset of rows called a window or frame.

• They can be used to calculate running totals, rankings, and moving averages.

• Examples of window functions include ROW_NUMBER, RANK, and LAG.

• SQL joins are used to combine rows from two or more tables based on a related column between them.

• Common types of joins include INN...read more
Answered by AI
Add your answer
Q2. What are lists? difference between list ,tupe, dict and sets ? how to extract elements from dict ?
Ans. 
Lists are ordered collections of items in Python.
• Lists are mutable, meaning their elements can be changed.

• Elements in a list are accessed using indexing.

• Lists can contain elements of different data types.

• Lists are denoted by square brackets [].
Answered by AI
Add your answer

Basic aptitude test, maths logic english; Python SQL and CS concepts

3 Hacker rank easy coding test at office. 2/3 would get you selected for next round

Q1. Python - generator expressions, asyncio, AWS lambda, iterator/iterable, multi threading,
Add your answer

Q1. Questions on CV, projects, SQL window functions
Add your answer

Q1. Questions on CV, Company details and other information was shared here along with 10hr work day, 1.5 year bond, 6 month appraisal
Add your answer

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