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:

IT Asset Management Coordinator (Tech Tracker)
Location: Johannesburg
Salary:
A dynamic opportunity is available for a detail-oriented and proactive IT Asset Management Coordinator to join an organisation that’s reshaping how businesses manage their tech infrastructure. This role is ideal for someone who thrives on structure, loves data accuracy, and enjoys collaborating with clients to drive continuous improvement.
7 days ago

Data Engineer (Oracle, Databricks & Insurance) – Johannesburg – up to R850k per annum
Location: Johannesburg
Salary: 850000
Data Engineer (Oracle, Databricks & Insurance) – Johannesburg – up to R850k per annum
56 days ago

Oracle Fusion Specialist / Oracle Engineer- Johannesburg – up to R900k per annum
Location: Johannesburg
Salary: 900000
Oracle Fusion Specialist / Oracle Engineer- Johannesburg – up to R900k per annum
56 days ago

Data Engineer (Oracle, Databricks) -Johannesburg- R650k to R850k per annum
Location: Johannesburg
Salary: 850000
Data Engineer (Oracle, Databricks) -Johannesburg- R650k to R850k per annum
63 days ago

Power BI Specialist – Johannesburg - R700k to R900k per annum
Location: Johannesburg
Salary: 700 000
Power BI Specialist – Johannesburg - R700k to R900k per annum
70 days ago

Data Engineer
Location: Johannesburg
Salary: 840000 Annually
Apply here to showcase your Data Engineer skills! Work with modern tech, big data, and a team that loves clean, scalable solutions.
7 days ago

SQL Data Engineer
Location: Centurion
Salary: market related Monthly
Role PurposeOur client offers a collaborative and dynamic work environment. By joining their team, you'll have the opportunity to contribute meaningfully to their data-driven strategies while growing in a culture that values innovation, excellence, and service. RequirementsTechnical Skills:Advanced proficiency in sql Transact, sql Server, SSIS, and SSRS, including performance tuning and query...
8 days ago

SQL Data Engineer (12 month contract)
Location: Centurion
Salary: 1000 Monthly
Our client offers a collaborative and dynamic work environment. By joining their team, you'll have the opportunity to contribute meaningfully to their data-driven strategies while growing in a culture that values innovation, excellence, and service.
9 days ago

Sage Specialist Developer (36 Months)
Location: Pretoria
Salary:
We are recruiting for a Sage Specialist developer role. The ideal candidate will be responsible for developing, customising, and integrating Sage ERP systems to support business process automation.
11 days ago

Data Engineer
Location: Centurion
Salary:
Our client is seeking a skilled Data Engineer to join their growing team. If you are passionate about the technical aspects of the data landscape and thrive on building optimized processes that deliver high-quality, reusable datasets, then this could be the perfect opportunity for you.
11 days ago

SQL Warehouse Developer

Similar jobs you might be interested in:

Create a free job alert for SQL Warehouse Developer in Centurion