Data Engineer - Snowflake

Job description

**Role & responsibilities** As a **Data Engineer Snowflake,** you will have the opportunity to solve some of the most captivating data management problems. On a typical day, you might - 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. **Preferred candidate profile** - 4+ 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. - Comprehensive knowledge of the Data Warehouse/ODS, the ETL concept, and the fundamentals of modeling structure - Passionate to work in Python/Pyspark/Snowpark 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) Note: This role requires 5 days a week in office (Chennai)