i
Filter interviews by
Top trending discussions
Window functions are used in SQL to perform calculations across a set of table rows related to the current row.
Types include ROW_NUMBER(), RANK(), DENSE_RANK(), NTILE(), LAG(), LEAD(), FIRST_VALUE(), LAST_VALUE(), etc.
They allow for calculations to be performed on a specific subset of rows within a query result set.
Window functions are commonly used for running totals, moving averages, and ranking data.
Joins are used to combine rows from two or more tables based on a related column between them.
Inner Join: Returns rows when there is a match in both tables.
Left Join: Returns all rows from the left table and the matched rows from the right table.
Right Join: Returns all rows from the right table and the matched rows from the left table.
Full Outer Join: Returns rows when there is a match in one of the tables.
Cross Join: ...
I appeared for an interview in Dec 2021.
Round duration - 90 Minutes
Round difficulty - Easy
Problem solving using SQL questions
Round duration - 90 Minutes
Round difficulty - Easy
A marketing campaign is run, how will you decide metrics to be tracked. Techincaly a KPI round
Metrics selection based on campaign objectives, target audience, and key performance indicators.
Identify campaign objectives and goals
Consider target audience and their behavior
Select key performance indicators (KPIs) relevant to the campaign
Track metrics such as conversion rate, click-through rate, ROI, customer acquisition cost
Analyze data to measure success and make data-driven decisions
Round duration - 30 Minutes
Round difficulty - Easy
Social empathatic fit round
Tip 1 : SQL logics to be understood completely
Tip 2 : A good running working logic of Python
Tip 3 : Basics of Dashboarding
Tip 1 : One pager , single column resume which shows all your skills
Tip 2 : Mention all things that make you relevant for the job
I applied via Referral and was interviewed before May 2023. There was 1 interview round.
I appeared for an interview in Sep 2024.
I am a data analyst with a strong background in statistics and data visualization.
Experienced in analyzing large datasets using SQL, Python, and R
Skilled in creating insightful reports and dashboards using Tableau and Power BI
Strong communication skills to present findings to stakeholders
Certified in data analysis and machine learning techniques
My strength lies in my analytical skills and attention to detail, while my weakness is sometimes getting too caught up in the details.
Strength: Strong analytical skills
Strength: Attention to detail
Weakness: Getting caught up in details (provide example)
I appeared for an interview in Apr 2025, where I was asked the following questions.
I am looking for a competitive salary that reflects my skills and experience in data analysis, ideally in the range of $70,000 to $90,000.
Research industry standards: For example, Glassdoor and Payscale indicate that data analysts in my region earn between $70,000 and $90,000.
Consider my experience: With over 3 years in data analysis and proficiency in tools like SQL and Python, I believe I bring significant value.
Fact...
I admire TU's commitment to innovation and data-driven decision-making, which aligns perfectly with my passion for analytics.
TU's focus on cutting-edge technology in data analysis inspires me to contribute to impactful projects.
The collaborative environment at TU encourages knowledge sharing, which I value for personal and professional growth.
I am impressed by TU's initiatives in community engagement, and I want to lev...
I applied via Referral and was interviewed in Nov 2023. There were 4 interview rounds.
Currently working on analyzing customer data for a retail company.
Analyzing customer purchase history
Identifying trends and patterns in customer behavior
Segmenting customers based on demographics and purchase preferences
I applied via Approached by Company and was interviewed before Mar 2023. There were 3 interview rounds.
3 SQL questions were given
I applied via LinkedIn and was interviewed before Mar 2023. There were 2 interview rounds.
Conditional formatting in Excel allows users to format cells based on specified conditions.
Select the range of cells you want to apply conditional formatting to
Go to the 'Home' tab and click on 'Conditional Formatting'
Choose the desired formatting option, such as color scales, data bars, or icon sets
Set the conditions for when the formatting should be applied, such as greater than, less than, or equal to a certain valu...
I applied via Referral and was interviewed in Sep 2023. There were 4 interview rounds.
Technical SQL Coding Round of 1 hour
Began with 2 easy generic question -
1. No. of record on different types of joins.
2. Employees who have higher salaries than their managers,
Then moved to medium questions -
1. Implement Rolling sum with & without window functions.
2. Other questions were on CTEs, Joins & other complex queries.
Bar Raiser Round of 1 hour involving -
1. Case study: How can we leverage product knowledge & analytics to increase Amazon Prime Revenue from 10% to 12%?
2. Metrics awareness: Common metrics discussion like DAU, PDAU, MAU, Retention, Churn, etc.
3. Resume based work exp discussion
based on 2 reviews
Rating in categories
Software Engineer
83
salaries
| ₹2.5 L/yr - ₹10.4 L/yr |
Area Sales Manager
47
salaries
| ₹4.6 L/yr - ₹9.5 L/yr |
QA Engineer
27
salaries
| ₹3.8 L/yr - ₹9.6 L/yr |
Assistant Manager
23
salaries
| ₹7 L/yr - ₹12.8 L/yr |
Customer Support Executive
22
salaries
| ₹2.1 L/yr - ₹3.4 L/yr |
AGS Transact Technologies
Hitachi Payment Services
Rupeek
Mobikwik