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 BI Developer – Johannesburg – up to R1.2mil per annum
Location: Johannesburg
Salary: 1 200 000
Senior BI developer – Johannesburg – up to R1.2mil per annum
8 days ago

BI Developer Lead
Location: Johannesburg
Salary:
12 days ago

Data Engineer (AWS and Redshift) - Johannesburg – up to R1mil
Location: Johannesburg
Salary: 1000000
Data Engineer (AWS and Redshift) - Johannesburg – up to R1mil
26 days ago

Inventory Analyst
Location: Midrand
Salary: Monthly
Well known medical supplier based in Midrand requires an Inventory Analyst with strong analytical skills within a stock / warehouse environment.
8 days ago

Inventory Assistant
Location: Midrand
Salary: Monthly
Well known medical supplier based in Midrand requires an Inventory Assistant with previous or current stock control experience within the "medical device" or healthcare industry.
15 days ago

Data Analyst
Location: Johannesburg
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 Data Analyst to join our financial services client based in Johannesburg for a 9-months contract role.
22 days ago

Senior Full Stack Business Intelligence Developer – Johannesburg – up to R1.1mil
Location: Johannesburg
Salary: 1 100 000
Senior Full Stack Business Intelligence developer – Johannesburg – up to R1.1mil
8 days ago

SQL Warehouse Developer

Similar jobs you might be interested in:

Create a free job alert for SQL Warehouse Developer in Centurion