target logo
Target· Data Engineer

Target Data Engineer

Result
Offer
Location
null
Posted
17 Aug 2025
317 reads

Summary

I recently went through the interview process for a Data Engineer role at Target. The interview focused on SQL queries and Python programming, with an emphasis on data handling and project-related scenarios. The interview had two rounds, with the first round consisting of technical coding and project-related questions, and the second round focusing on Spark and Hadoop.

How it went

Round 1 was a technical coding and project-related round. I was given several SQL queries to solve, including counting active projects, calculating the average number of days to complete a project, finding employees not part of any active project, and identifying employees with the maximum salary within each project. I also had to write a Python function to find the longest common prefix among an array of strings. The SQL queries required a good understanding of joins, subqueries, and aggregate functions. The Python question tested my knowledge of string manipulation and loops.

Round 2 focused more on project-related topics and technologies specific to Target's internal Hadoop platform. The questions were about migration, real-time scenarios, data handling, and data transformations. This round was more about understanding how data flows within the system and how to handle various data processing challenges. It required a solid grasp of big data technologies and practical experience with data pipelines.

Questions asked (5)

  1. 01

    Count of Active Projects

    Data Structures & Algorithms · Medium

    Write a SQL query to count the number of active projects. An active project is defined as one with a status of 'IN_PROGRESS'.

  2. 02

    Average Days to Complete a Project

    Data Structures & Algorithms · Medium

    Write a SQL query to calculate the average number of days it takes to complete a project. Only consider projects with a status of 'COMPLETED'.

  3. 03

    Employees Not Part of Any Active Project

    Data Structures & Algorithms · Medium

    Write a SQL query to list all employee IDs who are not part of any active project.

  4. 04

    Employees with Maximum Salary in Each Project

    Data Structures & Algorithms · Hard

    Write a SQL query to list, for each project, the employees who have the maximum salary within that project, along with their maximum salary.

  5. 05

    Longest Common Prefix

    Data Structures & Algorithms · Medium

    Write a Python function to find the longest common prefix among an array of strings.

How they prepared

For the interview, I focused on strengthening my SQL skills, particularly with joins, subqueries, and aggregate functions. I practiced writing efficient queries for common data analysis tasks. For the Python question, I reviewed string manipulation techniques and loop structures. Additionally, I studied big data technologies like Spark and Hadoop, as the second round involved migration and data processing scenarios. I made sure to understand how data flows through systems and how to handle real-time data transformations.

Know someone preparing? Send it to them:WhatsAppLinkedInX

Interviewed at Target recently?

Write up your rounds while you still remember the questions. It helps the next person more than you would think.

Share your experience
Discussion 0

Questions for the author, or how your own interview compared.

Join the discussion

Sign in with Google to comment or ask the author a question.

No comments yet

Be the first to share your thoughts and start the discussion!