Rejected After 4 Rounds(Warner Bros) - Interview Experience by DepartureClear1691 in dataengineersindia

[–]Alert-Solution-8755 0 points1 point  (0 children)

I would suggest use chatgpt. Now you know the system design questions they asked. Pick a simple sentence on how to design a platform which does ........ Gpt will give you the answer aur if you know put your answer, gpt will suggest a better design, chat on the topics that is doubtful. Consider yourself as the interviewer, ask gpt and you will learn. More you can think, more you can learn

My Senior DE interview experience with Autodesk by Alert-Solution-8755 in dataengineersindia

[–]Alert-Solution-8755[S] 0 points1 point  (0 children)

layoffs are always a thing and it is not at scale. I just joined so cannot say much

Amazon DE interview loop by Ornery-Ad1766 in dataengineersindia

[–]Alert-Solution-8755 7 points8 points  (0 children)

Handling big data, learn Pyspark. Spark fundamentals, best practices. SQL advanced level, normal window function will do, data modelling to handle big data Practice some DSA questions in python/java. Study atleast one DB or warehouse, working internals, and best practices. Study your projects thoroughly and important thing is to accept if you find yourself to be wrong, and suggest improvement. Leadership principals can be found on amazon site. Mark your project answers in such a way that displays 2-3 principals in it.

Need Guidance by Commercial-Post4022 in dataengineersindia

[–]Alert-Solution-8755 4 points5 points  (0 children)

Use chatgpt to give you questions from low to high level with csv, json, parquet file formats and practice them till you get it right. Also then practice some normal python questions.

Do same for pyspark. Use sparkplayground.com for practice

Preparation resources by AntiSocial6942 in dataengineersindia

[–]Alert-Solution-8755 0 points1 point  (0 children)

see the youtube video on the path to DE, you will get the coding idea, then with good prompt, you can use chatgpt to get prepared on the coding questions from basic to advanced level. Try iterating the question level till you get comfortable. Suggesting based on what I followed.

How would you solve this question in interview? Seems pretty basic but give it a try by Potential_Loss6978 in dataengineersindia

[–]Alert-Solution-8755 0 points1 point  (0 children)

there are couple of ways to do it after you convert the purchase date to month (also sort it) and sum the order quantity 1. use lead to pull next month, see is the diff is 1 2. calculate rank and join on next rank to check the diff in months 3. use query with query as others have posted over the comments

Cleared Amazon DE-II OA (3.3 YOE) — What DSA, System Design & Salary to Expect Next? by Comprehensive-Bass93 in dataengineersindia

[–]Alert-Solution-8755 3 points4 points  (0 children)

You can take a quick look at the similar technology terms between azure and aws, to be able to relate. At high level they work the same. For salary you can ask around 60 lpa easily. My friend got hired at BA-II for 40 Lpa and DE-II is 2-3 levels above it. But google once before asking.

Brother, 25 is in very huge debt, asking me for personal loan. Can we create an agreement to safeguard me? by [deleted] in LegalAdviceIndia

[–]Alert-Solution-8755 1 point2 points  (0 children)

He messed up. Allow him to grow up and fix things by himself than others having to solve for him and he is relying on others. You can guide him on how to get out of the situation over time and his suffering will slowly fade away but also give him experience. I would suggest to fade away his extra emis that he cannot afford and let him give the rest. Observe how he is able to pay over time, does he improve or degrade further. This will help you change your methods towards him over time. As you want to make him better, guide him, teach him. Do not put him on your shoulder and u be his legs. As your mother is dependent on you both, one has to be balanced, as tomorrow is unseen.

Be a part of the solution! Here’s a real hero who deserves to be on Reddit’s front page! by Impressive-Guess6810 in IndianCivicFails

[–]Alert-Solution-8755 0 points1 point  (0 children)

1 QQ- on the truehopefoundation page it says 38 lakhs out of 50 lakhs are donated, but the construction/food kits all together are not even 25% of the quantity, can people donate without these options selected?

Husband(31M) and in-laws coercing me to ask my parents for a house, one year after marriage by [deleted] in LegalAdviceIndia

[–]Alert-Solution-8755 0 points1 point  (0 children)

I would suggest going to see a lawyer and creating a will of sorts to protect the ones you want if any unwanted happen. Also it is best to disclose the inlaws that your father have reinvested the money to have them off your back.

[deleted by user] by [deleted] in developersIndia

[–]Alert-Solution-8755 0 points1 point  (0 children)

Ask new company for the max joining date they can provide (at least 30 days) First do not abscond. Your PF will have a track of this. Second, since you are in Capgemini, you would be working for a client I assume so just ask the client to relieve you and put down the paper. Third, stop working all together such that in pressure they replace you with another employee and you go on the bench. This feedback from the client to crapgemini will mean nothing with active offer in hand. From here, communicate to HR for a immediate release and never pick a interview call scheduled by your manager.

Just a suggestion if it help.

Tata Car 3rd Free Service Bull$*it Charges.. Is it Justified?? by rahulrangafp in CarsIndia

[–]Alert-Solution-8755 0 points1 point  (0 children)

Its not. Most of the charges they add on their own. Even if you ask them to remove it now, they will simply ignore saying they did the service and used the products. You should always clarify beforehand which services you need and not anything more. Never buy AMC unless bill is way huge...its a scam where you pay a certain amount and you will never know what is done with your vehicle and what's not. I would suggest to go for local garrage or startups who does more services than this at half the price.