When I give KT to my junior 😂😂 on running the TRUNCATE statement

Hey Engineers
Another freelance opportunity

I have a friend who needs some one who is good at SQL,SSIS,SSRS ,PostGreSQL
and Airflow

The client wants to migrate existing SSIS ETL packages


Please ping me on linkedin if you are interested.
linkedin.com/in/adityabansal095

#hiring #freelancer #jobalert #jobopportunity #ETL #SQLCommunity

Hi

Hope you're doing well.

We’re currently hiring for a Senior Python Developer role with one of our global consulting firm clients in pan India location , for a high-impact InsurTech transformation project.

Role highlights:

5+ years of experience in Python backend development

Mandatory experience in insurance products (Life / Health / General Insurance)

Strong exposure to insurance systems, APIs, and backend platforms

Opportunity to work on a large-scale InsurTech program

Unique exposure to learn and work on new-age insurance platforms that are rapidly booming in the industry

This role offers both deep insurance domain exposure and future-facing platform learning, making it a strong long-term career opportunity.

If this aligns with your profile or career direction, I’d be happy to share more details.
Also, referrals are most welcome and truly appreciated.

Warm regards,
Soham Ganguly
EliteRecruitments
www.eliterecruitments.com
https://www.linkedin.com/company/eliterecruitments

#hiring #jobalert #jobopportunity #python

Please check this job
Refer your friends if anyone is looking

🔥 Fractal Data Engineer Interview (23 LPA + 2L Variable)

This wasn’t about textbook SQL.
It was about real-world data engineering.

Here’s how it went 👇

📞 Screening
→ SQL + Python basics

💻 Round 1
→ Medium SQL problem
→ PySpark optimization
→ Kafka architecture
→ Custom PySpark function

🧠 Round 2 (Technical Deep Dive)
→ My project architecture
→ Design a scalable ETL from scratch
→ Schema evolution in Delta Lake
→ Azure stack discussion

👔 Round 3 (Managerial)
→ Leadership + ownership
→ Live coding (ETL test cases)
→ Real production challenges

💡 What they really tested:
Reliability. Scalability. Decision-making. Ownership.

Not memorized syntax.

🔥 Cracked 100 DAX Interview Questions — Here’s What Actually Matters

Power BI interviews aren’t basic anymore.

If you’re preparing for Data Analyst or BI roles, these DAX concepts are non-negotiable:

✅ SUM vs SUMX — Aggregation vs row-by-row evaluation
✅ CALCULATE — The king of filter context
✅ RANKX, FILTER, ALL, ALLEXCEPT — Core for dynamic reports
✅ Time Intelligence — TOTALYTD, SAMEPERIODLASTYEAR, DATEADD
✅ DIVIDE > / — Always handle division safely

DAX isn’t about memorizing formulas.
It’s about understanding context.

If you’re serious about cracking BI interviews, spend time mastering these this week. 🚀

Mine is cricket 🏏🥹

REPOSTING

🚨 New SQL Interview Video is LIVE! 🚨

Can you solve a real KPMG SQL interview question?

The task sounds simple…
But it tests your understanding of aggregation and logic 👀

👉 Calculate:
• Total Rides
• Won Rides
• Lost Rides

Think it’s easy? Try solving it before watching.

🎥 Watch now:
👉 https://youtu.be/tFaIBqj3jUI

After watching, tell me honestly —
Did you solve it correctly on your first attempt? 😏

More real-world SQL interview questions coming soon. Stay sharp. 🔥

Hey Guys
Is anybody working in Capgemini
One of us from our community need to get a referral in Capg

Please ping me on linkedin ,if you are a Capg employee

Let’s help each other and grow together😊

Hey Guys
Another freelancing role
Needed skill set - Snowflake,Aws,python,sql,Terraform, pyspark

Expectation -2.5 hours daily in evening

Please ping me urgently if you are interested on linkedin asap
linkedin.com/in/adityabansal095

This is an urgent opportunity

#jobalert #jobopportunity #freelancer

India won 🏆
It was a great match
At a moment I thought , England might win it 🙂😬

🚀 Data Analytics Essentials — Skills Every Analyst Must Master

If you want to grow faster as a Data Analyst, it’s not just about tools.
You need the right mix of technical + business skills.

Here’s a quick breakdown 👇

🧠 Technical Skills

1️⃣ SQL
• Joins, GROUP BY, Window Functions
• Handling NULLs & duplicates
💡 Example: Use LEFT JOIN to identify churn vs non-churn users.

2️⃣ Excel
• Pivot Tables, Lookups, IF logic
• Fast data cleaning
💡 Example: Summarize 50K rows instantly using pivots.

3️⃣ Power BI / Tableau
• Data modeling, measures, filters
• Build dashboards that answer one clear question.
📊 Example: Track sales drop by region & month.

4️⃣ Python
• pandas for data cleaning
• matplotlib / seaborn for quick visuals
💡 Example: Cohort-wise revenue analysis.

5️⃣ Statistics Basics
• Mean vs Median, Variance, Correlation
⚠️ Example: Median often explains salary distribution better than average.

⸻

🤝 Soft Skills (Equally Important)

1️⃣ Business Thinking – Always ask why before how.
2️⃣ Communication – Explain insights in simple terms.
3️⃣ Problem Framing – Convert vague questions into clear metrics.
4️⃣ Attention to Detail – Small data errors break trust.
5️⃣ Stakeholder Management – Listen first, challenge with data.

⸻

📌 Lesson:
Tools alone won’t make you a great analyst.
The real edge comes from combining technical skills with business thinking.

🔥 Pick one skill from this list and improve it.

#DataAnalytics #SQL #Python #PowerBI #AnalyticsSkills

🚀 Thinking of Hosting a Live SQL Interview Masterclass

I’m considering conducting a live SQL interview masterclass where we’ll solve real interview questions and learn the thinking process behind them.

Topics would include:
• Conditional aggregation questions
• Ranking & window function problems
• Real interview questions from companies
• Common SQL interview traps

It will be a small live session (max 50 people) so we can keep it interactive.

Before planning it, I want to check interest 👇

Would you be interested in joining?

📊 Vote below.