The interview process consisted of multiple rounds including an initial screening, a technical interview, and an HR discussion. The technical round focused on SQL queries, data transformation concepts, and basic data engineering fundamentals such as ETL processes, data pipelines, and optimization techniques. Some scenario-based questions were also asked to assess problem-solving skills. The interviewers were professional and the process was well-structured. Overall, it was a good experience with a moderate level of difficulty.