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.