Job Alert

Urgent Hiring
Snowflake with DBT

Job description
Experience: 5-10 Years
Mandatory skills: Candidate should be on Data Engineer background, Snowflake, SQL, Looker (All mandatory)
Good to have: Python, Terraform.

Skills:
1. Expertise in building data platforms & warehouses with Snowflake covering all aspects of data engineering practices.
2. Expertise in using ETL tools like DBT etc.
3. Expert at writing and optimizing SQL queries.
4. Knowledge of AWS/Azure and various services related to data engineering is a must.
5. Should have worked on developing and optimizing data pipelines (spark code).
6. Should have experience with NFRs for data platforms like data quality, governance, security and compliance aspects.

Location-Gurgaon, Remote
Full Time

Interested candidates can apply at
deepali.dogra@akivna.com

If anyone wants to brush up on Snowflake or DBT
I can definitely help you out
Please reach out to me on LinkedIn

Still stuck with on-prem databases? It’s time to switch!
More and more companies are migrating to Snowflake – and for good reason: Scalability, speed, simplicity, and major cost savings.

I’ve been part of multiple real-world Snowflake migrations, and trust me – this shift is happening fast.
Snowflake Data Engineers are in high demand, and this is the perfect time to make your move.

If anyone wants to make the switch from on premises database to Snowflake
,please message me on LinkedIn
LinkedIn.com/in/adityabansal095

Snowflake is currently very trending in market and there are numerous reasons for that.

Job Alert

Check out this job at Hatch Pros: Data Engineer- SNOWFLAKE https://www.linkedin.com/jobs/view/4214626049

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