- SQL & Python (Basics) * Basic questions on SQL Joins, Unions, Filtering, String & Date functions, Aggregate functions. * Basic user defined functions, visualizations, pandas functions - SQL (Advanced) * Queries using window functions (Row Number, Rank, Dense Rank), sub-queries in SQL to check approach and logic to solve a problem - Python (Advanced) + ML * user defined functions * Asked to explain one of the projects listed on my resume, few basic ML questions * Exploratory data analysis questions - Apti & HR * questions on Number series and puzzles, basic statistical questions. * HR questions on background, personality check questions, why analytics, why dhiOmics.

Python, SQL, Machine Learning, Aptitude, projects