Azure ETL / DW Developer
Anicalls
Industry: IT
Total Positions: 3
Job Type: Contract
Contract Period: 12 Months
Gender: No Preference
Salary: 350 ZAR - 400 ZAR (Hourly)
Education: Diploma or Bachelor′s degree
Experience: 5-10 Years
Location: Cape Town, South Africa
Candidate should have:
Experience with Azure Data Factory (ADF) creating multiple complex pipelines and activities using both Azure and On-Prem data stores for full and incremental data loads into a Cloud Datawarehouse
Significant experience with data modeling skills - conceptual, logical, and physical model design, Operational Data Stores, Enterprise Data Warehouses, and Data Marts.
Deep understanding of Azure Cloud Azure Data Lake (Gen1 & Gen2), Data Factory, Azure SQL Data Warehouse, Azure Storage Options, Data Lake Analytics, Stream Analytics, EventHub, Azure SQL. 20
Ability to efficiently code, test & certify in Azure platforms, software, and applications.
Experience in Cloud Data Lake, Data Warehouse, Business Intelligence, Data Marts Data Mining via ETLELT Azure Data Factory.
Experience with U-SQL and experience in building a pipeline from multiple sources.
Able to design, develop and test ETL, Azure Data warehousing, data ingestion Data Factory pipeline, data transformation, and mapping in Azure environments. Expected to build and validate transformation/data movements in Azure environment
Understand and resolve complex technical issues, use common sense, and the ability to think on your feet.
2+ experience with Spark SQL & Scala.
3+ experience in data warehouse processes including project management, ETL/ELT, ODS, Data Marts, Data Mining, data validation, and implementation.
5+ experience with Azure Data Lake (Gen1 & Gen2), U-SQL, Data Factory, Azure SQL Data Warehouse, Azure Storage Options, Data Lake Analytics, Stream Analytics, Data Factory & Azure SQL.
Bachelor's Degree in Computer Science