Post
Interview Tips & Stories
3w
SQL and Python Interview Tips needed ASAP!
My SQL and Python technical round is in 3 days and I need a list of important topics to practice for Python. I have worked on NumPy and Pandas libraries at my current workplace. Need an exhaustive list of topics that you guys have been asked in DA/BA role interviews.
The interview is for a Big4 company.
Any help is much appreciated!
widemermaid
3w
A Senior Software Engineer
If it’s a Big 4 company, they might throw in scenario-based questions. Have you prepared for questions like ‘How would you optimize a slow SQL query?’ or ‘How do you handle missing data in Pandas?
gandalfthepurple
author
3w
works at
@widemermaid Not yet, no. Thanks for this suggestion though. I will prep for these questions now.
biryanienthu
3w
An Assistant Manager
Three days is enough if you stay focused! Prioritize SQL joins, window functions, and Pandas data wrangling. You’re already ahead since you have real-world experience!
all the best
intenseparrot
3w
An Assistant Manager
For SQL, don’t just practice queries also understand query optimization and indexing.
cerealkiller
3w
works at
You got this...Just focus on query optimization in SQL and debugging in Python. These always come up.
a sales executive
3w
Interviewers love scenario-based SQL questions. Brush up on data manipulation and analysis..
tiddey
3w
An Analyst
Data types, list comprehensions, and error handling in Python...kitna confident feel kar rahe ho in pe?
bugmaster
3w
works at
What’s your approach to tackling complex SQL queries? They love testing problem-solving skills
kyachahiye
3w
A Software Developer
For SQL: Joins, CTEs, Window Functions, Indexing, and Optimization. Python: OOPs, Lambda, Decorators, and Exception Handling...
dadiji
3w
works at
They might ask SQL query tuning & performance optimization. Check indexing & execution plans...
wineymoose
3w
An Operations Manager
Super important interview! Let’s make a checklist of SQL & Python must-know topics. Who’s in?
Posts you might like
Salary Discussions, Hike & Promotions
2w (edited)
Confused between 2 offers
Hi all, I am having two offers- one from Infy (Kolkata) another from Deloitte (Hyd). Kolkata being my preferred location, while Deloitte offering 15k more monthly. (I know Hyd's expense will cancel this out eventually).
Kindly suggest on what to do. ... read more
Career Growth
1w
Career suggestion
I have 7 YOE. from Delhi
Current CTC - 9.25LPA + 75K varriable.
Working Skillset is Kubernetes and Openstack.
Current - 100% WFH
1. NTT Data- Noida
Hybrid
CTC... read more
Career Advice
1w
a procurement specialist
Am I on right path?
Right after my BCom, I took a service advisor role at Honda for ₹7K due to urgency. Later, I moved to a gas station for ₹10K, handling all kinds of work beyond office tasks.
My breakthrough came when I joined as an orde... read more
Download AmbitionBox app
Anonymously discuss salaries, work culture, industry news and more ...
or
