For Avasoft SQL Data Engineer interview, the process you went through seems like this: MCQ Round – Screening round: Python Questions: Basics, maybe loops, functions, data structures like lists/dictionaries, maybe some small coding logic. SQL Questions: Queries, joins, group by, having, subqueries, aggregate functions, maybe window functions. Aptitude Questions: Numbers, percentages, ratios, simple logic, basic problem-solving. Group Discussion (GD): They usually give a basic topic (general awareness, tech trends, or scenario-based problem). They check communication skills, clarity of thoughts, teamwork, and confidence. Technical Interview (TI): Detailed questions on SQL (joins, subqueries, optimization). Python basics (data structures, simple scripts). Sometimes questions on data engineering concepts: ETL, data pipelines, databases, big data tools. HR Interview: Technical HR: Sometimes overlaps with technical questions but focuses more on your projects, role understanding, and problem-solving approach.