Crack ETL Testing Interviews at PWC: Essential Questions & Answers

Are you gearing up for an ETL Testing interview at PWC? This video is your ultimate guide! Dive deep into the most frequently asked ETL Testing questions, covering crucial topics like data warehousing, data quality, data profiling, and more.

Learn effective strategies to tackle these questions with confidence and impress your interviewers. Whether you're a seasoned ETL tester or a budding professional, this video will equip you with the knowledge and skills you need to succeed.

#ETLTesting #PWCTechnicalInterview #DataWarehousing #DataQuality #DataProfiling #ETLTools #InterviewTips #TechnicalInterview #JobInterview #CareerAdvice #DataEngineering #DataScience #YouTubeCreator #YouTubeTutoria

[nagalakshmir]

Thanks to sharing the video pls do more sir

[YogitaShinde-ky]

Helpful video 🎉

Highest total order value

Select c.cust_id, c.name, sum(o.order_total) as Totalorder from Customer c inner join orders o on c.cust_id=o.cust_id
Group by c.name
Order by Totalorder desc
Limit 1

I have tried this

[pagadalasatheesh-yv]

Thank you for sharing the video. It's really useful for me for interview preparation.

[surbhivyas]

Hello sir, great video .
I want to join your Etl testing with python course. Please suggest

[PoojaWaghmare-fzhr]

2 : Find the customer who has placed the highest total order value

WITH CTE AS (select C.CUST_ID, name, SUM ( ORDER_TOTAL ) AS MAX_TOTAL
FROM ORDERS T INNER JOIN CUSTOMER C
ON (T.CUST_ID = C.CUST_ID)
GROUP BY name, C.CUST_ID )
SELECT CUST_ID, name, MAX_TOTAL FROM (SELECT CUST_ID, name, MAX_TOTAL, DENSE_RANK () OVER (ORDER BY MAX_TOTAL DESC ) AS RANK FROM CTE
)WHERE RANK = 1;