A leading technology firm in Sacramento is looking for a Data Engineer to support the migration of a legacy platform to Snowflake. The ideal candidate will have over three years of experience with data pipelines, various ETL tools, and database security. A Bachelor's degree in a related field is required. This position offers a chance to work with cutting-edge technology in a collaborative environment.
Qualifications
3+ years of experience in developing and monitoring data pipelines, ETL/ELT.
3+ years of experience with Microsoft SQL Server and T-SQL.
Experience in developing REST APIs, including JSON and C#.
Experience in database design, development, and security.
Experience with data conversion efforts involving legacy data formats.
Responsibilities
Perform data engineering for migration from a legacy platform to Snowflake.
Utilize AWS Glue as the ETL Tool.
Skills
Data pipelines
ETL Tools
Microsoft SQL Server
REST APIs
Database design
Container Platforms
Cloud Computing
Microsoft Visual Studio
Git Code Repositories
SaaS Cloud Database
Education
Bachelor's Degree in a relevant field
Tools
AWS Glue
Snowflake
AWS S3
Kubernetes
Docker
OpenShift
Job description
Position Details
Perform data engineering in support of a migration effort between the client's legacy platform (in Microsoft) to Snowflake.
Experience with AWS Glue as the ETL Tool
Experience with AWS S3 and Snowflake
Minimum Qualifications
At least three (3) years of experience in developing and monitoring data pipelines, ETL/ELT (Extract, Transform, Load / Extract
At least three (3) years of experience with Microsoft SQL Server and T-SQL.
At least three (3) years of experience developing in ETL Tools.
At least three (3) years of experience developing REST APIs, including experience with JSON and C#.
At least one (1) year of experience in database design, database development, and database security.
At least one (1) year of experience working with data conversion efforts involving legacy data formats and legacy data repositories such as Mainframe.
At least one (1) year of experience in Container Platforms such as Kubernetes, OpenShift, Docker, or in Cloud Computing.
At least one (1) year of experience with Microsoft Visual Studio and Git Code Repositories.
At least one (1) year of experience with SaaS Cloud Database in either AWS or Azure
Bachelor's Degree in computer science, engineering, information systems, math, or a technology-related field.