Wellington Machetele
Senior ETL Developer
Kibler Park
Summary
Experienced with developing complex ETL processes to support data-driven decision-making. Utilizes SQL and data warehousing techniques to ensure data integrity and accessibility. Track record of enhancing business intelligence operations through effective data integration and transformation.
Results-driven data professional, bringing extensive experience in developing and optimizing ETL workflows. Skilled in transforming complex data sets into actionable insights while maintaining data integrity. Known for fostering team collaboration and adaptability in dynamic environments, utilizing expertise in SQL, data warehousing, and problem-solving.
Offering solid foundation in data analysis and software development, eager to learn and develop in ETL environment. Brings strong understanding of SQL and data warehousing concepts, coupled with hands-on experience in Power BI and database management.
Overview
12
12
years of professional experience
Work History
Senior ETL Developer
Paytronix Systems
11.2023 - Current
- Creating and Designing ETL packages using SDT
Senior ETL Developer/Technical-Lead
Hollard
03.2019 - 10.2023
- Creating and Designing ETL packages using SDT
- Extracting data from flat files / Databases and pushing data into Operational Data store
- Designing and Creating PowerBI Dashboards
- Creating Reports
- Creating Data Repositories and making sure that Data Quality at the right level
- Data Migration from Legacy System (MIP) to Cloud System (Exergy)
- Creating Data pipeline in Data Factory (Azure) to load files from blob storage into SQL Azure Data Repository
- Spinning up VMs in Azure and creating resources in Azure
- Involved in Code reviews and Management Sprints to allocate work to resources in the team
- Involved in the Designing and Development of Solution that will load data from off platform ODS to Central Staging environment
- Involved in the design of data flow from ODS into the IFRS 17 Azure environment
- Data Lead on the IFRS 17 Project
- Developing ETL that loads and transforming ODS data to conform to IFRS 17 format and ultimately loading data into Azure environment
- Involved in the architecture design of the process for loading data into the IFRS17 Databases
Developer
ETC Solutions
07.2017 - 02.2019
- Creating and Designing Business Intelligence Reports and Dashboards using Power BI and SSIS Packages
- Creating SSIS Packages using SSDT(Visual Studios) which import flat files into the data warehouse
- Designing Fact Tables and Dimensions in Data warehouses
- Designing and Creating Data warehouses
- Creating Jobs in SQL Server that pull data from different databases using DBLinks
- Monitoring SQL Server Jobs and troubleshooting failed Jobs and steps within the jobs
- Writing TSQL queries and stored Procedures in SQL Server and Oracle databases
- Creating DBLinks that pull data from Oracle Databases into SQL Server Databases
- Optimising Queries and performance tuning
- Creating Dashboards using Power BI that have Visuals such as gauges, graphs and alerts
- I am the only one in my team who does development so at times I find myself having to assist my team mates with support work especially when we are short staffed and that ends up being side tracked and eats into my development time at most times
Developer
Tracker Connect
04.2014 - 06.2017
- Documentation and assisting with backlog grooming for items on a sprint
- Maintaining internal systems and adding new features to the Tracker CRM system
- Importing and cleaning daily transactional data, Data quality checks and bulk data imports into Oracle databases
- Working on web APIs (C#)
- Bug fixes on the current CRM system and providing feedback to Business
- Provide technical support for existing CRM also on the Oracle databases sides
- Testing Code on the new Features that I have developed and then checking the code in on TFS
- Working with Entity framework to add new Models to our databases
- Mentoring Interns by giving them SQL Tasks and teaching them how to develop in C#, using TFS and Microsoft SQL Server, SQL Developer
Junior Developer
Gemini GIS & Environmental Services
10.2012 - 03.2014
- Company Overview: Company that is part of the TWP Enterprise Development centre
- Developing Desktop applications in Java
- Web Application Design
- Querying PostgreSQL Databases
- Database Design
- Company that is part of the TWP Enterprise Development centre
Education
Certifcation - TOGAF Certification
Torque IT
Johannesburg, South Africa 04.2001 -
Certificate - Business Intelligence
Torque IT
Johannesburg, South Africa 04.2001 -
Diploma - Information Technology
Damelin
Johannesburg, South Africa 04.2001 -
High School Diploma -
Rand Private School
Johannesburg, South Africa 04.2001 -
Skills
Team leadership
Master data management
Data quality management
API integration
Advanced analytics
Scripting languages
Business intelligence tools
Data visualization techniques
Data migration strategies
Data modeling techniques
Performance tuning
Metadata management
Cloud computing platforms
ETL tool proficiency
Data warehouse design
Data integration expertise
SQL development
ETL modeling
Data warehousing management
Data validation
SQL programming
Database design
Data migration
Data modeling
Data mapping
Data warehousing
Business intelligence
Data governance
Data profiling
Data integration
Teamwork
Teamwork and collaboration
Problem-solving
Time management
End user support
Problem-solving abilities
Decision-making
Self motivation
Excellent communication
Multitasking Abilities
Front-end development
Time management abilities
Adaptability and flexibility
Effective communication
Team collaboration
Organizational skills
Team building
Attention to detail
Active listening
Problem-solving aptitude
Customer relationship management
Cryptography
Adaptability
JIRA
Analytical thinking
Relationship building
Agile methodologies
Quality assurance
Analytical skills
Data analysis
Task prioritization
Programming
Professionalism
Reliability
Reliability
Written communication
Software development tools: JIRA, confluence
Continuous improvement
Interpersonal communication
Script writing
Creative problem solving
Source and version control: git, github
Software deployment
Code reviews
Performance improvement
GitHub collaboration
Timeline
Senior ETL Developer
Paytronix Systems
11.2023 - Current
Senior ETL Developer/Technical-Lead
Hollard
03.2019 - 10.2023
Developer
ETC Solutions
07.2017 - 02.2019
Developer
Tracker Connect
04.2014 - 06.2017
Junior Developer
Gemini GIS & Environmental Services
10.2012 - 03.2014
Certifcation - TOGAF Certification
Torque IT
04.2001 -
Certificate - Business Intelligence
Torque IT
04.2001 -
Diploma - Information Technology
Damelin
04.2001 -
High School Diploma -
Rand Private School
04.2001 -
Similar Profiles
David TaylorDavid Taylor
Group Product Manager at Paytronix Systems, Inc. / Access GroupGroup Product Manager at Paytronix Systems, Inc. / Access Group
PATRICIA AMBERGPATRICIA AMBERG
SMB Account Executive at PaytronixSMB Account Executive at Paytronix
Suman SudagoniSuman Sudagoni
Technical Lead/ Project Lead Engineer at OSI Systems pvt Ltd (Rapiscan Systems and AS&E)Technical Lead/ Project Lead Engineer at OSI Systems pvt Ltd (Rapiscan Systems and AS&E)
Tshililo Irene MunyaiTshililo Irene Munyai
General Worker at RFGGeneral Worker at RFG
Ellenore JacksonEllenore Jackson
Credit Manager/Accountant at Tidy Files/Cleardata/Vysion/BOS/GlobalCredit Manager/Accountant at Tidy Files/Cleardata/Vysion/BOS/Global