Data Engineering Intern

📋 Description

• Learn how our OLTP source systems feed the OLAP lakehouse. Read table schemas, including column
• Write and modify SQL queries and simple Spark/SQL transformations under guidance, and validate the
• Add basic row-count and null checks, along with meaningful logging, to the pipeline tasks you own.
• Participate in the pipeline on-call rotation alongside an experienced engineer. Identify failed
• Apply partition filters instead of full table scans, and understand that storage grows with data
• Collaborate with product analysts as a peer by fixing queries, directing them to the right datasets

🎯 Requirements

• Final-year student or recent graduate in Computer Science, Information Technology or a related
• Clear understanding of OLTP vs OLAP systems and their respective use cases.
• Ability to write correct, readable SQL, including joins, aggregations, filters and basic window
• Working knowledge of Python; familiarity with Scala or Java is a plus.
• Ability to read a table schema and explain the data it represents.
• Basic understanding of how LLM / GPT models work, including tokens, context windows, prompting and