SQL Junction
2.92K subscribers
17 photos
1 video
7 files
90 links
Download Telegram
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
๐Ÿ‘1
๐Ÿ”ฅ 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.
๐Ÿ‘3โค2
๐Ÿ”ฅ 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. ๐Ÿš€
๐Ÿ‘3
SQL Junction pinned Deleted message
SQL Junction pinned Deleted message
Whats your plan for this weekend?
Final Results
69%
Upskilling
21%
Cricket
7%
Netflix
3%
Trip
โค1๐Ÿ‘1
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. ๐Ÿ”ฅ
๐Ÿ”ฅ2โค1
SQL Junction pinned ยซ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โ€ฆยป
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๐Ÿ˜Š
โค4๐Ÿ‘4
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 ๐Ÿ™‚๐Ÿ˜ฌ
โค2๐Ÿ”ฅ2
๐Ÿš€ 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.
SQL Junction pinned ยซ๐Ÿš€ 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โ€ฆยป
SQL Junction pinned ยซWould you be interested in joining?ยป
๐Ÿš€ Essential SQL Commands Every Data Professional Should Know

Whether youโ€™re preparing for SQL interviews or working with databases daily, these commands form the backbone of SQL.

Hereโ€™s a quick refresher ๐Ÿ‘‡

๐Ÿ”น SELECT โ€“ Retrieve data from a table
๐Ÿ”น INSERT โ€“ Add new records into a table
๐Ÿ”น UPDATE โ€“ Modify existing data
๐Ÿ”น DELETE โ€“ Remove specific records

๐Ÿ“ฆ Database Structure

๐Ÿ”น CREATE โ€“ Create new database objects (tables, databases)
๐Ÿ”น ALTER โ€“ Modify the structure of an existing object
๐Ÿ”น DROP โ€“ Delete an entire table or database

๐Ÿ“Š Filtering & Analysis

๐Ÿ”น WHERE โ€“ Filter records based on conditions
๐Ÿ”น GROUP BY โ€“ Group rows with similar values
๐Ÿ”น HAVING โ€“ Filter aggregated results

๐Ÿ”— Working with Multiple Tables

๐Ÿ”น JOIN โ€“ Combine data from multiple tables

โšก Performance

๐Ÿ”น INDEX โ€“ Speeds up data retrieval in large tables

๐Ÿ“Œ Tip:
Mastering these fundamentals makes solving complex SQL problems much easier.

๐Ÿ”ฅ Try this today:
Pick one command and write a small query to practice it.

#SQL #LearnSQL #DataEngineering #DataAnalytics
โค1๐Ÿ‘1
๐Ÿ“Š Common SQL Window Functions You Should Know

Window functions = next-level SQL ๐Ÿš€
They help you analyze data without losing rows.

๐Ÿ”ข ROW_NUMBER()
Gives a unique number to each row
๐Ÿ‘‰ Perfect for deduplication & ordering

๐Ÿ† RANK()
Assigns rank with gaps
๐Ÿ‘‰ If 2 people tie, next rank is skipped (1, 2, 2, 4)

๐Ÿฅ‡ DENSE_RANK()
Assigns rank without gaps
๐Ÿ‘‰ No skipping (1, 2, 2, 3)

๐Ÿ“ˆ SUM() OVER()
Calculates running totals
๐Ÿ‘‰ Great for cumulative sales, revenue trends

โฎ๏ธโญ๏ธ LAG() / LEAD()
Compare with previous/next row
๐Ÿ‘‰ Useful for time-based analysis, growth tracking

โšก Why it matters?
Because real-world data problems need row-level + aggregated insights together
๐Ÿ‘2