I was contacted by a recruiter and he scheduled a 30 minute phone discussion which explained the interview process and towards the end he asked 4 questions from SQL and 4 from python . And then he sent a bunch of study materials which mostly had links to some online courses. Also he gave me time to study and practice and then suggest a date for the next coding interview. All those links are very helpful , so dont neglect anything. Also I practiced SQL and python coding in hackerrank, leetcode and interview cake. After 1 month I had my coding interview(Coderpad and talk over the phone) . It was 25 minutes SQL and 25 minutes python. I am a SQL person but I struggled a bit at the end. I answered 4 out of 5 SQL questions. looks like, based on our ability they move on to harder levels which is a good sign. And then on python I was able to complete only 2 out of 3. We need to pass all corner test cases as well for which my interviewer helped me with hints. It was overall a bit tough interview with the stringent timeline. However I got the email from my recruiter after 4 hours saying that I have been selected for Onsite interview. Again I had a 45 minute call with the recruiter and he gave a bunch of study materials. I went through all those and scheduled my onsite interview after a month. As others mentioned it was end to end test cases and it was interesting and challenging. It was mostly SQL and then a little data modeling, visualization and python coding (just 1 pgm). They give a scenario or issue and ask us to brain storm the issue and figure out the root cause which should match their expectation. once it matches they will write a transaction table data (like a log file data) and then ask us to write a bunch of SQL queries. Behavioral interview was around 12 questions. all related to how you handle situations at work. lunch interview was just a chat. be prepared to ask a few questions during that. Overall, I did well. However after 3 days my recruiter called me and told that I was not selected because they expected more perfection in SQL whereas my product knowledge and data modeling was good. Just one thing. Don't panic about 5 hour interview. Time just flies once you are inside your interview room. Also food was good and people were nice. It was a very good experience. I have been given an option to try in 6 months. Maybe I will take that opportunity. Advise to others - Practice SQL for onsite interview. Avoid sub queries and try to do it in single query wherever possible.

Begins with an application review and recruiter screening, followed by a technical phone interview that assesses SQL, data modeling, data warehousing, ETL processes, and coding skills in languages such as Python or Java. Successful candidates then proceed to onsite or virtual interviews, which include multiple rounds covering coding, system design, data architecture, problem solving, and behavioral questions.