Technical Architect - AWS / SnowFlake

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