SQL Junction
2.92K subscribers
17 photos
1 video
7 files
90 links
Download Telegram
🚨 Urgent Hiring: Data Analyst / MIS-WFM Manager @ GlobalLogic, Gurgaon

Are you a data-driven professional with a passion for optimizing performance and uncovering insights? Join GlobalLogic in Gurgaon as a MIS & Workforce Management (WFM) Team Manager and take charge of transforming operational efficiency through smart analytics and workforce planning.

In this leadership role, you'll manage a skilled MIS/WFM team, create high-impact dashboards, and collaborate cross-functionally to ensure billing accuracy and data-backed decision-making. Your expertise in Excel, forecasting models, and reporting will drive critical business outcomes.

✅ What You’ll Need:
5+ years in MIS or WFM, ideally in service-based industries
Strong command of Excel (formulas, pivots, macros)
Exposure to Amazon Connect, Monte Carlo simulations, and SARIMA/ARIMA forecasting
Knowledge of BE6 billing models
Bonus: Power BI or Tableau skills
Excellent stakeholder communication & sharp analytical thinking

💼 Key Responsibilities:
Lead MIS & WFM initiatives for reporting, forecasting, and planning
Build dashboards using Excel/Power BI for real-time insights
Monitor and optimize key metrics: staffing, schedule adherence, occupancy
Ensure billing accuracy, reconcile timesheets, and manage invoices
Drive strategic decisions through data storytelling and collaboration
❤1
This is an urgent hiring ,it looks like to be a data analyst role
Salary for right candidate is around 15-18 LPA
Please reach out to me immediately on LinkedIn
If you are interested
LinkedIn.com/in/adityabansal095
❤1
🚨Hiring Data Analyst Freshers!

If you’re skilled in SQL, Python, Power BI & Excel and can join within 15 days, this is your chance.

Fresh minds. Real data. Big impact.

🔗 Apply now: https://lnkd.in/gP6YgNVK

Tag & share with someone who needs this!
🚨 New Video Just Dropped!

📺 Just uploaded a fresh YouTube video where I break down a Hard Google SQL interview question:

🎬 Compare the rating of an actor’s most recent film with the average of all their previous films.

If you’re preparing for SQL interviews or just want to level up your logic — this is a must-watch!

📌 Watch here: https://youtu.be/gZ7ZKtKvL7s
🔥 Don’t forget to like, comment, and share if it helps!

Please help me in reaching 500 subscribers, Guys!!

#SQLJunction #SQLInterview #Google #DataEngineering #InterviewPrep #DataJobs
Hey Folks
Apologies
I have been busy with the past month with freelance hiring.
Sure! Here's a concise and engaging Telegram post you can use to share your YouTube video in your SQL Junctionchannel:

🚀 NEW VIDEO DROP – SQL Interview Question from Netflix!
🔗 Watch now on YouTube (Netflix SQL Server Complex Interview Question Series | Recommend Pages Based on Friends’ Activity
https://youtu.be/GKY6TN1X4dY)

📌 Problem Statement:
You're given two tables – user_friends and user_pages.
Your task?
🎯 Recommend pages to users that they don’t follow but at least one of their friends does.
This was asked in a real Netflix SQL interview!
✅ In the video, I break down:
The logic step-by-step
How to write the SQL query
Key concepts like anti-joins, self joins, and recommendation filtering
Perfect for:
🔸 SQL learners
🔸 Data analyst/engineer interview prep
🔸 Anyone curious how Facebook-style recommendations work under the hood!
👨‍💻 Watch now & level up your SQL skills!
🎬 Netflix SQL Server Complex Interview Question Series | Recommend Pages Based on Friends’ Activity
https://youtu.be/GKY6TN1X4dY


#SQL #SQLJunction #NetflixInterview #SQLChallenge #DataEngineering #SQLQuery #TechInterview #TelegramLearning
🚨 SQL Interview Prep Kit 🚨


1️⃣ Aggregations
2️⃣ Window Functions
3️⃣ Set Operators
4️⃣ Indexing for Performance
5️⃣ SQL for Analytics

🎯 Perfect for quick revision before interviews or weekend practice!


#SQL #InterviewPrep #DataEngineering #SQLJunction
Average SQL vs Great SQL.pdf
169.7 KB
🚫 Most developers write SQL like this...
✅ But great developers write it like this.

Just shared a visual breakdown of common SQL mistakes — and how to fix them like a pro! ⚡

Perfect for anyone preparing for interviews or writing SQL daily.

📌 Upgrade your query game in 60 seconds.

#SQL #InterviewPrep #SQLTips #SQLJunction #SQLInterview
❤2
In this document, I have mentioned a page regarding the IN clause and where exists clause

This is a highly asked interview question, the difference between the two? Which is better for faster execution?
❤2
🚀 SQL Interview Trick You Must Know!
Just dropped a brand new video 🎥

👉 Problem: Forward fill NULL values with the last non-null value in a SQL table.
🧠 Covered: A smart use of FIRST_VALUE() and logic building that actually makes sense!

If you're preparing for SQL/Data Engineering interviews, this is the kind of trick that separates good from great 👏
Don’t miss this one!

📺 Watch now: https://youtu.be/sBcMQfyb4eU?si=xPgvTcMOdSvAudSx

#SQL #InterviewPrep #DataEngineering #SQLTricks
SQL Junction pinned «🚀 SQL Interview Trick You Must Know! Just dropped a brand new video 🎥 👉 Problem: Forward fill NULL values with the last non-null value in a SQL table. 🧠 Covered: A smart use of FIRST_VALUE() and logic building that actually makes sense! If you're preparing…»
Hey folks 👋

I just created a clean and simple SQL cheat sheet — perfect for quick revision before interviews or while working on projects.

It covers:
🔸 DDL / DML / DCL / TCL
🔸 All types of Joins
🔸 Common Window Functions
🔸 Aggregate functions



🖼️ Check out the full image in the post 👆
📌 Save it for your reference
📤 Share it with someone learning SQL

— Aditya | SQL Junction
#SQL #SQLCheatSheet #DataEngineering #LearningSQL #SQLJunction
❤2👍1
SQL Junction pinned «🧠 This complex SQL question from Google looked simple… until I actually started solving it. Let’s just say — a plain JOIN wasn’t enough. 😉 I used a mix of aggregates + window functions to crack it — and the approach might surprise you. 🎥 https://youtu.be/Qvudg…»
SQL Junction
Senior Data Engineer (Snowflake +DBT +Airflow).docx
#JobAlert #JobOpening
One of my friends in looking for Snowflake Dbt Airflow Data Engineer for Pune and Ahmedabad location
I have put the JD ,if you are looking to switch

Do reach out to me on linkedin
linkedin.com/in/adityabansal095

#DataEngineering #DataEngineerJob
#SQL #CareerOpportunity
SQL Junction
Senior Data Engineer (Databricks).docx
This is for Azure Databricks engineer.

Please let me know on linkedin , I can directly point you towards the hiring manager and skip the queue.
Both of these jobs are hybrid setup for Pune and Ahmedabad locations