Open Framework, Information Management Strategy & Collaborative Governance | Data & Social Methodology - MIKE2.0 Methodology
Wiki Home
Collapse Expand Close

Collapse Expand Close

To join, please contact us.

Improve MIKE 2.0
Collapse Expand Close
Need somewhere to start? How about the most wanted pages; or the pages we know need more work; or even the stub that somebody else has started, but hasn't been able to finish. Or create a ticket for any issues you have found.

ETL Design Lead

From MIKE2.0 Methodology

Jump to: navigation, search

The ETL design lead guides and mentors the ETL Developers and is responsible for documentation, quality and management of ETL processes.



Technical Accountabilities

  • Ensure high quality ETL development work via standards, guidelines, quality assurance reviews and testing.
  • Estimate the time and resource requirements of ETL development work.
  • Follow the progress of ETL development and how it meets estimate and actual timelines.
  • Raise critical technical issues to vendors or key stakeholders in a timely manner where they would impact on the project timeline.

Capability Development Responsibilities

  • Mentor, train and develop less experienced ETL Developers.
  • Define and deliver consistent ETL standards, methodologies, guidelines & techniques.
  • Ensure compliance to standards through code walkthroughs and metadata reports.



  • Expert knowledge of the ETL technology in use on the project.
  • Understands the range of options and best practices for common ETL design techniques such as change data capture, key generation and optimisation.
  • Significant experience with data quality, data profiling, metadata management and reporting.

Technology Skills

  • Expertise and experience in the ETL development tool.
  • Moderate knowledge of at least one database tool.
  • Keep up to date on the upgrade options, enhancements, add-ons and features in the ETL tool with a view to improving the productivity of the project.

Work Experience

  • 3+ years experience with ETL tools or ETL programming.
  • 5-10 years experience with IT projects and information development.
  • Experience with the ETL product being used.
Wiki Contributors
Collapse Expand Close