Data Engineer Associate

DataCamp's Data Engineer Associate Certification is awarded to individuals who successfully complete two timed exams (DE101 & DE102) and one practical exam.

What to expect on the timed exams

DE101 is a 60-minute exam that assesses your proficiency in data management theory, data management in SQL, and exploratory analysis theory. To successfully pass this exam, you should be able to:

  • Interpret a database schema and explain database design concepts (such as normalization, design, schemas, data storage options)
  • Identify different cloud tools that can be used for storing data and creating and maintaining data pipelines
  • Perform data extraction, joining and aggregation tasks
  • Perform cleaning tasks to prepare data for analysis
  • Assess data quality and perform validation tasks
  • Use data visualization tools to demonstrate characteristics of data
  • Read and analyze data visualizations to represent the relationships between features
 

DE102 is a 60-minute exam that assesses your proficiency in data management in Python, and Programming for Data Engineering in Python. To successfully pass this exam, you should be able to:

  • Perform standard data import, joining and aggregation tasks
  • Perform cleaning tasks to prepare data for analysis
  • Assess data quality and perform validation tasks
  • Collect data from non-standard formats (e.g. json) by modifying existing code
  • Use common programming constructs to write repeatable production quality code for analysis
  • Demonstrates best practices in production code including version control, testing and package development
  • Use software engineering principles (OOP, profiling, debugging) to write efficient, modular code in python

 

What to expect on the practical exam

The final step in this certification is a practical exam. The practical exam assesses your skills in data management SQL. You'll complete tasks related to a business problem and be expected to return data to meet the given requirements.

To pass the practical exam, you'll need to be able to:

  • Perform data extraction, joining and aggregation tasks
  • Perform cleaning tasks to prepare data for analysis
  • Assess data quality and perform validation tasks

If you have questions or feedback related to certification, please submit your inquiry here.