I had applied for the Jr Data Engineer role. First round was a Hackerank Assessment. I was given 1 hour to solve 3 SQL problems. Two of them were fairly simple, while the last one was a bit challenging. I solved all of them.

1. Application Screening What happens: Your resume is reviewed by recruiters or automated systems (ATS). Tip: Tailor your resume with keywords from the job description. 📌 2. Online Assessment / Aptitude Round Format: MCQs or coding questions (via platforms like HackerRank, Codility, etc.). Topics: SQL queries Python logic (data structures, file handling) Basic data modeling Logical reasoning / aptitude 📌 3. Technical Interview (1–2 Rounds) Focus: Core SQL and Python Data pipeline concepts Database design (e.g., normalization, indexing) ETL/ELT concepts Cloud basics (GCP, AWS optional for freshers) Example Question: "Design a simple data pipeline to clean and store sales data." 📌 4. System Design (Optional for Freshers) If included: Simplified scenario-based question like designing a mini data warehouse or streaming pipeline. Expected: Logical thinking, table design, SCD types, data flow discussion. 📌 5. HR/Behavioral Interview Topics: Tell me about yourself. Why data engineering? Teamwork, problem-solving, and learning experiences. Tip: Use the STAR method (Situation, Task, Action, Result) for structured answers. 📌 6. Final Round / Managerial Discussion (Optional) Discussion: Work attitude, career goals, and potential growth. Could include: Light technical questions + project or internship discussion.