JOB SEEKERS
EMPLOYERS
JOBS QUICK-SEARCH
.net
.net developer
a+
abap
account manager
accountant
admin
administrator
analyst
architect
bookkeeper
business analyst
business intelligence
c#
call centre
ccna
cisco
cloud
cobol
consultant
delphi
desktop
desktop support
developer
engineer
finance
graduate
graduates
helpdesk
internship
it manager
it support
it technician
java
java developer
junior developer
legal
linux
manager
marketing
mcse
network
network administrator
oracle
personal assistant
php
php developer
programmer
project
project administrator
project manager
receptionist
sales
sap
secretary
security
sql
support
technical support
technician
test analyst
tester
web developer
NEWSLETTER
FOLLOW US
ETL Developer MS SSIS (1401)
Job Ref
281176
Job Type
Permanent
Employer Type
Recruitment Agency
Date Added
8 Feb 2019
Expiry Date 25 Mar 2019
Expiry Date 25 Mar 2019
* There have been no applications to this job.
* This job has been viewed 944 times.
Employer:
TriTec Talent
Location:
South Africa
Salary:
Negotiable
Benefits:
Role details:
- - - - - - - - - - - - - -
Role DescriptionETL 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