snowflake architect

Roles and Responsibilities :

• Design and develop data pipelines using Cortex, ETL processes to extract, transform, and load data from various sources into a centralized repository.
• Collaborate with cross-functional teams to identify business requirements and design solutions that meet those needs.
• Develop complex SQL queries to optimize database performance and troubleshoot issues.
• Ensure high-quality delivery of projects by testing, debugging, and deploying code in production environments.

Job Requirements :

• 10-15 years of experience in software development with expertise in Cortex, ETL tools (e.g., Informatica PowerCenter), and SQL programming language.
• Strong understanding of Linux operating system administration principles.
• Experience working on large-scale enterprise applications with multiple stakeholders.
• Deep understanding of Snowflake's unique architecture (separation of storage and compute) and features.
• Hands-on experience with Snowflake and SQL, including query optimization.
• Participate in design discussions with architects, security teams, and development teams.
• Design and implement scalable Snowflake data architecture solutions.
• Ensure Snowflake solutions are secure, scalable, and resilient, following Snowflake solutions to compliance standards.
• Define data models, schemas, and ETL/ELT pipelines for structured and semi-structured data
• Knowledge of data warehousing and ETL/ELT
• Familiarity with cloud platforms (AWS, Azure, or GCP) and Snowflake integrations
• Knowledge of DevOps and CI/CD practices for data pipelines and workflows
• Experience in data engineering or database development, particularly with data migrations
• Strong expertise in Snowflake administration (user management, warehouses, roles, resource monitors, Replication, and disaster recovery process.
• Knowledge of Snowflake features: Time Travel, Cloning, Micro-partitions, Streams & Tasks.
• Good understanding of private connectivity, network rules and policies, authentications etc
• Hands on experience in Snowflake features like external stages, snowpipe, storage integration, File Formats, RBAC etc
• Proficiency in Scripting skills in Python, Shell, or PowerShell for automating regular administrative or repeating task.
• Good understanding of various cost incurred in Snowflake.
• Experience with ETL processes and data integration workflows.
• Strong problem-solving and analytical skills.