Snowflake Architect
Full time
at Jobility Talent Solutions
in
India
Posted on December 24, 2024
Job details
Role & responsibilities
- Implementing data management solutions.
- Certified Snowflake cloud data warehouse Architect
- Deep understanding of start and snowflake schema, and dimensional modelling.
- Experience in the design and implementation of data pipelines and ETL processes using Snowflake.
- Optimize data models for performance and scalability.
- Collaborate with various technical and business stakeholders to define data requirements. Ensure data quality and governance best practices are followed.
- Experience with data security and data access controls in Snowflake.
- Expertise in complex SQL, python scripting, and performance tuning.
- Expertise in Snowflake concepts like setting up Resource monitors, RBAC controls, scalable virtual warehouse, SQL performance tuning, zero-copy clone, time travel, and automating them. Experience in handling semi-structured data (JSON, XML), and columnar PARQUET using the VARIANT attribute in Snowflake.
- Experience in re-clustering the data in Snowflake with a good understanding of Micro-Partitions. Experience in Migration processes to Snowflake from an on-premises database environment. Experience in designing and building manual or auto-ingestion data pipelines using Snowpipe.
- SnowSQL experience in developing stored procedures and writing queries to analyze and transform data.
- Competitive compensation package.
- Opportunity to work with industry leaders.
- Collaborative and innovative work environment.
- Professional growth and development opportunities.
Apply safely
To stay safe in your job search, information on common scams and to get free expert advice, we recommend that you visit SAFERjobs, a non-profit, joint industry and law enforcement organization working to combat job scams.