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:

Principal Database Engineer
Location: Fourways
Salary: Market Related
We are looking for a Software developer in a Principal Database Engineer position who has significant hands-on experience with Oracle Suite, for a Multinational company based int he Fourways area in Johannesburg.
7 days ago

Senior Data Warehouse Developer
Location: Johannesburg
Salary:
Are you a data-driven problem solver who thrives on turning complex datasets into meaningful business insights? A leading financial services group is seeking a Senior Data warehouse developer to design, develop, and optimise enterprise-level data warehouse solutions. This role is ideal for a technically strong professional who enjoys collaborating with stakeholders and delivering high-quality repo...
22 days ago

Azure Data Engineer
Location: Johannesburg
Salary: negotiable
Our client based in Sandton is looking for an Azure Data Engineer to join their team. 12-month contract is renewable.
1 day ago

Financial Systems and Data Analyst
Location: Johannesburg
Salary:
7 days ago

Commercial Systems and Data Analyst
Location: Johannesburg
Salary:
7 days ago

Data Engineer
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 Engineer to join our financial services client based in Sandton on a contract basis.
10 days ago

Senior BI Developer
Location: Johannesburg
Salary: 450000 Annually
Are you a data-driven problem solver who thrives on building robust BI solutions and turning complex data into meaningful insights? We’re looking for a Senior BI developer to join a dynamic and fast-paced environment where innovation, collaboration, and continuous improvement are key.
21 days ago

Microsoft Fabric Specialist (Data Engineering, Governance & DWH) (Onsite – JHB) (Contract)
Location: Johannesburg
Salary:
22 days ago

Senior Director: Software Engineering
Location: Pretoria
Salary:
Our client, an award-winning MedTech, is looking for a Senior Director: Software Engineering to join their team.
10 days ago

Software Engineering Director
Location: Pretoria
Salary:
Our international client, based in Pretoria, is seeking a Software Engineering Director to lead multi-disciplinary development teams across Mobile, Web and Test Engineering. The role partners closely with Architecture, Platform and Data functions to shape product and project strategy, oversee capacity planning and define technical direction.As the subject matter expert for front-end development an...
9 days ago

SQL Warehouse Developer

Similar jobs you might be interested in:

Create a free job alert for SQL Warehouse Developer in Centurion