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 Microsoft Developer
Location: Johannesburg
Salary:
12 days ago


Senior Data Warehouse Developer
Location: Centurion
Salary:
19 days ago


Centurion BI Developer | Data Scientist | Data Analyst
Location: Centurion
Salary:
76 days ago


SENIOR DATA ENGINEER (AZURE) - FULLY REMOTE - UP TO R1.1M PER ANNUM
Location: Johannesburg
Salary: 1100000
SENIOR DATA ENGINEER (AZURE) - FULLY REMOTE - UP TO R1.1M PER ANNUM
78 days ago


Senior Backend C# Developer – Johannesburg (Hybrid) – up to R1.2mil per annum
Location: Johannesburg
Salary: 1200000
Senior Backend C# developer – Johannesburg (Hybrid) – up to R1.2mil per annum
81 days ago


LEAD BACKEND C# DEVELOPER – JHB (KYALAMI) UP TO R1.2M PER ANNUM
Location: Johannesburg
Salary: 1200000
LEAD BACKEND C# developer – JHB (KYALAMI) UP TO R1.2M PER ANNUM
84 days ago


Junior AI Engineer (12 month contract)
Location: Centurion
Salary: 400 000 Annually
Are you passionate about artificial intelligence and eager to play a hands-on role in shaping real-world AI solutions?
4 days ago


Senior Data Engineer
Location: Johannesburg
Salary: Annual Salary
Are you the BEST Senior Data Engineer??
5 days ago


Project Manager (Finance and Operations)
Location: Johannesburg
Salary: 1000000 Annually
If you’re not afraid to roll up your sleeves, get your hands dirty, and dive deep into systems and processes to make real impact, then this role is for you.
19 days ago


IT Analyst
Location: Rosslyn
Salary:
20 days ago


Create a free job alert for SQL Warehouse Developer in Centurion

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