Data Engineer
ey
Job Description
- Hands-on experience in expertise in designing, developing, and implementing data solutions, data warehouse/data Lake using Snowflake
- Has good knowledge on Snowflake Architecture (compute–storage separation, virtual warehouses)
- Analyzing Queries Using Query Profile, Cache architecture
- Implement data integration solutions using Snowflake, including data ingestion from various sources.
- Experience on Streams, Tasks, Snow pipe Azure Data Factory or any other ETL for data ingestion & automation
- Design and Develop ETL workflows for Snowflake, Experience using different ETL Solutions.
- Strong database programming/ backend development experience using SQL Server/Azure SQL, writing complex queries, stored procedures, views, triggers, cursors, UDFs.
- Strong knowledge in data modeling and Datawarehouse concepts.
- Develops, maintains, and optimizes all data layer components for new and existing systems, including databases, stored procedures, ETL packages, and SQL queries
- Experience on Azure data platform offerings.
- Interacts with application developers from various core systems to address changes in those systems and their impact on existing SQL databases
- Defines data solutions for business problems by working directly with project managers, seniors and clients
- Ability to effectively communicate with other senior leaders of IT on program strategies and plans and negotiate quality solutions
- Experience in Data modeling (Star, Snowflake schema, Data Vault)
- Has Knowledge of CI/CD pipelines