Junior Systems Analyst

Cape Town, Western Cape, South Africa

Job Description

The junior analyst specializes in designing the processes and integration of these processes for extract, cleanse, transform, and load. Must have the ability to understand the overall requirements and integrate them into the design. This individual may have design skills in one particular area, such as designing the extract of data from the source system, or may be proficient in designing the load routine, or may have the skills to design all areas of data integration. In cases where a data integration tool is used, must be knowledgeable in these tools to match the design with the features the tool has to offer.

The junior analyst provides efficient design and construction of systems and subsystems to extract, condition, and load data from operational systems and other sources into a defined physical data model according to business and technical requirements. The job may also provide input to the database designer to optimize the data loading of the physical database.

This person is charged with all the design efforts that concern the extraction of data from the source systems and any data conditioning performed on the host. This is a very technical effort and is heavily involved in the project as soon as data mapping is complete and stays involved, but to a lesser degree, to the end of the project. This person could also be very useful in the planning phase of the project, contributing expertise to the evaluation of the best alternatives for data integration based on expected row counts, file sizes, and other source data parameters.
Job Requirements:
key areas of responsibility:

  • Interface with system stewards to gather requirements.
  • Define data element requirements, including history, timeliness, and frequency of data.
  • Define volume and timing requirements.
  • Design the data integration interface
  • Perform Data Mapping specifications

Skills required:
  • In depth knowledge of the Teradata Database.
  • In depth knowledge of ETL tools
  • Strong Telecommunications understanding and solid experience

Job Related Experience Required Time Span

ETL Design 5 years

Participation in at least 1 major data warehouse project 3-5 years

Telecommunications Industry experience 1-2 years

Teradata Data Warehousing 2 years

Informatica 1-2 years

AbInitio 1-2 years

Oracle Warehouse Builder 1-2 years

Beware of fraud agents! do not pay money to get a job

MNCJobs.co.za will not be responsible for any payment made to a third-party. All Terms of Use are applicable.

Related Jobs

Job Detail

  • Job Id
  • Industry
    Not mentioned
  • Total Positions
  • Job Type:
    Full Time
  • Salary:
    Not mentioned
  • Employment Status
  • Job Location
    Cape Town, Western Cape, South Africa
  • Education
    Not mentioned