Tata Cliq interview experience Real time questions & tips from candidates to crack your interview

Data Engineer

Tata Cliq
upvote
share-icon
2 rounds | 2 Coding problems

Interview preparation journey

expand-icon
Preparation
Duration: 2 months
Topics: SQL, Data warehouse, Big Data, Data Modelling, Python
Tip
Tip

Tip 1 : Practice Coding Questions on a coding platform which covers test cases also and you can track of your speed as well
Tip 2 : Prepare various optimisation techniques implemented in your project, how big stream of data is ingested
Tip 3 : Refresh basics of every skill you mentioned in resume and prepare high level questions of your expertise skill

Application process
Where: Linkedin
Eligibility: No
Resume Tip
Resume tip

Tip 1 : Don't make it too fancy as sometime, resume parse won't be parsing your resume correctly which may lead to rejection.
Tip 2 : Don't lie about anything in your resume, it's a red flag. You should be able to justify everything that is there in the resume.

Interview rounds

01
Round
Easy
Online Coding Interview
Duration90 Minutes
Interview date4 Nov 2021
Coding problem1

It had 14 MCQ questions and one coding question.

1. Minimum HP

Hard
25m average time
80% success
0/120
Asked in companies
AmazonUberOptum

You are playing a board game where you die when your hp (health points) becomes 0 or negative. Now you start with some initial hp, and start moving in the board starting from the top-left corner. You have to reach the bottom right corner of the board by only moving right and down. Whenever you arrive on a cell in the board your hp may increase or decrease by the amount written on the cell. If the cell has a positive value it means your hp increases, if it has a negative value it means your hp decreases. You need to return the minimum initial health required so that you can reach the rightmost corner.

For Example:
In the example below, if we follow the path shown in the figure, then the minimum initial hp required will be 3.

board

Try solving now
02
Round
Medium
Video Call
Duration60 Minutes
Interview date17 Nov 2021
Coding problem1

It started with introduction , discussion of some projects I did (in depth)
After as i have Machine Learning in my resume , asked some questions regrading data quality , how to improve it . What is considered as bad data
Then 2 DSA questions
3-4 SQL queries : nth largest salary , JOINS, etc

1. Search In Rotated Sorted Array

Moderate
30m average time
65% success
0/80
Asked in companies
FreshworksExpedia GroupPayPal

Aahad and Harshit always have fun by solving problems. Harshit took a sorted array consisting of distinct integers and rotated it clockwise by an unknown amount. For example, he took a sorted array = [1, 2, 3, 4, 5] and if he rotates it by 2, then the array becomes: [4, 5, 1, 2, 3].

After rotating a sorted array, Aahad needs to answer Q queries asked by Harshit, each of them is described by one integer Q[i]. which Harshit wanted him to search in the array. For each query, if he found it, he had to shout the index of the number, otherwise, he had to shout -1.

For each query, you have to complete the given method where 'key' denotes Q[i]. If the key exists in the array, return the index of the 'key', otherwise, return -1.

Note:

Can you solve each query in O(logN) ?
Try solving now

Here's your problem of the day

Solving this problem will increase your chance to get selected in this company

Skill covered: Programming

What is recursion?

Choose another skill to practice
Similar interview experiences
SDE - 1
3 rounds | 8 problems
Interviewed by Tata Cliq
1706 views
0 comments
0 upvotes
company logo
SDE - 1
4 rounds | 8 problems
Interviewed by Amazon
8519 views
0 comments
0 upvotes
company logo
SDE - Intern
1 rounds | 3 problems
Interviewed by Amazon
3320 views
0 comments
0 upvotes
company logo
SDE - 2
4 rounds | 6 problems
Interviewed by Expedia Group
2581 views
0 comments
0 upvotes
Companies with similar interview experiences
company logo
Data Engineer
2 rounds | 4 problems
Interviewed by Amazon
1838 views
0 comments
0 upvotes
company logo
Data Engineer
4 rounds | 15 problems
Interviewed by Intuit
0 views
0 comments
0 upvotes