I have an upcoming interview with the team for SDE3 level. Though the title says SDE3, it is more towards BI, data analytics and ML and not core software development. Please let me know what to expect from the interviews, what level of SQL and coding is required.
A data engineer/analytics role has so many domains i could ask questions on. So these days, I stick to what you claim you know in your resume and peel the layers. For an analyst, I'll definitely dig deep in SQL though. All window functions, scd, and even a bit of query optimisation.
For BI and Data Analytics, you can expect questions related to business requirements and converting them to SQL problem statements and data pipelines. For ML, they will focus more on your variety of approaches on any business requirements. Although role seems to be like Data Scientist role or Data Engineer instead of common SWE.