Client is seeking a senior ETL developer to ingest/transform and load Data Assets and implement a cloud-based data management platform that will support the agency.
Experience with key data warehousing architectures including Kimball and Inmon, and has broad experience designing solutions using a broad set of data stores (e.g., HDFS, Azure Data Lake Store, Azure Blob Storage, Azure SQL Data Warehouse, Databricks
Technologies Required:
Data Factory v2, Data Lake Store, Data Lake Analytics, Azure Analysis Services, Azure Synapse, Snowflake
IBM DataStage, Erwin, SQL Server (SSIS, SSRS, SSAS), ORACLE, T-SQL, Azure SQL Database, Azure SQL Datawarehouse.
Operating System Environments (Windows, Unix, etc.).
Scripting experience with Windows and/or Python, Linux Shell scripting
Advanced understanding of data integrations. · Strong knowledge of database architectures, strong understanding of ingesting spatial data