Oops! It appears that you have disabled your Javascript. In order for you to see this page as it is meant to appear, we ask that you please re-enable your Javascript!

Developer – ETL 44 views

Parvana - Cape Town, Western Cape - About the Client: Our client is a professional services company; specialising in advisory and consulting services in South Africa (currently Cape Town and Johannesburg only). Advisory Services: They assist their customers with their Sales and Marketing strategy and function on how to improve their visibility, building their brand and creating a Marketing plan that supports their Business and Commercial Strategy of the Company. Consulting Services: They assist their customers by deploying skilled and experienced professional contractors at their premises for periods ranging from 6 to 24 months. Role: Our client is 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. Duties & Responsibilities: Working with business requirements analysts to identify and understand source data systems. Mapping source system data to data warehouse models. Developing and testing 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. Defining and capturing metadata and rules associated with ETL processes. Adapt ETL processes to accommodate changes in source systems and new business user requirements. Ensuring adherence to Data Architecture Standards and Best Practices. Ensuring compliance with Data Management policies and procedures. Obtaining data requirements for new analytic applications. Designing conceptual and logical models for the data warehouse or data mart. Communicating physical database designs to database administrator and/or development team. Evolving models to meet new and changing business requirements. Developing process for capturing and maintaining metadata from all data warehousing components. Assessing current technical architecture. Estimating system capacity to meet near- and long-term processing requirements. Skills and Experience: Graduate student in Accounting, Investment Management or Computer Science fields (with strong Mathematical/Accounting background or subject knowledge an advantage). 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. 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 optimization. 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.... - Permanent - Full-time

To view original post and apply:


Apply for this job

New Job Search