Job Details

ID #18458848
State Iowa
City Des moines
Job type Contract
Salary USD Depends on Experience Depends on Experience
Source Kanap Systems LLC
Showed 2021-08-19
Date 2021-08-17
Deadline 2021-10-16
Category Et cetera
Create resume

ETL Data Engineer

Iowa, Des moines, 50301 Des moines USA

Vacancy expired!

ETL Data EngineerLocation – IA JOB DESCRIPTIONThe Candidate will be working within the Data Warehouse team to build Azure pipelines, transition data, document metadata, and work within the parameters of the Agency’s data governance processes and policies. The Candidate will be working within the Data Warehouse team to build Azure pipelines, transition data, document metadata, and work within the parameters of the Agency’s data governance processes and policies. This position will be working within the Data Warehouse team to build Azure pipelines, transition data, document metadata, and work within the parameters of the Agency’s data governance processes and policies. Experience using Azure Data Factory and a Data Lake in a production environment is required of this position. The Department of Human Services is transitioning their on-premise Data Warehouse to the Azure platform. This role will be integrated within the current team to help ensure the success of the project. REQUIREMENTS

  • Experienced in developing and implementing ETL solutions, Relational Databases, NoSQL, Data Management, and infrastructure capabilities. [10 YEARS]
  • Experience in developing ETL solutions using SSIS, SQL Server, and T-SQL stored procedures/views. [7 YEARS]
  • Experience in developing ETL solutions using Microsoft Azure Cloud Services [3 YEARS]
o Azure Integration Runtimeo Azure Data Lakeo Azure Data Factoryo Azure SQL Databaseo Azure SQL Data Warehouse (now Synapse) o Azure Resource Manager
  • Experience developing and implementing Source Control and CI/CD solutions using of using Azure Dev Ops. [2 YEARS]
  • Strong problem solving and debugging skills, particularly with ETL processes in particular. [REQUIRED
  • Clear and concise communication and technical writing skills. [REQUIRED}
  • Strong passion for helping developers connect people and communities through the cloud. [REQUIRED]
  • Database migrations from on-premise data stores and other cloud platforms to Azure [REQUIRED]
  • Hands-on working experience in COBOL/JCL/REXX/DFSORT or SYNCSORT - knows how to get into CICS, navigate, look at Vsam files, and run program files within CICS> lots of source systems come from a mainframe. [HIGHLY DESIRED]
  • Working experience of Infrastructure as Code methods, examples being Azure Resource Manager (ARM) Templates, Powershell, or JSON scripting. [HIGHLY DESIRED]
RequirementsSkillRequired / DesiredAmountof ExperienceExperienced in developing and implementing ETL solutions, Relational Databases, NoSQL, Data Management, and infrastructure capabilitiesRequired10Yearsexperience in developing ETL solutions using SSIS, SQL Server and T-SQL stored procedures/views.Required7Yearsexperience in developing ETL solutions using Microsoft Azure Cloud ServicesRequired3Years• Azure Integration Runtime •Azure Data Lake • Azure Data Factory • Azure SQL DatabaseRequired3Years• Azure SQL Data Warehouse (now Synapse) • Azure Resource ManagerRequired3Yearsdeveloping and implementing Source Control and CI/CD solutions using of using Azure Dev Ops.Required2YearsStrong problem solving and debugging skills.Required Strong communication and technical writing skills.Required Strong passion for helping developers connect people and communities through the cloud.Required working experience in COBOL/JCL/REXX/DFSORT or SYNCSORTDesired Database migrations from on-premise data stores and other cloud platforms to Azure.Desired Working experience of Infrastructure as Code methods, examples being Azure Resource Manager (ARM) Templates, Powershell or JSON scripting.Desired

Vacancy expired!

Subscribe Report job