Integrate Workforce Data with HR System | Dataford Interview Questions

Welcome to the SQL screen.

The question is on your right: Integrate Workforce Data with HR System. Read through the requirements and the two tables first.

Run and submit your code as often as you need. You also have five interviewer messages this session - want to talk through your approach, or are you ready to start coding?

Problem

A company is integrating a new workforce planning platform with its existing HR system. Write a SQL query to ensure data accuracy by identifying discrepancies in employee records between the two systems.

Requirements

Join the employees table from the HR system with the workforce_planning table using employee_id.
Identify employees that exist in the HR system but are missing from the workforce planning platform.
Include a flag to indicate if the employee is active in the HR system.
Return only those employees with discrepancies in their records.

Schema

employees

Column	Type	Description
employee_idPK	INT	Unique identifier for each employee
name	VARCHAR(255)	Employee's name
active	BOOLEAN	Indicates if the employee is currently active
department	VARCHAR(255)	Department where the employee works

workforce_planning

Column	Type	Description
employee_idPK	INT	Unique identifier for each employee in workforce planning
name	VARCHAR(255)	Employee's name as recorded in workforce planning
position	VARCHAR(255)	Position of the employee in workforce planning