Solution Architect - Snowflake Data Architecture Job
Pune, MH, IN
We are looking forward to hiring Snowflake Data Architect professionals, who thrive on challenges and have the desire to make a real difference in the business world. With an environment of extraordinary innovation and unprecedented growth, this is an exciting opportunity for a self-starter who enjoys working in a fast-paced, quality-oriented, and team environment.
What should you have?
• Must have a total of 10+ yrs. in IT and 3+ years experience working as a snowflake Data Architect and 8+ years in Data warehouse, ETL, and BI projects.
• Must have experience in at least two end-to-end implementations of Snowflake cloud data warehouse and 3 end to end data warehouse implementations.
• Expertise in Snowflake data modeling, ELT using Snowflake SQL, implementing complex stored Procedures and standard DWH and ETL concepts
• Expertise in Snowflake advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning, Zero copy clone, time travel and understanding how to use these features
• Expertise in deploying Snowflake features such as data sharing, events, and lake-house patterns
• Hands-on experience with Snowflake utilities, SnowSQL, SnowPipe, and BigData model techniques using Python
• Experience in Data Migration from RDBMS to Snowflake cloud data warehouse
• Deep understanding of relational as well as NoSQL data stores, methods, and approaches (star and snowflake, dimensional modeling)
• Experience with data security and data access controls and design
• Experience with AWS or Azure data storage and management technologies such as S3 and ADLS
• Build processes supporting data transformation, data structures, metadata, dependency, and workload management • Proficiency in RDBMS, complex SQL, PL/SQL, Unix Shell Scripting, performance tuning, and troubleshooting
• Provide resolution to an extensive range of complicated data pipeline-related problems, proactively and as issues surface • Must have expertise in AWS or Azure Platform as a Service (PAAS).
• Should be able to troubleshoot problems across infrastructure, platform, and application domains.
What you will do?
Will Led a team of Snowflake capability building Architecting, Model design, and Implementing best practices, and standards for Snowflake-based data warehouse, and ETL processing. Work with presales, delivery and client stakeholders in solutions for Snowflake-based data warehouse, including the migration from existing warehouses Thought leader in implementing POC, technology showcasing, and accelerator Coordinate with Snowflake for partnership, build and grow the required technical skills.