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

Members
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

Share/Save/Bookmark
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.

Contents

Responsibilities

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.

Capabilities

Knowledge

  • 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