Required Skills

DataWarehouse Engineer

Work Authorization

  • Us Citizen

Preferred Employment

Employment Type

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 17th Aug 2021

JOB DETAIL

The Candidate will be working within the Data Warehouse teamto build Azure pipelines, transition data, document metadata, and work withinthe parameters of the Agency’s data governance processes and policies.

 

Experience using Azure Data Factory and a Data Lake in aproduction environment is required of this position.  The Department ofHuman Services is transitioning their on-premise Data Warehouse to the Azureplatform.  This role will be integrated within the current team to helpensure the success of the project.

 

SkillsMatrix:

•             Experienced in developing and implementing ETL solutions, Relational Databases,NoSQL, Data Management, and infrastructure capabilities.  [10 YEARS]

               Years of Experience:

•             Experience in developing ETL solutions using SSIS, SQL Server, and T-SQL storedprocedures/views. [7 YEARS]

               Years of Experience:

•             Experience in developing ETL solutions using Microsoft Azure Cloud Services [3YEARS]

               Years of Experience:

o            Azure Integration Runtime, Azure Data Lake, Azure Data Factory, Azure SQLDatabase [3 YEARS]

               Years of Experience:

o            Azure SQL Data Warehouse (now Synapse), Azure Resource Manager [3 YEARS]

               Years of Experience:

•             Experience developing and implementing Source Control and CI/CD solutions usingof using Azure Dev Ops. [2 YEARS]

               Years of Experience:

•             Strong problem solving and debugging skills, particularly with ETL processes inparticular. [REQUIRED]

               Years of Experience:

•             Clear and concise communication and technical writing skills.  [REQUIRED]

Years of Experience:

•             Strong passion for helping developers connect people and communities through thecloud.  [REQUIRED]

               Years of Experience:

•             Database migrations from on-premise data stores and other cloud platforms toAzure [REQUIRED]

               Years of Experience:

  • 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]

Years of Experience:

•             Working experience of Infrastructure as Code methods, examples being AzureResource Manager (ARM) Templates, Powershell, or JSON scripting.  [HIGHLYDESIRED]

Years of Experience:

Company Information