Senior ETL Developer – Salary: Market Related

HR Administrator – Salary: R13 000
June 12, 2015
Claim Specialist
June 18, 2015

GL/S.ETL.D

Senior ETL Developer with at least 6+ years experience is required for a large company based in Cape Town.

 

Requirements:

  • At least 6 years working experience with data in the financial services
  • 10+ years SQL & ETL Tooling experience
  • 5+ years general programming experience
  • Experience in web as well as backend frameworks and technologies.
  • Graduate student in Accounting, Investment Management or Computer Science fields (with strong Mathematical/Accounting background or subject knowledge an advantage).

Systems Knowledge:

  • Understanding of source and target data structures, ETL processes, and products
    • Knowledge of 3GL/4GL programming languages and ETL products
    • Understanding of Modern Data Warehouse architecture
    • Understanding of Modern Data Warehouse ELT/ETL development methods
    • Application of proven methods data processing performance optimisation
    • Application of proven Near Realtime ETL processing methods
    • Understanding of Realtime/Streaming Data Integration methods
    • Application of proven methods to ensure high levels of fault tolerance and recoverability
    • Understanding of the broader ecosystem of methods and tooling to ensure optimal ETL design
    • Strong problem-solving and metadata skills
    • Knowledge of Portfolio and Trade Management Systems a distinct advantage, and in particular InvestOne, Decalog and Bloomberg AIM.
    • Understanding of capabilities of vendor infrastructure products, including SMP (symmetric multiprocessing) and MPP (massively parallel processing) systems
    • Knowledge of Industry Reference Data Models for the Financial Services Industry

 

Duties:

 

• Work with business requirements analysts to identify and understand source data systems
• Map source system data to data warehouse models
• Develop and test extraction, transformation, and load (ETL) processes
• Performance profile ETL processes
• Exception and Error handling contingencies and data hospitalisation procedures
• Management of system impact changes through appropriate assessments and design authorities
• Act as peer design authority for ETL processes
• Define and capture metadata and rules associated with ETL processes
• Adapt ETL processes to accommodate changes in source systems and new business user requirements
• Ensure adherence to Data Architecture Standards and Best Practices
• Ensure compliance with Data Management policies and procedures
• Interviews business users to obtain data requirements for new analytic applications
• Designs conceptual and logical models for the data warehouse or data mart
• Communicates physical database designs to database administrator
• Evolves models to meet new and changing business requirements
• Develops process for capturing and maintaining metadata from all data warehousing components
• Assesses current technical architecture
• Estimates system capacity to meet near- and long-term processing requirements
• Writes specifications for client machines, application servers, database servers, and networks

May be required to:
• Interviews business users to obtain data requirements for new analytic applications
• Designs conceptual and logical models for the data warehouse or data mart
• Communicates physical database designs to database administrator
• Evolves models to meet new and changing business requirements
• Develops process for capturing and maintaining metadata from all data warehousing components
• Assesses current technical architecture
• Estimates system capacity to meet near- and long-term processing requirements
• Writes specifications for client machines, application servers, database servers, and networks

 

 

 

 

 

Upload your CV/resume or any other relevant file. Max. file size: 2 MB.