Data Engineer Associate

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