Azure Data Engineer

Description

This project includes creating ETL processes to migrate from the existing system into the new data warehouse format. Additionally building Synapse pipelines to move the data from on- premises into a data lake in Azure.
Extensive experience with development of stored procedures and ETL processes using T-SQL
Thorough understanding of data warehouse design hierarchies such as star and snowflake schemas
Use of ALM tools for work item management, version control, code analysis, and testing
Broad and extensive knowledge of the software development process and its technologies
Familiarity with continuous integration
Experience creating and scheduling elastic jobs
Experience with designing and modeling database structures based on business use cases

Responsibilities

• • Working closely with the database and system administrators to develop stored
• procedures and ETL processes related to the data warehouse system.
• • Working in collaboration with vendors and other agency staff to design, develop and manage the creation Synapse pipelines:
• • Ability to work independently and cooperatively as part of a team.
• • Ability to work under severe time constraints.
• • Must possess analytical and complex problem-solving skills.