Technical Architect - Snowflake

Role: Technical Architect - Snowflake

Experience: 8+ Years

Location: Bangalore (Hybrid)

About Us: Relanto.ai is a cutting-edge IT services company at the forefront of revolutionizing business operations through Intelligent Automation, Digital Transformation, and harnessing the power of Data and AI. Our passion lies in creating solutions that empower businesses to achieve unprecedented efficiency, innovation, and growth.

What would you do:

• Successfully complete complex technical projects and create high-level design and architecture, including class, sequence, and deployment infrastructure diagrams.
• Take ownership of technical solutions from a design and architecture perspective in presales and ongoing projects.
• Gather end user requirements and produce technical documentation.
• Manage time effectively, multitask, and meet deadlines, especially under time-to-market pressure.
• Propose innovative solutions based on new technologies and trends to the sales team.
• Review and ensure the right choice of architectural and technological solutions for ongoing projects.
• Collaborate with the sales team and clients to understand business needs, capture requirements, and propose ideal solutions to win business.

You would be a great fit if you have :

• Minimum of 8+ years in IT, with 3+ years as a Snowflake Data Architect and 6+ years in Data warehouse, ETL, and BI projects.
• Expertise in Snowflake, including data modeling, ELT using Snowflake SQL, complex stored procedure implementation, and standard DWH and ETL concepts.
• Proficiency in advanced Snowflake concepts, such as resource monitoring, RBAC controls, virtual warehouse sizing, query performance tuning, zero copy clone, and time travel.
• Deploy Snowflake features, including data sharing, events, and lake-house patterns.
• Hands-on experience with Snowflake utilities, Snow SQL, Snow Pipe, and Big Data modeling with Python.
• Experience in Data Migration from RDBMS to Snowflake cloud data warehouse.
• Deep understanding of relational and NoSQL data stores, star and snowflake dimensional modeling.
• Proficiency in RDBMS, complex SQL, PL/SQL, Unix Shell Scripting, performance tuning, and troubleshooting.
• Resolve complex data pipeline-related problems proactively.
• Expertise in Azure Platform as a Service (PAAS).
• Certification as a Snowflake cloud data warehouse Architect is desirable.
• Troubleshoot problems across infrastructure, platform, and application domains.
• Experience with Agile development methodologies.
• Strong written and oral communication skills.

Added advantage:

• Architect level certification from AWS, Azure, or GCP.
• Experience in Snowflake Practice/COE.
• Data Science and AI/ML implementation