Data Engineer - Snowflake

Utilize Snowflake SQL to construct sophisticated stored procedures and best practices with data warehouse and ETL ideas, demonstrating mastery of Snowflake data modeling and ELT.

• Develop and maintain data architecture and data models.
• Create standardized procedures for data flows and conduct efficient data integration with other third-party tools and snowflake.
• Collaborate with data science experts, BI developers, and analysts to create custom data models and integrations with snowflake.
• Write SQL queries; do tuning, testing, and problem analysis.
• Involve in Snowflake Developing scripts Unix, and Python and working with Snowflake utilities.
• Gather and analyze system requirements.
• Comprehensive knowledge of the Data Warehouse/ODS, the ETL concept, and the fundamentals of modeling structure
• Passionate to work in Python and recommended to have Snowpro certification
• Enthuse to work in data warehousing, including OLTP, OLAP, Dimensions, Facts, and data modeling, as well as the ability to collect and evaluate system needs
• Profound exposure to any Cloud Data Ecosystem– Azure, AWS, GCP and working familiarity with any ETL tool (Informatica or SSIS) and data visualization tools (Tableau/Power BI)
  
  

Requirements5+ years of experience working in a data warehousing system and a minimum of 1 year of experience building and implementing a full-scale data warehouse solution based on Snowflake.

• Enjoys working on Snowflake Developing scripts Unix, Python, etc. to do Extract, Load, and Transform data and build OLAP queries.
• Practical knowledge of Snowflake tools such as SnowPipe, SnowPython, Snow SQL, Tasks, Streams, Time travel, Optimizer, Metadata Manager, data sharing, and stored procedures.