Analyst Developer
Bytes System Integration
Cape Town Central, South Africa
2d ago

Job Description :

The ETL Analyst Developer contributes and provides consulting in the design and development of the ETL environment, processes, programs, and scripts to acquire data from source systems and apply the data to the tables in the database.

This individual must have the skills necessary to understand the overall database and toolset architecture. The ETL Analyst Developer builds the ETL environment with the specific toolset required by the client.

The ETL Analyst Developer may also provide input to the database designer to optimize the data loading of the physical database.

Job Requirements : Areas of responsibility

Areas of responsibility

  • Capture ETL Requirements.
  • Design, develop, and test processes for extracting data from legacy systems or production databases.
  • Design, develop, and test processes for validating and conditioning data prior to loading into a data warehouse.
  • Design, develop, and test processes for loading initial and cyclical data into a data warehouse.
  • Design the processes to meet service level agreements for data timeliness and frequency.
  • Determine which data elements are historic and the retention period for historic data.
  • Determine data growth trends and peak business periods.
  • Skills required :

  • Knowledge of Teradata Database.
  • Knowledge of ODI as an ETL tool.
  • Primary Skill

    Software Development Skills

    Primary Skill

    Teradata Active Data Warehousing Knowledge

    Primary Skill

    Tools Enterprise Application Integration

    Secondary Skill

    Tools Job Control and Scheduling

    Knowledge

    Tools Operating Systems / Networking

    Knowledge

    Job Related Experience Required

    Essential / Desirable

    ETL Design and development

    Essential

    Apply
    Add to favorites
    Remove from favorites
    Apply
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Continue
    Application form