Ultimate access to all questions.
You are working on a data pipeline that processes data from a human resources department. The data includes employee records with information about employee details and job positions. You have been tasked with ensuring the data quality of the employee records dataset. Describe the steps you would take to run data quality checks on the employee records dataset and explain how you would define data quality rules to identify and resolve data inconsistencies related to employee job positions.