Environment:

A dynamic asset management company is looking for a dynamic ETL developer who will be responsible for the scripts required to extract, transform, clean, and move data and metadata so they can be loaded into a data warehouse, data mart or operational data store.

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.
• Obtains 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 and/or development team.
• 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.

Requirements:

• Graduate student in accounting, investment management or computer science fields.
• At least three years of working experience with data in the financial services.
• Five+ years of MS SQL and MS SSIS experience.
• Five+ years of general programming experience.
• Experience in backend frameworks and technologies.
• Should have system knowledge and understandingon the following:
  • 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.
  • 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.

Advantageous –

• Strong mathematical/accounting background or subject knowledge.

While we would really like to respond to every application, should you not be contacted for this position within 10 working days please consider your application unsuccessful.

Comments:

When applying for jobs, ensure that you have the minimum job requirements. Only SA Citizens will be considered for this role. If you are not in the mentioned location of any of the jobs, please note your relocation plans in all applications for jobs and correspondence. Please e-mail a word copy of your CV to

moc.nifatad@nyrat

and mention the reference numbers of the jobs.

Posted on 15 Dec 14:49