Written test: Section 1 - Data interpretation Section 2 - logical questions Section 3 - web technologies / networking Section 4 - sql + queries Section 5 - root cause analysis Interview 1: Section 1: Introduction based on resume Questions based on what I did in the internship and uspe follow up questions Major emphasis and questions asked was about the major project. Section 2: 4-5 logical questions asked Section 3: Web technologies questions Difference between https and http How does https ka secure layer work What is cookie and why it's used What is proxy Dns ka role and process of work Section 4: Sql When to use where and having clause When to use group by Types of joins and their use case Have to write down the queries for the questions asked Section 5: Analysis question for me was You uber auto to go to your college from home, what are the parameters used to decide the pricing of the ride. Interview 2: Again resume and major project based 2-3 Logical questions Sql queries likhne bole yaha bhi Again analysis based question Basically dono interview same cheez puchte hai bas level of second interview is more than first interview. And dono interview me what does media.net do pucha tha.