Sierre Technologies
Snowflake Data Engineer
Sierre Technologies, Jersey City, New Jersey, United States, 07390
Company Description
Please note : We cannot sponsor visa and C2C.
Job Description
Job Description: Please note : We cannot sponsor visa and C2CDesign develop test deploy and maintain enterprise level applications using the Snowflake platformWork with a variety of stakeholders to understand requirements and deliver solutionsTake ownership of a project and see it through to completionExperience with the Snowflake platformBuilding ELT pipelines (batch and streaming) in Snowflake.Utilizing DBT for transformations in Snowflake.Handling large and complex datasets like JSON, ORC, PARQUET, CSV from various sources like AWS S3, Azure DataLake Gen2.Working with Snowflake concepts such as Snowpipe, Streams, Tasks, Cloning, Time Travel, Data Sharing, Data Replication.Performance tuning and resource monitor setup.Snowflake modeling (roles, databases, schemas) for over 3 years.SQL performance measuring, query tuning, and database tuning.ETL tools experience (Datastage, Informatica, etc.).Working with SQL-based databases (Oracle SQL Server, Teradata).Snowflake warehousing, architecture, processing, administration.Data ingestion into Snowflake.Experience working with Linux systemsQualifications
Requirements
Working experience with and in-depth knowledge of Snowflake and its family of tools, preferably over multiple projects. As an orientation, you are likely to have 2+ years of hands-on Snowflake experience.Data transformation background: sound conceptual understanding and practical experience of data modeling and ETL processing, including extensive knowledge of SQL, including Snowflake's SQL flavor. As an orientation, you are likely to have 4+ intensive years in the field.At least some experience in cloud data management in AWS or GCP data stack components (primarily batch data management, storage, loading, transformation of structured data, Data Lake storage and management tools).Team player with ability and explicit willingness to cooperate with other team members, including non-technical business stakeholders in moving the project forward. For this you need to be proactive, and to have some level of business understanding and a genuine interest in the business impact of the project.Strong technical and business English (oral, reading and writing).Advantages
SnowPro certification, preferably SnowPro Advanced Data Engineer.Development background in Python, preferably focused on data ingestion / transformation.PySpark / Spark experience.
Additional Information
All your information will be kept confidential according to EEO guidelines.
Please note : We cannot sponsor visa and C2C
Please note : We cannot sponsor visa and C2C.
Job Description
Job Description: Please note : We cannot sponsor visa and C2CDesign develop test deploy and maintain enterprise level applications using the Snowflake platformWork with a variety of stakeholders to understand requirements and deliver solutionsTake ownership of a project and see it through to completionExperience with the Snowflake platformBuilding ELT pipelines (batch and streaming) in Snowflake.Utilizing DBT for transformations in Snowflake.Handling large and complex datasets like JSON, ORC, PARQUET, CSV from various sources like AWS S3, Azure DataLake Gen2.Working with Snowflake concepts such as Snowpipe, Streams, Tasks, Cloning, Time Travel, Data Sharing, Data Replication.Performance tuning and resource monitor setup.Snowflake modeling (roles, databases, schemas) for over 3 years.SQL performance measuring, query tuning, and database tuning.ETL tools experience (Datastage, Informatica, etc.).Working with SQL-based databases (Oracle SQL Server, Teradata).Snowflake warehousing, architecture, processing, administration.Data ingestion into Snowflake.Experience working with Linux systemsQualifications
Requirements
Working experience with and in-depth knowledge of Snowflake and its family of tools, preferably over multiple projects. As an orientation, you are likely to have 2+ years of hands-on Snowflake experience.Data transformation background: sound conceptual understanding and practical experience of data modeling and ETL processing, including extensive knowledge of SQL, including Snowflake's SQL flavor. As an orientation, you are likely to have 4+ intensive years in the field.At least some experience in cloud data management in AWS or GCP data stack components (primarily batch data management, storage, loading, transformation of structured data, Data Lake storage and management tools).Team player with ability and explicit willingness to cooperate with other team members, including non-technical business stakeholders in moving the project forward. For this you need to be proactive, and to have some level of business understanding and a genuine interest in the business impact of the project.Strong technical and business English (oral, reading and writing).Advantages
SnowPro certification, preferably SnowPro Advanced Data Engineer.Development background in Python, preferably focused on data ingestion / transformation.PySpark / Spark experience.
Additional Information
All your information will be kept confidential according to EEO guidelines.
Please note : We cannot sponsor visa and C2C