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 Developers

From MIKE2.0 Methodology

Share/Save/Bookmark
Jump to: navigation, search

The ETL Developers design, build and test the jobs or code that moves, transforms and loads data.

Contents

Responsibilities

Technical Accountabilities

  • Ensure the ETL code delivered is running, conforms to specifications and design guidelines.
  • Developing to estimated timelines or updating management on deviations to these estimates.
  • Unit testing ETL code to ensure it can be delivered and run in a system testing environment.
  • Raise critical technical issues to the ETL Design Lead that may impact on the timeline.
  • Participation and contribution in quality assurance walk throughs of ETL components.
  • Answer all the queries of Business Analyst related to Data linege.
  • Carry out Impact Analysis for changes proposed by Business team.

Capabilities

Knowledge

  • Knowledge of the ETL technology in use on the project.
  • Understand ETL basic concepts of data flow, data enrichment, data consolidation, change data capture and transformation.
  • Understand database concepts of referential integrity, indexes and keys and table metadata.

Technology Skills

  • Moderate expertise and experience in the ETL development tool or ability to learn from a mentor on the project.
  • Ability to navigate on the host server for file management, file cleanup and configuration tasks.
  • Ability to query source and target databases for unit testing.
  • Proficient with a database SQL language for user-defined database extract or update statements.

Work Experience

  • Exposure to a programming language in order to code transformations.
  • Exposure to a database and experience with database objects.
  • Experience with ETL tools or data migration or data integration.
Wiki Contributors
Collapse Expand Close