Job Description

","library":"fa-solid"},"toggle":"burger"}" data-widget_type="nav-menu.default">MenuData Modeler/ETL Developer (HLR7979) RemoteLocation: RemoteRemuneration: Market relatedHLR Reference #: HLR7979Environment:International Company with a focus on delivering customised data warehousing design and development and data visualization to a global client base. Offers a fully remote work environment on an 8-hour day contract basis, specifically skilled persons based in SA. It is expected that successful persons have suitable work environment setup from power and connectivity perspective to work remotelyPurpose of the role:

• Liaise with Clients and develop an understanding of business processes and data reporting needs.
• Critically analyze business requirements and architect and implement design flows and data integration
• Develop data warehouse models and lineage documentation which will be used by ETL developers to build out the data warehouse
• Produce technical/architectural specification and design/technical documents
• Design and create ETL/ELT scripts for data warehouse and reporting tables
• Implement stored procedures and effectively query databases
• Design and program data quality and exception reports
• Participate in defining and optimizing software development process and best practices
• Identify and test for defects and bottlenecks in the ETL solution to ensure high performance and no data quality concerns
• Provide support and fix ETL/ELT issues

Qualifications and Experience Required:

• Relevant degree and certification
• Knowledge of data modelling
• 6 years in a relevant environment applying relevant skills
• 5 years ETL experience
• Indepth knowledge of systems architecture, distributed development, web-services
• Strong knowledge of data warehouse architecture techniques such as EDW, ODS, DM, ROLAP and MOLAP
• Understanding and coding of concepts such as incremental load, slowing changing dimension types
• Experience writing complex SQL scripts used for ETL development or testing
• 1+ years' experience in Azure SQL Data Warehouse and related technologies including one or more of: Azure Data Factory, Azure Data Lake, Azure HDInsight, Azure Databricks, etc.
• Experience with SSIS or Talend and SQL Server; ability to deploy to and debug a production SSIS environment. XML experience
• Experience with tuning databases for optimal performance
• To apply please send through your application to: helen@helenlucre.co.za

Consultant:More to explorerApril 23, 2024 No CommentsLocation: Durban Remuneration: Market related HLR Reference #: HLR7978 Environment: Join our large corporate client contributing your SQL development skills within aApril 8, 2024 No CommentsLocation: Cape Town Remuneration: Market related HLR Reference #: HLR7937 Environment: International Company with Cape Town office . Company is an industryMarch 6, 2024 No CommentsLocation: Cape Town Remuneration: Market related HLR Reference #: HLR7627 Environment: Our client who develops a global telematics platform with a channelTHIS WEEKS TOP JOBSJOB SEEKERS TIPSCLIENT SERVICES|
xc2xa9 Copyright 2024 Helen Lucre Resourcing (Pty) Ltd. | All Rights Reserved - Another website created byWe use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.

Helen Lucre Resourcing