Location: Cape Town We are seeking a highly skilled ETL/ SQL Server Developer to join our client in Cape Key Responsibilities: Design, develop and maintain ETL processes using SQL Server Integration Services (SSIS) and resolve any issues with ETL processes and data quality Optimize ETL processes for improved performance Develop and maintain technical documentation for ETL processes and data flows Requirements: Bachelor's field Minimum of 5 years of experience in SQL Server ETL development Strong understanding of complex SQL queries
advanced data modeling techniques and contribute to ETL process enhancement.
NoSQL databases, data warehousing solutions, and ETL tools
Enhance and automate data delivery and quality in ETL processes. Guide and mentor junior team members as years of SSIS experience, including creating complex ETL processes, error handling, loading data from various
SQL server, Oracle etc., and tools that enable ETL and orchestration.
extensive experience in data migration, integration, and ETL processes. Familiarity with modern data platforms Migration, Data Architecture, SQL, NoSQL, Python, ETL Processes
warehousing
Command an unparalleled mastery of SQL, ETL tools, and data modelling techniques
Showcase
with DAX and Power Query Very good understanding of ETL and DWH processes Experience working in Azure DevOps organisation Design, development and maintenance of ETL processes in Microsoft Power BI Supports activities with DAX and Power Query Very good understanding of ETL and DWH processes Experience working in Azure DevOps organisation Design, development and maintenance of ETL processes in Microsoft Power BI Supports activities
experience of designing, developing and testing ETL processes • Experience of batch and real-time processing approaches • Experience of at least one packaged ETL tool • Technical expertise with data models, data experience of designing, developing and testing ETL processes • Experience of batch and real-time processing approaches • Experience of at least one packaged ETL tool • Technical expertise with data models, data