Snowflake Developer

Key Skills: Snowflake Development & Utilities, Advance SQL, ETL Architecture, Unix/Python Scripting, Data Models, Data Migration

Requirements:

• Snowflake SQL, Writing SQL queries against Snowflake Developing scripts Unix, Python, etc. to do Extract, Load, and Transform data.
• Hands-on experience with Snowflake utilities such as SnowSQL, SnowPipe, Python, Tasks, Streams, Time travel, Optimizer, Metadata Manager, data sharing, and stored procedures.
• Daily responsibilities are data migration using flat files, collecting information related to ingestion process, understanding the logic and implement the same. Data validation to ensure unit testing.
• Supporting job scheduling, monitoring activities and reconciliation process.
• ETL tool: DBT, Advanced SQL along with good Python scripting skill.
• Familiar with Agile delivery process.
• Experience and familiarity with data models and artefacts (entity relationship diagrams, conceptual models, logical models, star schemas, third normal form).
• Experience in writing complex SQL queries.
• Good knowledge in any RDBMS like Azure, SQL Server.
• Excellent communication skills both verbal and written.
• Must have Understanding of data model, ETL architecture.
• Excellent in Data Warehouse concepts.
• Excellent in writing complex SQL queries with performance tuned to be run in a tool. GITHUB, Jenkins.