Member-only story

ETL : Definition-of-Done (DoD) vs Definition-of-Ready (DoR)

Data Saint Consulting Inc
3 min readDec 23, 2023

--

Photo by Afif Ramdhasuma on Unsplash

As an ETL developer, I believe that planning for the Definition of Done (DoD) and the Definition of Ready (DoR) is crucial for ensuring the success of an ETL pipeline project. Here are some steps that I would follow to plan for DoD and DoR for an ETL pipeline project:

Understand the requirements

The first step is to understand the requirements of the ETL pipeline project. This includes understanding the data sources, the target system, the transformation rules, and the expected output.

Define the DoD

Based on the requirements, I would work with the project team to define the DoD for the ETL pipeline project. The DoD should be a shared understanding among the team members of when a product increment is ready for release. It should define the criteria that a product increment must meet for the team to consider it complete and ready for customers. Some examples of what could be included in a DoD are:

  • All code has been thoroughly tested via unit, integration, and end-to-end tests.
  • Product increment has been deployed to a staging environment and tested by the team.
  • All errors have been resolved.
  • All release documentation has been written and edited ¹.

Define the DoR

Once the DoD is defined, I would work with the project team to define the DoR for the ETL pipeline project. The DoR should outline the criteria for a product backlog item to even be considered by the team for bringing into their sprint. It should help the team identify when a product backlog item is ready to work on. Although the Scrum Guide does not mention a definition of ready, some teams find it to be a valuable tool for managing their work. Some examples of what might be included in a DoR are:

  • The PBI is written in a clear, concise way.
  • Related acceptance criteria have been defined and are testable.
  • Any dependencies have been identified and addressed.
  • All necessary stakeholders have approved the PBI ¹².

Communicate the DoD and DoR

--

--

Data Saint Consulting Inc
Data Saint Consulting Inc

Written by Data Saint Consulting Inc

For Consultation services regarding Data Engineering and Analytics: datasaintconsulting@ gmail.com

No responses yet

Write a response