This job requires a seasoned snowflake developer along with experience in orchestration tools like DBT or Airflow ,informatica etc.

SQL is the backbone of any data related tool. It can be Power BI ,Tableau ,if you are good at SQL
No data tool is difficult.

Hello All
Today I’m going to share very interesting SQL concept that I came across in an interview.

The question?
“Can you calculate a running total — without using window functions?”

No OVER() clause. No shortcuts. Just pure SQL.
My mind went blank for a second... then it hit me!

I remembered an old trick using a correlated subquery.

Here’s what I came up with:


SELECT
A.SalesDate,
A.Amount,
(
SELECT SUM(B.Amount)
FROM Sales B
WHERE B.SalesDate <= A.SalesDate
) AS RunningTotal
FROM Sales A
ORDER BY A.SalesDate;


✅ No window functions
✅ Just raw SQL logic

I explained it step-by-step. The interviewer smiled. I was back in the game.

Then came the follow-up:

“Why isn’t this ideal for production?”

I gave it a shot:

1. 🚀 Works well on small datasets
2. ⚙️ Subqueries can get messy and harder to maintain
3. 🧩 Not as readable or efficient as window functions

He nodded… and then asked:

“Do you know the time complexity?”

I didn’t.
Not even a guess.

He explained:

1. ⏱️ This query runs with O(n²) time complexity
2. 🔄 Each row in the outer query triggers a full scan in the subquery
3. 📉 With large datasets, performance drops *fast*

That explanation stuck with me.

It was a lightbulb moment — not just for SQL, but for how I think about performance, scalability, and writing smarter queries.

Hello All
I’m conducting 1 to 1 sessions on Snowflake data engineering for the next 14 days.
Please hit me up on LinkedIn if you want to know why companies are ditching Oracle or SQL server and moving to Snowflake?
And what’s in it for you or how can you crack a Snowflake data engineering job?
This is absolutely free of cost ,please leverage this opportunity
Thanks
LinkedIn.com/in/adityabansal095

Job Alert

Hiring Power BI


Exp:6-10 yrs
CTC:25-26LPA
only May 20th joiners

Power bi Analyst , Bi Analyst , Analyst

Powerbi+sql+ etl+ dwh+

any salesforce or any crm exp is must

google analytics Or Adobe analytics any one is must

intrested can mail to madhavi@ambiencehr.com

Hello folks
If you want to become a data engineer ,always start from basics
Learn an ETL tool ,data warehousing basics
Do not feel overwhelmed by listening to buzz words like Azure ,AWS
Start from basics and then move on to cloud technologies.

Job Alert
Recruitment drive on May 10 in Gurgoan for ITC Infotech
PLSQL Informatica developer
Experience 4-7 years

Please reach out to me on LinkedIn,I can personally refer anyone for this.

Hey Folks
Again posting this

Recruitment drive on May 10 in Gurgoan for ITC Infotech
PLSQL Informatica developer
Experience 4-7 years

Please reach out to me on LinkedIn,I can personally refer anyone for this.

LinkedIn.com/in/adityabansal095

Hello All
I have successfully concluded the Intoduction to Snowflake sessions today.
I had the pleasure of talking to 11 folks who wanted to learn Snowflake and understand how it is getting used in real world projects

Please hit me up on LinkedIn if you want to know why companies are ditching Oracle or SQL server and moving to Snowflake?
And How can you utilise this to get better opportunities in your career?
Thanks
LinkedIn.com/in/adityabansal095

Job Alert Data Engineers

PwC Hiring!

Job Title: Associate Data Engineer
Location: Bangalore (Hybrid)

Key Skills:
▪️ SQL & Databricks(delta tables) & pyspark
▪️ AWS services (s3 & Lambda/Glue) & (Snowflake/Redshift)
🔸 Mandatory Requirements: Strong coding experience, particularly in Python & SQL, is essential for this associate role.

Total experience : 2-5.5 years
Relevant experience: 50% of total experience

Interested folks, can email their updated resume to deepa.radhakrishnan.nair@pwc.com

Job Alert
This is specially for freshers looking for internship

🚨 New Video Just Dropped!
🔎 Deloitte SQL Interview Question – Solved Step-by-Step

If you're preparing for data engineering or SQL interviews, this is a must-watch.

👉 In this video, I walk through a real SQL question asked at Deloitte that tests your understanding of employee hierarchy logic — a concept that shows up in many top tech interviews.

🎯 What you’ll learn:


How to approach tricky SQL interview questions


Step-by-step SQL query building


Best practices and common pitfalls


🎥 Watch the video here:
🔗 https://youtu.be/6QXOqp8cANs?si=hhdflZLgG432OLv0

📌 If you find it helpful, don't forget to like, comment, and subscribe — it helps me create more content like this for you.
Let’s grow together 💼💡
— Aditya

Job Alert

Hiring For Power BI Role

Experience-3+years
Location: Gurgaon
N.P-Immediate
Skills:
Power BI + SQL + DAX

Interested candidates may drop their resumes on anjali@firstcalli.com

Job Alert

Hi Everyone,
We are looking for senior data engineer role at HCLTech

Key skill- Snowflake,SQL, DBT,
Location- Pan India
Experience-6-12 years
work mode- Hybrid

Mail id- ssindh@hcltech.com

#engineer #hr #dataengineer #jobopening

If anyone wants to know in out of how DBT works and how it used along with Snowflake
Please hit me up on LinkedIn
LinkedIn.com/in/adityabansal095

Job Alert

🚨 Power BI Developers | Hyderabad | Immediate Joiners

Quadratyx Insights Pvt Ltd is urgently looking for experienced Power BI Developers (3–5 years) to join our team in Hyderabad.

🔹 Strong in Power BI, DAX, SQL
🔹 Hands-on with dashboards, data modeling
🔹 Immediate joiners preferred

📍 Location: Hyderabad



#hiring #PowerBI #HyderabadJobs #ImmediateJoiners #Quadratyx #DataJobs

🚀 New Video Alert: Master Recursive CTEs in SQL Server!🚀



I just dropped a brand-new video that breaks down Recursive CTEs — the one SQL concept that many learners find tricky but is actually super powerful once you get it.

In this video, you’ll learn:
✅ What anchor and recursive members really mean
✅ How recursion flows step-by-step behind the scenes
✅ How to solve the classic employee-manager hierarchy problem with SQL
🚫 Plus, the #1 mistake beginners make that leads to infinite loops

If you’ve been avoiding Recursive CTEs or want to crush your next SQL interview, this video is a must-watch!

🎥 Watch the video here:
👉 https://youtu.be/DNELd-YQYAE?si=DOWWKRFXIwA-EZp3

#SQL #RecursiveCTE #DataEngineering #SQLJunction #LearningTogether