ETL Developer

ETL Developer

Job Title: ETL Developer
Location: Western Cape
Salary: 0.00
Reference: JN -102015-4522
Job Published: January 06, 2017 10:23

Job Description

Position:                                  ETL Developer
Duration:                                 Permanent
Location:                                 Cape Town
Business Unit:                         Information Services
Please note that preference will be given to candidates from designated groups.
Job Description:
looking for a dynamic MS SSIS 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.
The successful candidate will report directly to one of the Team Leaders.
Main duties and responsibilities:Primarily required to:
  • 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
Ideal experience:
  • At least 3 years working experience with data in the financial services
  • 5+ years MS SQL & MS SSIS experience
  • 5+ years general programming experience
  • Experience in backend frameworks and technologies.
Ideal qualifications:Graduate student in Accounting, Investment Management or Computer Science fields (with strong Mathematical/Accounting background or subject knowledge an advantage).

Competencies and ideal personality attributes:

  • Strong conceptual, communications, and technical skills
  • Ability to translate business needs into technical solutions
  • Strong relational and dimensional data modeling and database design skills
  • Technical design
  • Knowledge of data warehousing architectural approaches
  • Conceptual and analytical skills
Software, 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
Most important attribute:Ability to work under pressure, time management and to be able to multi-task multiple projects.

Get similar jobs like these by email

By submitting your details you agree to our T&C's