Data Integration Specialist
2 weeks ago
**Job Description**:
The main purpose of the Data Integration Specialist is to develop and assist with management of data warehousing in BankservAfrica, including data feeds, data quality, ETL and Mart development and to support the analytics strategy and projects via the provision, organisation and pre-processing of data. The position is primarily responsible for gathering and integrating data from source systems into the data structures and software that supply enterprise business intelligence (BI) solutions across BankservAfrica and its associated stakeholders. Performance tuning of new and existing Oracle database tables, schemas and ETL processes will be a key function of the Data Integration Specialist. The Data Integration Specialist will utilize the organisation’s ETL tools to establish data integration workflows for data movement, transformation and integration across multiple databases, including the BI environment. The Data Integration Specialist will be responsible for Capacity Planning and Performance Monitoring of the Oracle Data Warehouse and will continually assess database performance. This role will also be responsible for the provisioning of tokenised data to regulators such as the South African Reserve Bank (SARB) and the Payments Authority of South Africa (PASA) as and when required.
**You will engage with the following stakeholders**:
- Head of Data
- Analytics services
- Technical production teams
- Information Technology Application Development Teams
- DBAs
- External regulators such as SARB and PASA
**Your key responsibilities include**:
**ETL and data design**
- Implementation of advanced design strategies and optimization techniques, using ETL tools.
- Design and documentation of data extractions and transformations.
- Develop and communicate best practices and coding standards ensuring adherence to data warehouse principles.
- Contribute to the ETL components of data mart builds in the BI environment.
- Work closely with the BI team to define and construct the data and data mart objects to support reporting, system and end user functions in the BI solution.
**ETL and database development**
- SQL development and development of complex and efficient queries and stored procedures.
- Basic database administration within the Data Warehousing environment.
- Tuning of the ETL Mappings or jobs, deploying, administering and scheduling ETL jobs.
- Performance tuning of database tables through the use of indexes, statistics collection, partitioning, etc
- Suggest data integration performance benchmarks and develop methods for the automation of data integration quality measurement.
**Data Provisioning**
- Responsible for the provisioning of tokenised data to regulators such as the South African Reserve Bank (SARB) and the Payments Authority of South Africa (PASA) as and when required.
- Responsible for the creation of ad-hoc data extracts for internal and external stakeholders as and when required.
**Troubleshooting and error/failure management**
- Troubleshooting and optimizing ETL code; interpret ETL logs, perform data validation, event handlers.
- ETL development for data movement, data quality, data cleansing and other ETL-related activities.
- Troubleshooting ETL processes failures and technical support for all ETL related issues
**QUALIFICATIONS / KNOWLEDGE**
- Appropriate qualification/training in computer science, software development, informatics or similar.
- Practical experience in ETL, data management and transformation.
- Strong SQL skills.
**EXPERIENCE**
- Experience in data modelling, management and ETL.
- Minimum 3 years’ experience in related field.
- Minimum 3 years' experience in Oracle RDBMS.
- Experience in Database Performance assessment.
- Experience in performance tuning in Oracle.
- Experience in working with large Oracle tables / datasets.
-
Data Integration Specialist
3 weeks ago
Johannesburg, South Africa BankservAfrica Full timeThis details all the information about the job posting. - Share this job as a link in your status update to LinkedIn. **Do you see a future that includes more?** **More exposure to innovative technologies, more personal growth, more experience?** **Look at the position we have available and see how, together we can shape your future, so that you can give...
-
Systems Integration Specialist
1 week ago
Johannesburg, South Africa Dimension Data Full timeSystems Integration Specialist Criteria: - National diploma in computer science or information technology - Experience with Progress 4GL - Experience with C# and VB.net programming languages **Experience**: - Develop and maintain software using the Progress 4GL and VB.net programming languages - Unit testing and debug software, and assist QA with...
-
Data Integration Specialist
2 days ago
Johannesburg, Gauteng, South Africa People Source Full timeAbout Us: People Source is a leading financial services group dedicated to providing innovative solutions to our clients. We are committed to excellence and strive to deliver exceptional results.Job Role: As a Data Integration Specialist, you will play a crucial role in designing, developing and maintaining cloud-based platforms on Azure and WIX. You will...
-
Data Specialist
2 weeks ago
Johannesburg, South Africa Dimension Data Full time**Role Description** The IT Data Specialist applies data analysis, data modelling and quality assurance techniques based on a detailed understanding of business processes to establish, modify or maintain internal data structures and associated components (entity, relationship and attribute descriptions). They develop and maintain of a formal description of...
-
Data Center Services Sales Specialist
2 weeks ago
Johannesburg, South Africa Dimension Data Full time**Senior Data Center Services Sales Specialist** **Role description** Dimension data is seeking a senior data centre services sales specialist to join our sales team in Johannesburg. The primary focus of this role is to take our data centre services value proposition to market, retaining existing business and growing market share. As a senior data centre...
-
Data Integration Specialist
1 week ago
Johannesburg, Gauteng, South Africa Golden Rule Full timeRequirementsUnderstand the business requirement or the downstream process requirement.Deliver Informatica PowerCenter and Power Exchange solution implementation and support.Work with Data Mapper and Data modeler to define the dataflow and implement the ETL to fulfil the requirement.Provide L2 support in Production for Informatica PowerCenter and Power...
-
Data Migration
4 weeks ago
Johannesburg, South Africa ABD Consultants Full time**Key Responsibilities**: - Lead the **extraction, transformation, and loading (ETL) process**. - Develop **secure API integrations** for seamless data exchange between the ERP and external systems. - Ensure **data integrity, validation, and compliance** with financial and HR standards. - Conduct **data cleansing, error handling, and reconciliation...
-
SAP Treasury Integration Manager
3 weeks ago
Johannesburg, South Africa Dimension Data Full time**Position Overview**: This role will work with Treasury Global Process Owner and Business Process Lead to provide support, implementation, and guidance for the Treasury Systems with Aspen for the implementation of project Rally. You will need your experience, know-how, creativity, and analytical powers to solve Aspens Treasury and business integration. You...
-
Johannesburg, Gauteng, South Africa ARCS Full timeAt ARCS, we're seeking a talented IT Architecture and Integration Specialist to design and implement cutting-edge technology stacks for recognition programs and customer engagement initiatives.Key Responsibilities:Develop integration architectures and oversee the seamless integration of diverse technologies.Collaborate with internal and external technology...
-
Integration Specialist
1 week ago
Johannesburg, South Africa Psybergate Full time**What you will be doing**: - The Integration Analyst finalizes the service model for a SOAP or REST service by editing technical interface artefacts such as WSDLs, XSDs, JSON Schemas and Swaggers. The Integration Analyst must be experienced in understanding an outline functional design of a service to meet its information requirements, such as physical,...
-
Specialist Data Scientist
2 days ago
Johannesburg, Gauteng, South Africa NTT Data Full timeResponsibilities:Assist in the development and optimization of market-making models, focusing on equities and equity derivatives.Conduct back testing and research to improve current models and develop new ones.Analyse high-frequency trading data to identify patterns and trends.Implement machine learning techniques, particularly LSTMs and convolutional...
-
OSB Integration Specialist
3 weeks ago
Johannesburg, Gauteng, South Africa DeARX Services Ltd Full timeJob title : OSB Integration SpecialistJob Location : Gauteng, JohannesburgDeadline : March 21, 2025Quick Recommended LinksJobs by Location Job by industries About the jobWe are seeking a skilled OSB Integration Specialist to join our team for a 12-month project. This role offers a hybrid work arrangement. You will be responsible for designing,...
-
ERP Integration Specialist
2 weeks ago
Johannesburg, South Africa Exclusively Remote Full timeWe are looking for an ERP Integration Specialist who will be working on multiple active integration projects at any given time, leading all technical aspects of your projects, some of them custom JSON, XML or CSV file formats supporting complex integration workflows. Ideally, you have 3 to 5 years of functional business process experience, combined with...
-
Integrated Marketing Specialist
3 days ago
Johannesburg, Gauteng, South Africa Ogilvy South Africa Group Full timeThe Ogilvy South Africa Group is an innovative marketing agency that empowers individuals to deliver their best work. We are seeking an Integrated Marketing Specialist to join our team.This role involves working closely with the account and creative teams to set a strategic direction and ensure the work stays on brand and on track.Key...
-
2022 69 a Mt Support Specialist
1 week ago
Johannesburg, South Africa Data Centrix Full time**Requirements**: **Formal qualifications**: - Bachelor's degree, or equivalent work experience (Postgraduate Preferred) - Min 5 years IT Application Management Experiencing with related Mining experience - Project Management Experince (PRINCEII preferred) **Role-specific knowledge**: - Data Management principles, methods, techniques & tools - Mining...
-
Data Privacy and Protection Specialist
1 week ago
Johannesburg, South Africa NTT DATA Full time**Make an impact with NTT DATA** Join a company that is pushing the boundaries of what is possible. We are renowned for our technical excellence and leading innovations, and for making a difference to our clients and society. Our workplace embraces diversity and inclusion - it’s a place where you can grow, belong and thrive. **Your day at NTT DATA** This...
-
Cloud Infrastructure Specialist
1 day ago
Johannesburg, Gauteng, South Africa Data Centrix Full timeCompany OverviewData Centrix is a leading provider of cloud infrastructure solutions. Our team of experts is dedicated to delivering scalable, secure, and high-performance cloud architectures that meet the evolving needs of our clients.Job DescriptionWe are seeking a highly skilled Cloud Architect to lead the design and implementation of our cloud...
-
Storage and Backup Specialist
3 weeks ago
Johannesburg, South Africa Data Centrix Full time**Qualifications and Experience** - Grade 12 - OEM (Dell) Accreditation in Storage and Back-up in some of these certs: - Associate - Information Storage and Management Version 5.0 - Dell Unity XT Unified Storage Solution - Dell EMC Integrated Data Protection Appliance - Dell EMC PowerStore - Technology Architect, Midrange Storage Solutions - Veeam Certified...
-
Systems Integration Specialist
5 days ago
Johannesburg, Gauteng, South Africa Linkfields Innovations (Pty) Ltd Full timeLinkfields Innovations (Pty) Ltd is seeking a talented Systems Integration Specialist to help us achieve our goals. As a Systems Integration Specialist, you will be responsible for integrating different systems and ensuring they work together seamlessly.ResponsibilitiesDesign and implement system integration solutions that meet organizational standards and...
-
Specialist Data Analyst/ Data Scientist
2 weeks ago
Johannesburg, South Africa ClarkHouse Human Capital Full timeDo you love to get your hands dirty and all things Data? Our tech-driven client is looking for a passionate Specialist Data Analyst/ Data Scientist who enjoys the end-to-end process of dealing with data, including data integration and the identification of new data sources. You’ll have a 360 degree of this leading organization's data, and get involved in...