SQL/SSIS ETL Developers

Location: Johannesburg, South Africa
Salary: Market Related
Recruiter: PBT Group
Job Ref: YSN0001
Summary: Microsoft SQL/SSIS ETL Developers required to implement the ETL in Microsoft SQL from landing through the DW and then publish the datasets in SQL views for each required report.

 

 

Job Description

With over two decades of expert knowledge and experience as information management specialists, PBT is a recognised leader in Business Intelligence and data warehousing and has extended its competency base to cover data quality and advanced analytics.

 

We pride ourselves to be a company who attracts, recruits and retains consultants of an exceptional calibre, not only within BI, but also within focused areas of Application Development.

 

We have worked in more than 25 countries around the world and are currently implementing large-scale projects throughout Africa, the Middle East and Australia.

 

PBT Group, leaders in Business Intelligence, requires Microsoft SQL/SSIS ETL Developers to implement the ETL in Microsoft SQL from landing through the DW and then publish the datasets in SQL views for each required report. The source data will be provided and pushed by the source system teams.

 

 

Required Skills:

- Solid SSIS (SQL Server Integration Services) experience.

- Intimate knowledge of source systems as well as a basic understanding of dimensional models.

- Conventional database- and data warehouse modelling skills, in order to understand the data warehouse data models.

- A sound knowledge of the programming language used to write the data staging programs or ETL tool.

- A sound knowledge of SQL, or the language used to access the source databases and the data warehouse from the data staging programs or ETL tool.

- A sound knowledge of the capabilities of the ETL tools, to know what their capabilities and shortcomings are – in order to exploit or avoid those aspects in the data staging programs.

- Pride of work, thoroughness and attention to detail.

 

 

Required Qualifications / Training:

- Course on the ETL / related toolset.

- Relevant data warehouse and BI solution training is essential.

- B.Sc. or related degree is advantageous.

- 2+ years programming experience.

 

 

Duties:

- Plan and analyse complex business requirements and implement technology enabled solutions to address multi-discipline business opportunities/problems.

- Conduct planning, analysis and design activities in conjunction with other development specialists.

- Participate in analysis of complex business opportunities/problems to deliver designs meeting requirements.

- Participate in estimation of tasks and assist in the development of project plans.

- Code or makes modifications to programs of high complexity, according to specifications.

- Conduct medium to high complexity evaluations for product releases, stand-alone products, etc.

- Conduct walkthroughs and quality review of deliverables.

- Knowledge of design and developing end-to-end data acquisition processes to be used in population of data warehouse/data marts and/or in the creation of interfaces.

- Provide guidance and mentoring on business intelligence technology and systems in general, especially in the area of ETL processes.

- Participate in the formulation of standards to support the data acquisition development process.

- Design, develop and execute complex data acquisition or interface routines using ETL tool, ensuring that business and technical requirements are met.

- Ensure compliance with established policies, standards and methodologies.

 

 

This job is now closed. You can apply for other jobs by uploading your CV.

New users - Upload your CV                      Existing users - Login here

 

Similar jobs your might be interested in:

Software Developer / DevOps– C# / Azure – Sandhurst – neg. to R700k P/A
Johannesburg
C#. Azure. Micro services. Rest. Web Api. SQL Server. Midlevel Developer. DevOps. Influence more Junior developers.
1 day ago


Senior Developer: Integration
Centurion
Senior Developer: Integration - Perm - R780 - Centurion 5-8 years experience of MS Operating Systems, MS Office Applications, Database Management and networking protocols Microsoft Office SharePoint Server/ Visual Studio .NET 2005 - 2008 Microsoft O...
1 day ago


Java Developer, Intermediate, Sandton, 700k per annum
Johannesburg
A sought-after company is seeking a senior Java Developer to join elite team of developers doing groundbreaking and exciting work, you will be working with an industry of IT specialists who are motivated and driven to develop to their best ability, t...
2 days ago


Java Developer, Senior, Sandton, R900k per annum
Johannesburg
A leading South African company that promotes work – life balance, requires a senior Java developer to join their seasoned group of developers. They strive on prioritizing employee wellbeing and aim to create a working environment that is benefici...
2 days ago


Java Developer, Senior, Sandton, R900k per annum
Johannesburg
A leading South African company that promotes work – life balance, requires a senior Java developer to join their seasoned group of developers. They strive on prioritizing employee wellbeing and aim to create a working environment that is benefici...
2 days ago


Java Developer
Centurion
We are looking for solid intermediate all the way to Senior Java developers with experience in building high-performing, scalable software applications. You will form part of a talented software team that works on mission-critical projects in dynami...
3 days ago


Senior .Net Developer
Centurion
We are looking for Senior .Net developers to build software using languages and technologies of the .NET framework. You will create applications from ground up, configure existing systems and provide user support when required.
3 days ago


Android Developer, Johannesburg Auckland Park, 750k per annum
Johannesburg
A Leading African publishing brand that services the online media consumer via mobile apps and the internet, is in search of Mobile developers!
3 days ago


Android Developer, Johannesburg, 650k per annum
Johannesburg
A Leading African publishing brand that services the online media consumer via mobile apps and the internet, is in search of Mobile developers! Do love coffee, coding, the sea and great people? Well this is what is on offer! If this sounds like your...
3 days ago


Android Developer, Johannesburg Auckland Park, 780k per annum
Johannesburg
A Leading African publishing brand that services the online media consumer via mobile apps and the internet, is in search of Mobile developers!
3 days ago


 

Create a free job alert for                                

SQL/SSIS ETL Developers in Johannesburg

Enter your email address below
and we will email you similar jobs when they become available:

You can cancel at any time. We will not spam you. By giving us your email address your agree to our Terms and Conditions