Responsibilities:
● In-depth knowledge of Snowflake’s data warehousing capabilities. ● Understanding of Snowflake’s virtual warehouse architecture and how to optimize performance and cost. ● Proficiency in using Snowflake’s data sharing and integration features for seamless collaboration. ● Develop and optimize complex SQL scripts, stored procedures, and data transformations. ● Work closely with data analysts, architects, and business teams to understand requirements and deliver reliable data solutions. ● Implement and maintain data models, dimensional modeling for data warehousing, data marts, and star/snowflake schemas to support reporting and analytics. ● Integrate data from various sources including APIs, flat files, relational databases, and cloud services. ● Ensure data quality, data governance, and compliance standards are met. ● Monitor and troubleshoot performance issues, errors,
and pipeline failures in Snowflake and associated tools. ● Participate in code reviews, testing, and deployment of data solutions in development and production environments. Skills expectation: o Experience with ETL/ELT tools and techniques, including Snowpipe, AWS Glue, openflow, fivetran or similar tools for real-time and periodic data processing. o Solid skills in writing SQL queries, stored procedures, user-defined functions and functions in any of the SQL supported databases o Skills in optimizing SQL queries for performance and efficiency and transforming data within Snowflake using SQL. o Strong software development skills in Python o Experience with DBT for database object modeling and provisioning. o Experience in version control tools, particularly Azure DevOps.
📌 Associate Architect Data (Bengaluru)
🏢 Quantiphi
📍 Bengaluru
Reply to this offer
Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.