Snowflake Engineer
On-siteChennai, Tamil Nadu, India
Chennai, Tamil Nadu, IndiaOn-siteFull TimeLarge
Full TimeLarge
Job Summary
Conduct data migration and warehousing projects including initial loads within Snowflake environments. Build non-functional requirements covering CI/CD, monitoring, orchestration, and data quality. Design conceptual, logical, and physical data models for both OLTP and OLAP systems using STAR or Snowflake schemas. Write complex SQL queries and leverage SnowSQL, Snowpipe, and role-based access controls. Implement ETL/ELT tools and utilize query profiles and information schema tables. Manage heterogeneous data migration projects while applying PL/SQL skills where applicable.
Required Qualifications
- Experience in Data migration and data warehousing projects including initial loads
- Hands-on experience working in migration and build for Snowflake environment
- Well versed with different concepts of snowflake layers, and database objects
- Exposure to SnowSQL, Snowpipe, Role based access controls, ETL / ELT tools
- Build Non-functional requirements for Snowflake (CI/CD, monitoring, orchestration, data quality, monitoring)
- Well versed with Snowflake query profiles, and snowflake information schema tables
- Strong SQL
- Hands on Experience in writing complex SQL queries
- 4 to 6+ years of exp in in designing STAR / Snowflake schema
- Exp in designing - conceptual / logical / physical data models (both OLTP and OLAP)
- Should possess strong SQL, Code / Data Analysis skills
- Experience in working on heterogeneous Data Migration projects
- Should have exp in Snowflake DWH
Desired Qualifications
- Good to have Skills & Experience Required :- PL/SQL Skills
- Should be familiar with Azure/AWS, Databricks, Python, Pyspark Tools - Erwin / IBM infosphere data modeler etc
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.