Technical Architect -SnowFlake Job

Experience

12+ Years

Job Description

Must have total 12+ yrs. in IT and 3+ years experience working as a AWS/snowflake Data Architect and 8+ years in Data warehouse, ETL, BI projects. Should have Strong written and communication skills.

Snowflake Responsibilities:

Must have experience at least two end-to-end implementation of Snowflake cloud data warehouse.
Expertise in Snowflake data modelling, ELT using Snowflake SQL, implementing complex stored procedures and standard DWH and ETL concepts.
Expertise in deploying Snowflake features such as data sharing, events, and lake-house patterns.
Hands-on experience with Snowflake utilities, Snow SQL, Snow Pipe, Big Data model techniques using Python.
Experience in Data Migration from RDBMS to Snowflake cloud data warehouse
Proficiency in RDBMS, complex SQL, PL/SQL, Unix Shell Scripting, performance tuning and troubleshoot.

AWS Responsibilities:

Design and implement scalable, secure, and reliable cloud solutions on the AWS platform
Develop and maintain architectural diagrams, documentation, and best practices
Provision, configure, and maintain AWS infrastructure using services such as EC2, S3, VPC, Lambda, and others
Implement and manage infrastructure as code (IaC) using tools like AWS CloudFormation or Terraform
Implement security best practices in AWS environments, including identity and access management, encryption, and network security
Ensure compliance with relevant industry standards and regulations
Optimize AWS resources for cost efficiency, scalability, and performance
Conduct regular assessments and implement improvements to enhance system performance
Lead the migration of on-premises systems to AWS, ensuring a smooth transition
Integrate AWS services with existing systems and applications
Implement monitoring solutions to proactively identify and address issues
Troubleshoot and resolve technical problems, collaborating with support teams as needed
Collaborate with cross-functional teams, including developers, operations, and business stakeholders
Provide technical guidance and support to teams using AWS services

Required Technical Competencies

Solution Design:

• Manages solution design projects, ensures best practices are being followed.
• Able to develops solution designs for complex solutions.

Emerging Technologies:

• Manages emerging technology projects, ensures best practices are being followed.
• Develops and implements emerging technology strategies that support the organization's strategic objectives.

Architecture tools and frameworks:

• Familiarity with industry tools and frameworks and ability to analyse and use them based on customer requirements.
• Work with SMEs to explore new tools and frameworks for implementation.

Architecture Concepts and Principles:

• Provides deep subject matter expertise, advice for the program delivery.
• Contributes to the development of new techniques and plans within area of expertise.
• Establish Architectural principles & patterns.
• Conduct technical & design reviews.
• Use advanced tools to capture and analyse system / technical issues.

Technology/Product Knowledge:

• Implement code or configure/customize products, drive adoption of industry standards and practices, and contribute to development of reusable assets and innovative solutions.
• Work on complex modules independently.
• Analyse various frameworks/tools and present recommendations, contribute to development of training and certification material, and demonstrate thought leadership through whitepapers and webinars.

Application Design:

• Mastery of design principles and performance engineering concepts
• Lead design efforts, creating a design strategy, and establishing design principles and guidelines while maintaining the design standards and best practices.
• Identify and mitigate design risks, proactively anticipate issues, and recommend corrective steps.
• Innovate and bring in new design ideas, improve existing design processes, and tools.

Estimation and Resource Planning:

• Good Understanding of estimation and resource planning techniques, such as the WBS model.
• Identify the resources required to complete a task and use appropriate estimation models for low to medium complexity scenarios.