Snowflake Developer

Job Title: Snowflake Developer (with PL SQL)

Experience: 4+ Years

Location: Bangalore, Hyderabad, Pune

About us:

Relanto is an international consulting and technology firm specializing in real-time planning and decision-making solutions using Advanced Analytics and AI. Our proven expertise in Integrated Planning Solutions enables business leaders to make fast and accurate decisions using connected platforms. We combine the power of integrated planning platforms with Advanced Analytics, AI/ML-based forecasting, and optimization solutions to improve its effectiveness.

Our work environment is fun and exciting, and we encourage our associates to think differently, learn, innovate, and challenge the status quo. If you are passionate about a collective learning culture and are part of a team crafting the NextGen planning solutions re-imagined with Advanced Analytics and AI/ML, you will be proud to be part of Relanto.

Primary Skills

• PL SQL and Snowflake

Key Accountability:

• Demonstrated ability to have successfully completed multiple, complex technical projects and create high-level design and architecture of the solution, including class, sequence, and deployment infrastructure diagrams.
• Experience with gathering end-user requirements and writing technical documentation.
• Time management and multitasking skills to effectively meet deadlines under time-to-market pressure.
• Suggest innovative solutions based on new technologies and the latest trends to the sales team.
• Review the architectural/ technological solutions for ongoing projects and ensure the right choice of solution.
• Work closely with sales team and clients to understand their business, capture requirements, identify pain areas, accordingly, propose an ideal solution, and win business.

Key Competencies:

• Expertise in Snowflake – data modelling, 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 deploying Snowflake features such as data sharing, events, and lake-house patterns.
• Hands-on experience with Snowflake utilities, Snow SQL, Snow Pipe, and Big Data 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)
• 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.
• 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.
• Should be able to troubleshoot problems across infrastructure, platform, and application domains.
• Must have experience with Agile development methodologies.
• Strong written and communication skills.
• Effective and persuasive in both written and oral communication.

Seniority Level

• Mid-Senior level

Industry

• Business Consulting and ServicesSoftware DevelopmentIT Services and IT Consulting

Employment Type

• Full-time

Job Functions

• Information Technology