• Login Name       Password       Remember me       LOGIN LOGIN    FORGOT PASSWORD
  • REGISTER

 LOGIN WITH
 
 
 
 
 EMPLOYERS
 
 
 
 
 
 NEWSLETTER
 
 
 
 
 FOLLOW US

ETL Developer MS SSIS (1401)

Job Ref
281356
Job Type
Permanent
Employer Type
Recruitment Agency
Date Added 15 Mar 2019
Expiry Date 29 Apr 2019
* There has been 1 application to this job.
* This job has been viewed 890 times.
Employer:
TriTec Talent

Location:
South Africa

Salary:
Negotiable

Benefits:


Role details:
ETL Developer MS SSIS (12 monthfull time contract, likely permanent conversion) Cape Town Monthly Salary, leave inclusive   Afinancial services (Investment) company is looking for a dynamic MS SSIS ETL Developer who will beresponsible for the scripts required to extract, transform, clean, and move data and metadata sothey can be loaded into a data warehouse, data mart, or operational data store. The successfulcandidate will report directly to the ETL Team Leader. The role forms part of a professional wellrespected company.  The right person for this role will be both technically astute and have theability to engage well with colleagues in the company. We are specifically looking for aprofessional with exceptional skills in Microsoft Technologies, prior experience in a role withsimilar duties will be required.  It is essential that this person can hit the ground running onstart. Duties & Responsibilities Work with business requirements analysts to identify andunderstand source data systems Map source system data to data warehouse models Develop and testextraction, transformation, and load (ETL) processes Performance profile ETL processes Exception andError handling contingencies and data hospitalisation procedures Management of system impact changesthrough appropriate assessments and design authorities Act as peer design authority for ETLprocesses Define and capture metadata and rules associated with ETL processes Adapt ETL processes toaccommodate changes in source systems and new business user requirements Ensure adherence to DataArchitecture Standards and Best Practices Ensure compliance with Data Management policies andprocedures Obtains data requirements for new analytic applications Designs conceptual and logicalmodels for the data warehouse or data mart Communicates physical database designs to databaseadministrator and/or development team Evolves models to meet new and changing business requirementsDevelops process for capturing and maintaining metadata from all data warehousing componentsAssesses current technical architecture Estimates system capacity to meet near- and long-termprocessing requirements
- - - - - - - - - - - - - -
Role Description
ETL Developer MS SSIS (12 month full time contract, likely permanent conversion) Cape Town MonthlySalary, leave inclusive   A financial services (Investment) company is looking for a dynamic MSSSIS 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 operationaldata store. The successful candidate will report directly to the ETL Team Leader. The role formspart of a professional well respected company.  The right person for this role will be bothtechnically astute and have the ability to engage well with colleagues in the company. We arespecifically looking for a professional with exceptional skills in Microsoft Technologies, priorexperience in a role with similar duties will be required.  It is essential that this person canhit the ground running on start. Duties & Responsibilities Work with business requirements analyststo identify and understand source data systems Map source system data to data warehouse modelsDevelop and test extraction, transformation, and load (ETL) processes Performance profile ETLprocesses Exception and Error handling contingencies and data hospitalisation procedures Managementof system impact changes through appropriate assessments and design authorities Act as peer designauthority for ETL processes Define and capture metadata and rules associated with ETL processesAdapt ETL processes to accommodate changes in source systems and new business user requirementsEnsure adherence to Data Architecture Standards and Best Practices Ensure compliance with DataManagement policies and procedures Obtains data requirements for new analytic applications Designsconceptual and logical models for the data warehouse or data mart Communicates physical databasedesigns to database administrator and/or development team Evolves models to meet new and changingbusiness requirements Develops process for capturing and maintaining metadata from all datawarehousing components Assesses current technical architecture Estimates system capacity to meetnear- and long-term processing requirements

Skills and Experience
Ideal Experience At least 3 years working experience with data in the financial services 5+ yearsMS SQL & MS SSIS experience 5+ years general programming experience Experience in backend frameworksand technologies. Competencies & Personality Attributes  Strong conceptual, communications, andtechnical skills Ability to translate business needs into technical solutions Strong relational anddimensional data modeling and database design skills Technical design Knowledge of data warehousingarchitectural approaches Conceptual and analytical skills Most Important Attribute Ability to workunder pressure, time management and to be able to multi-task multiple projects.   Systems Knowledge Understanding of source and target data structures, ETL processes, and products Knowledge of3GL/4GL programming languages and ETL products Understanding of Modern Data Warehouse architectureUnderstanding of Modern Data Warehouse ELT/ETL development methods Application of proven methodsdata processing performance optimisation Application of proven Near Realtime ETL processing methodsUnderstanding of Realtime/Streaming Data Integration methods Application of proven methods to ensurehigh levels of fault tolerance and recoverability Understanding of the broader ecosystem of methodsand tooling to ensure optimal ETL design Strong problem-solving and metadata skills  



APPLY  
 



 
HOME|
INFO|