tiger analytics interview questions

In this video, I have talked about data engineering interview question asked in tiger analytics. All of the above question was asked in actual interview of mine. For more queries reach out to me on my below social media handle.

Dataset:-
data = [(1,'Arul','Chennai','2023-01-01' ),
(1,'Arul','Bangalore','2023-02-01' ),
(2,'Sam','Chennai','2023-01-01' ),
(3,'manish','patna','2023-01-01' ),
(3,'manish','patna','2023-03-15' ),
(3,'manish','patna','2023-02-27' )]

schema = StructType([ \
StructField("id",IntegerType(),True), \
StructField("name",StringType(),True), \
StructField("location",StringType(),True), \
StructField("date",StringType(),True), \
])

select * from table
""").show()

Second Data:-
data= [(1, 'Arul', 'SQL' ),
(1 ,'Arul' , 'Spark' ),
(2, 'Bhumica' , 'SQL' ),
(2 ,'Bhumica' , 'Spark' )]

schema= ['id','name','course']

select * from table
""").show()

Third Data:-
data=[(10 ,'Anil',50000, 18),
(11 ,'Vikas',75000, 16),
(12 ,'Nisha',40000, 18),
(13 ,'Nidhi',60000, 17),
(14 ,'Priya',80000, 18),
(15 ,'Mohit',45000, 18),
(16 ,'Rajesh',90000, 10),
(17 ,'Raman',55000, 16),
(18 ,'Sam',65000, 17)]

schema=['id','name','sal','mngr_id']

select * from manager_tbl
""").show()

Spark words count:-
count

#dataengineer #interview #interviewquestions
My Gear:-

My PC Components:-

[Watsonj]

for a 3 years experiend guy in this domain I would say questions were pretty easy. Thank you for the insight.

[kunalk]

I just like watching your videos, full of cream content, concepts and detailed explanations. Thank you Manish.

[diptiranjan]

Thank you manish bhai for such content .. and your spark fundamental and practical vedio are really helpful .. one more request is please create such content on delta tables as well . Again your content really helps others . Love from odisha ❤❤❤

[harshitanand]

bro your video is spectacular :), thanks

[kulyashdahiya]

Best playlist if someone is preparing for de interviews

[airaa]

Bro q5: SLECT mngr_id, Avg(salary) as avg_salary
From table_name
Group By mngr_id;
Ye bhi chaltha hai

[Blackhole-]

Thanks a lot. I have given interview, and this video helped me a lot...

[sabh]

A super simple solution to the last problem Manish ..
SELECT word, count(*)
FROM
(SELECT explode(split(Description, ' ')) AS word FROM mytable)
GROUP BY 1
ORDER BY 2 DESC


DataBricks DO NOT recommend now to use any RDD thing anymore .. else it you would loose the benefit of AQE Optimizer
Please correct me, if I am wrong

However, I find your videos great in quality.

[venkataramana-yhth]

Bhayya, can you please make a vedio on how to implement scd type 2 with clear explanation and example. I am struggling to find some solution for this... I have been following your content and it helped me to get a job . Thanks for that

[saikumaryalakurthi]

Hello manish, Is it mandatory to write in spark.sql or can we only use sql

[biramdevpawar]

We can also use string_agg() function for sencod sql query.

[snehaldawkhar]

average salary of manager ke question mein " group by 1, 2 " kyu liya hain?

[KumudaraniMahanta]

The second query group_concat is not working, can you please provide why it's not working?
?

[Itwithrajesh]

SLECT mngr_id, Avg(salary) as avg_salary
From table_name
Group By mngr_id;

[Aa-bfbk]

Bhaiya 1st round kya tha ? Test liye the koi platform par ya direct interview? And how many rounds were there ?

[prudhviraj]

Bro, how did you able to get calls with 90 days notice period

[Raju]

Bro i have data engineer tiger analytics interview round one i will have apptitude or like this SQL questions please clarify anyone

[anandhu_sekhar]

select id, name, location, date from (Select *, row_number() over(partition By(id) order by(date ) desc ) as rn from name)x where rn =1

[amitpatel]

I am really confused about whether should I prepare for DE or not. coming from non IT background and having exp in the backend only, I fear that I will not get shortlisted for these roles.

[lakshmipathig]

Hi bro, please make videos in english, nice content you casting