JC– Teradata, Snowflake – Architect

Skills:

Snowflake Architect

Exp: 10+ Yrs Must

Location:

Chennai/Pune/Mumbai/Bangalore

GCM 4

• Serve as the primary SME, developing and documenting a comprehensive, end-to-end migration strategy from Teradata to Snowflake, including phased approaches (e.g., lift-and-shift, re-platforming, modernization).
• Conduct detailed assessments of the existing Teradata environment (e.g., schemas, data models, stored procedures, ETL/ELT logic, BTEQ scripts, performance tuning, and security) to determine migration complexity.
• Define the target state architecture in Snowflake, leveraging its unique capabilities (e.g., virtual warehouses, clustering, Snowpipe, data sharing, time travel, semi-structured data handling).

• Lead the conversion of complex Teradata SQL, stored procedures, functions, and utilities (e.g., BTEQ, TPT, MLOAD, FLOAD) to equivalent Snowflake SQL and procedures (e.g., SnowSQL, Tasks, Streams, Snowpipe, Python/Snowpark).
• Design and oversee the data migration process, ensuring data integrity, accuracy, and performance using various tools and methodologies (e.g., ETL/ELT, cloud storage staging, Snowpipe).
• Collaborate with Data Engineers, Data Architects, and BI teams to redesign and optimize data models (Dimensional, Data Vault, etc.) for the Snowflake platform.

• Translate and apply Teradata performance tuning concepts (e.g., Primary Index, Secondary Index, PPI, Join Strategies) to Snowflake optimization techniques (e.g., micro-partitions, clustering keys, query optimization, and virtual warehouse sizing).
• Conduct rigorous performance testing and validation in Snowflake against Teradata benchmarks to ensure superior or equivalent query response times.

• Define and implement Snowflake security, governance, and access control (RBAC) models that map effectively to the existing Teradata security structure.
• Mentor and enable existing team members on Snowflake best practices, development standards, and operations.

• 10+ years of extensive experience in Data Warehousing, with 7+ years as a Teradata SME/Architect.
• Mandatory:
  Proven, hands-on experience leading and delivering at least one full-cycle Teradata to Snowflake migration projects.
• Deep Teradata Expertise:
  Mastery of Teradata architecture (AMPs, PE, BYNET), physical data modeling, performance tuning, Teradata SQL, stored procedures, and utilities (TPT, BTEQ).
• Exceptional Snowflake Proficiency:
  Expert-level knowledge of Snowflake architecture (Cloud Services, Compute, Storage layers), advanced features, SnowSQL, Snowpipe, Streams, Tasks, and performance optimization in a cloud environment (AWS, Azure, or GCP).
• Strong scripting skills in at least one language (e.g., Python, Shell, or Java) for automation and ETL/ELT processes.
• Experience utilizing automated migration tools (e.g., Snow Convert, Next Pathway SHIFT).
• Excellent communication, presentation, and stakeholder management skills, with the ability to articulate complex technical concepts to both technical and non-technical audiences.

• Snowflake Certifications (e.g., Snow Pro Advanced Architect, Snow Pro Core).
• Experience with modern ETL/ELT tools that integrate with both Teradata and Snowflake (e.g., Informatica, Talend, Matillion, or Fivetran).
• Familiarity with cloud platforms (AWS, Azure, or GCP) for setting up networking, storage (S3, ADLS, GCS), and security for Snowflake environments.
• Experience with BI tools and how they connect to and are impacted by the migration from Teradata to Snowflake.