I applied online. The process took 2 months. I interviewed at Prevail Partners (London, England) in Jan 2025
Interview
The interview process consisted of three stages. The first stage was an initial screening with HR, where we discussed my background, career aspirations, and suitability for the role.
The second stage was a Microsoft Teams call with a data engineer and a director. This interview focused on assessing my technical capabilities, exploring my experience in depth, and understanding what I know and areas where I have room to grow. It was also an opportunity for me to learn more about the company, the role, and the learning opportunities it would provide.
The final stage was an in-person scenario demonstration and panel interview. During this stage, I presented my solution to the given scenario, followed by a discussion where they asked me to elaborate on my experience, knowledge, and CV. This final stage allowed for a deeper dive into my qualifications and how they aligned with the role.
Interview questions [1]
Question 1
The task involved designing an end-to-end data pipeline architecture based on a given scenario. I was provided with a detailed sheet outlining the scenario and was required to create the solution entirely on paper. The focus was on addressing critical data engineering principles, including scalability, security, data quality, handling duplicate columns, schema design, staging databases, efficiency, fault tolerance, monitoring, automation, data versioning, compliance with regulatory standards, and robust data governance. Additionally, I had to account for edge cases such as schema evolution, managing high data velocity and volume spikes, and minimising downtime to ensure seamless operations. The final step involved presenting the architecture to a panel, answering their follow-up questions, and justifying my design decisions to demonstrate how the proposed solution met the outlined requirements and addressed potential challenges.