Filter interviews by
Clear (1)
I applied via LinkedIn and was interviewed in Aug 2023. There were 2 interview rounds.
Normalization in SQL is the process of organizing data in a database to reduce redundancy and improve data integrity.
1NF (First Normal Form) - Each column in a table must contain atomic values, and there should be no repeating groups.
2NF (Second Normal Form) - Table should be in 1NF and all non-key attributes are fully functional dependent on the primary key.
3NF (Third Normal Form) - Table should be in 2NF and there sh...
Alter is used to modify the structure of a table, while update is used to modify the data in a table.
Alter is used to add, remove, or modify columns in a table.
Update is used to change the values of existing records in a table.
Alter can change the structure of a table, such as adding a new column or changing the data type of a column.
Update is used to modify the data in a table, such as changing the value of a specific
Use left join for computationally efficient way to find customer names from customer profile and transaction tables.
Use left join to combine customer profile and transaction tables based on customer id
Left join will include all customers from profile table even if they don't have transactions
Subquery may be less efficient as it has to be executed for each row in the result set
Using self join to analyze customer behavior in an e-commerce platform.
Identifying patterns in customer purchase history
Analyzing customer preferences based on past purchases
Segmenting customers based on their buying behavior
Use SQL query with window function to rank members by transaction amount in each city.
Use SQL query with PARTITION BY clause to group members by city
Use ORDER BY clause to rank members by transaction amount
Select the second highest member for each city
CTE is a temporary result set that can be referenced within a SELECT, INSERT, UPDATE, or DELETE statement. It is different from a Stored Procedure as it is only available for the duration of the query.
CTE stands for Common Table Expression and is defined using the WITH keyword.
CTEs are mainly used for recursive queries, complex joins, and simplifying complex queries.
CTEs are not stored in the database like Stored Proce...
List comprehension is a concise way to create lists in Python by applying an expression to each item in an iterable.
Syntax: [expression for item in iterable]
Can include conditionals: [expression for item in iterable if condition]
Example: squares = [x**2 for x in range(10)]
Lambda function is a serverless computing service that runs code in response to events and automatically manages the computing resources required.
Lambda functions are event-driven and can be triggered by various AWS services such as S3, DynamoDB, API Gateway, etc.
They are written in languages like Python, Node.js, Java, etc.
Lambda functions are scalable and cost-effective as you only pay for the compute time you consum...
A generator function is a function that can pause and resume its execution, allowing it to yield multiple values over time.
Generator functions are defined using the 'function*' syntax in JavaScript.
They use the 'yield' keyword to return values one at a time.
Generators can be iterated over using a 'for...of' loop.
They are useful for generating sequences of values lazily, improving memory efficiency.
Transformation in pyspark is lazy evaluation while Actions trigger execution of transformations.
Transformations are operations that are not executed immediately but create a plan for execution.
Actions are operations that trigger the execution of transformations and return results.
Examples of transformations include map, filter, and reduceByKey.
Examples of actions include collect, count, and saveAsTextFile.
Map applies a function to each element in a collection and returns a new collection. Flatmap applies a function that returns a collection to each element and flattens the result.
Map transforms each element in a collection using a function and returns a new collection.
Flatmap applies a function that returns a collection to each element and flattens the result into a single collection.
Map does not flatten nested collecti...
Broadcast Variables are read-only shared variables that are cached on each machine in a cluster for efficient data distribution.
Broadcast Variables are used to efficiently distribute large read-only datasets to all nodes in a Spark cluster.
They are useful for tasks like joining a small lookup table with a large dataset.
Broadcast variables are cached in memory on each machine to avoid unnecessary data shuffling during c
Top trending discussions
I applied via Naukri.com and was interviewed in Sep 2022. There were 3 interview rounds.
SQL test has been conducted nearer to 12-15 questions.
I applied via Campus Placement and was interviewed in Nov 2023. There were 4 interview rounds.
Blood Relations, Pipes and Cisterns, Time and work etc.
Question based on hashmap
Is Artificial Intelligence boon or ban.
I applied via Campus Placement and was interviewed before Nov 2023. There were 3 interview rounds.
Difficult aptitude, had to solve a lot of problems in 2 hrs
GD topic was "online vs offline education "
Approximately 1.5-2 million cars are sold in Delhi annually.
Consider population of Delhi (approx. 20 million)
Assume car ownership rate (approx. 10%)
Factor in replacement rate and new buyers
I applied via LinkedIn and was interviewed before Oct 2021. There were 3 interview rounds.
8 python coding
With 2 aptitude
Game based assessment.
More than 8 games need to play
Answering questions related to SQL joins, lambda function in Python, and difference between tuples and lists.
There are four types of joins in SQL: inner join, left join, right join, and full outer join.
Lambda function is an anonymous function in Python that can take any number of arguments, but can only have one expression.
Tuples are immutable and ordered collections of elements, while lists are mutable and ordered col...
I applied via Campus Placement and was interviewed in Nov 2022. There were 5 interview rounds.
Get questions from all topics and medium level questions
They give one topic and provide one minute for thinking its overall 30 min discussion
Latent view and analytics are essential for data-driven decision making. My best achievement is developing a predictive model for customer churn.
Latent view helps to uncover hidden patterns and insights in data that are not immediately apparent.
Analytics provides a systematic approach to analyzing data and extracting meaningful insights.
My best achievement is developing a predictive model for customer churn that helped
I applied via Campus Placement
It was easy to approach!
Discussions about common topics like boon or bane to society
Asked about the scenarios
Apptitude, tecncal, cognitiive
I applied via Campus Placement and was interviewed in Jul 2022. There were 7 interview rounds.
It comprised basic verbal,quants and logical questions of average difficulty.
This is an easy round to get through if you have a strong command of the English language and are able to speak confidently.Very general topics asked.
A game round comprising logical puzzles and games.
I am a data analyst with a strong background in statistics and programming.
Proficient in statistical analysis and data visualization tools such as Python, R, and Tableau
Experienced in analyzing large datasets and identifying trends and patterns
Skilled in creating reports and presentations to communicate data-driven insights
Strong problem-solving and critical thinking skills
Ability to work collaboratively in cross-funct...
Some of the top questions asked at the TransOrg Analytics Data Engineer interview -
based on 1 interview
Interview experience
based on 1 review
Rating in categories
Data Analyst
42
salaries
| ₹0 L/yr - ₹0 L/yr |
Analyst
36
salaries
| ₹0 L/yr - ₹0 L/yr |
Analytics Specialist
33
salaries
| ₹0 L/yr - ₹0 L/yr |
Data Scientist
22
salaries
| ₹0 L/yr - ₹0 L/yr |
Data Science Analyst
12
salaries
| ₹0 L/yr - ₹0 L/yr |
Fractal Analytics
Mu Sigma
LatentView Analytics
Tiger Analytics