SQL Warehouse Developer

Recruiter:

ARCS

Job Ref:

PTA000342/BB

Date posted:

Saturday, September 10, 2022

Location:

Centurion, South Africa

JOB SUMMARY:
Exciting, stable contract position available at one of our top Financial /IT clients (hybrid work): Develop, maintain and support a portfolio of software applications and services to ensure improved business efficiencies and that are aligned to the enterprise architecture and business strategy.

JOB DESCRIPTION:

Collaborate with testing team to co-create test cases.
Conduct System Integration Testing (SIT) and User Acceptance Testing (UAT) and resolve all issues/queries.
Contribute to user acceptance testing (UAT) and training material.
Once the solution has been successfully tested, transport the solution into production/live environment.
Provide authoritative, expertise and advice to clients and stakeholders.
Build and maintain relationships with clients and internal and external stakeholders.

Methodologies:

Have a clear understanding of Agile methodologies.
Be familiar with Waterfall methodology.
Be able to demonstrate hybrid integration of both Agile and Waterfall when required.
Have the ability to elicit data requirements from stakeholders.
Have clear documentation and communication skills.
Have solid understanding of Metadata, Master Data Management (MDM) and Data Architecture.
Be familiar with n-tier layered architecture (3-5 years).
Should have data modelling skills and should be able to interpret conceptual, logical and physical data models. (3 – 5 years).
Should be able to translate business requirements into technical designs with appropriate data modelling.
Should have proven data modelling techniques including normalization skills.
Must be familiar with data warehousing principles, based on the Kimball and/or Inmon architectures.
Should have knowledge of cloud warehousing components such as Snowflake would be to their advantage.
Should have knowledge of Immon data warehouse modelling techniques would add an advantage.
Have practical knowledge of T-SQL (5 years +),
Exposure and knowledge of Oracle, DB2, MySQL, MS Access, Mongo and PostgreSQL will be an advantage.
Have practical experience of SQL Server Database Engine (5 years +).
Have practical experience of MS SSIS ETL software (5 years +).
Knowledge of MS SSAS OLAP software would add an advantage.
Have practical experience of MS Visual Studio Data Tools (5 years +).
Should have a good understanding of source control systems and the concepts of building and releasing software versions. Microsoft TFS knowledge is preferred.
Clear understanding and application of DAMA framework.
Have the ability to draft new data governance policies in accordance with TOGAF, ZACHMAN or other frameworks

IT Degree,
3-5 Years development experience within a SQL data lake and warehouse environment within the Financial Sector and
Must have knowledge of the Software Development Lifecycle
Have knowledge of financial acts and compliance frameworks requirements would add greater value.

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

Similar jobs you might be interested in:

Senior Business Intelligence Developer
Location: Johannesburg
Salary:
14 days ago

Senior Data Warehouse Developer
Location: Centurion
Salary: Monthly
Psybergate is an IT company that builds bespoke software solutions and provides highly skilled resources to itsÂ clients.We are looking for a Senior Data warehouse developer to join our financial services client based in Centurion.
17 days ago

Ab Initio Data Engineer
Location: Johannesburg
Salary:
71 days ago

AWS Support Consultant
Location: Johannesburg
Salary:
7 days ago

Data Engineer
Location: Johannesburg
Salary: Annually
The Data Engineer will be responsible for developing data architecture and integration pipelines to ensure information accuracy, quality and accessibility.
8 days ago

Data Engineer
Location: Johannesburg
Salary: R 1 000 000 Annually
Are you an experienced Data Engineer ready to take on a high-impact role? Join a forward-thinking organisation in Sandton and help design scalable data solutions that drive business intelligence. If you have GCP and Big Data expertise, this is your chance to make a difference!
9 days ago

MS Fabric Data Engineer (Team Lead) (JHB/CPT)
Location: Johannesburg
Salary:
16 days ago

BI Developer (Centurion)
Location: Centurion
Salary: 25000 Monthly
Job Purpose:Developing and maintaining a Business Intelligence System, reporting to assist in various projects.Qualifications and or Experience:PythonR (programming language)MS sqlNosqlDiploma / Degree in Information SystemsBI Reporting (Power BI will be added advantage)Data warehouse designAzure cloud computing – added advantageAzure data lake and databaseAzure analysis and integration serv...
17 days ago

Senior BI Developer
Location: Johannesburg
Salary: 500000 Annually
Our client is seeking a Senior BI developer (Specialist) to join their dynamic team in the East of JHB - (Bruma)
20 days ago

General Manager Data Warehouse
Location: Johannesburg
Salary:
36 days ago

SQL Warehouse Developer

Similar jobs you might be interested in:

Create a free job alert for SQL Warehouse Developer in Centurion