Greetings from TCS!
Job Title: Snowflake Architect
Walkin Date: 25th July 26
Walkin Location: Tata Consultancy Services Ltd, 415/21-24, Old Mahabalipuram Road, Kumaran Nagar, Sholinganallur, Chennai
Walkin Time: 9am-1pm
Experience Range: 8-15 yrs
Job description:
TCS has always been in the spotlight for being adept in the next big technologies. What we can offer you is a space to explore varied technologies and quench your techie soul.
Key Responsibilities
- 8+ years of overall experience in architecting and building data and analytics solutions including data modeling, ETL/ELT pipelines and performance optimization.
- Deep knowledge of Snowflake features such as virtual warehouses, micro-partitions, data sharing and security best practices.
- Strong SQL skills for complex queries, stored procedures, and optimization; familiarity with Python or other scripting languages for automation.
- Hands-on experience with Azure and/or AWS services (e.g., S3, Azure Data Lake, IAM, networking) for hybrid or multi-cloud architectures.
- Expertise in implementing role-based access control, encryption, compliance standards and auditing within Snowflake and cloud environments.
- Ability to optimize compute/storage costs, manage workloads, and tune queries for high performance.
- SnowPro Core or Advanced Architect certification is a strong plus.
- Ability to lead architecture discussions, mentor teams and collaborate with business and technical stakeholders
- Excellent communication, presentation, and interpersonal skills
- Experienced in working in a customer-facing role
- Conduct workshops with business and IT stakeholders to capture, document and summarize data, integration and analytics requirements for the Snowflake.
- Design optimized data models and schemas
- Integrate Snowflake with multiple data sources and platforms (on prem DBs, files, APIs, Azure/AWS services, Kafka/ETL tools) ensuring secure, reliable data ingestion and curation.
- Establish governance and security standards—RBAC, network policies, SSO/MFA, data classification, masking and secure data sharing across accounts/partners.
- Optimize performance and cost by tuning virtual warehouses, managing micro partitions/clustering, caching, query profiling and workload isolation for concurrency and throughput.
- Guide the technical team on architecture patterns and migration approaches (zero copy cloning, Time Travel, Fail safe) and oversee implementation to production readiness.
- Conduct proofs of concept and create reusable accelerators and reference architectures.
- Guide technical team of deliverables and get the solution implemented
- Conduct proof of concepts and create differentiating assets
- Conduct training and workshops on new technologies and trends
Minimum Qualification: 15 years of full-time education
