Snowflake Technical Consultant

InfoBeans; Chennai District; On-site; INR 1,500,000 - 2,100,000; Full time

Job summary

InfoBeans in India seeks a Snowflake Technical Consultant with 8+ years of hands-on experience to design and implement scalable data warehouse solutions using Snowflake architecture, advanced SQL, data modeling, and warehousing expertise.

You will drive data migration initiatives (Teradata-to-Snowflake), work with Data Vault 2.0, and build pipelines using Azure Data Factory and Databricks while aligning with stakeholders and ensuring performance and quality.

Qualifications

• Hands-on Snowflake architecture, development, and optimization.
• Strong SQL development and data transformation skills.
• Experience with data warehousing concepts and data modeling.
• Experience in solution design and requirement analysis.
• Hands-on data migration experience including Teradata-to-Snowflake migrations.
• Familiarity with Data Vault 2.0 methodologies.
• Proficient with cloud data pipelines and orchestration.
• Effective stakeholder communication and technical consulting.
• Exposure to Azure Data Factory and Databricks.
• Experience with enterprise data architecture.

Responsibilities

• Design and develop scalable Snowflake data warehouse solutions.
• Develop complex SQL queries and data transformations.
• Design enterprise data models and warehouse architecture.
• Translate business requirements into technical solutions.
• Lead and support data migration initiatives, including Teradata-to-Snowflake.
• Apply Data Vault 2.0 methodologies where applicable.
• Develop and maintain data pipelines with ADF and Databricks.
• Perform data validation, reconciliation, performance tuning, and troubleshooting.
• Collaborate with stakeholders, engineers, and architects to deliver data solutions.
• Provide guidance on standards, documentation, and best practices.

Skills

Snowflake Architecture and Development

Advanced SQL

Data Modeling and Data Warehousing

Solution Design & Requirements Analysi

Data Migration

Teradata-to-Snowflake Migration

Data Vault 2.0

Stakeholder Communication

Azure Data Factory (ADF)

Databricks

Tools

Azure Data Factory (ADF)

Databricks

Job description

Job Title: Snowflake Technical Consultant

Experience: 8+ Years

Role: Snowflake Technical Consultant / Senior BI Technical Consultant

Technology: Snowflake

Job Description

We are looking for an experienced Snowflake Technical Consultant with strong expertise in BI tools to design and develop scalable data warehouse solutions. The ideal candidate should have hands‑on experience in Snowflake architecture, advanced SQL, data modeling, data warehousing, and data migration.

Key Responsibilities

• Design and develop scalable Snowflake data warehouse solutions based on business and technical requirements.
• Develop complex and optimized SQL queries, data transformations, and data processing solutions.
• Design enterprise‑level data models and warehouse architecture, ensuring scalability and performance.
• Analyze business requirements and translate them into effective technical solutions.
• Lead and support data migration initiatives, including Teradata-to-Snowflake migration.
• Work with Data Vault 2.0 methodologies for enterprise data modeling where applicable.
• Develop and maintain data pipelines using technologies such as Azure Data Factory (ADF) and Databricks.
• Perform data validation, reconciliation, performance tuning, and troubleshooting during migration and implementation.
• Collaborate with business stakeholders, data engineers, architects, and other technical teams to deliver data solutions.
• Provide technical guidance and contribute to solution architecture, development standards, documentation, and best practices.

Required Skills

• Strong hands‑on experience with Snowflake Architecture and Development.
• Advanced SQL development and query optimization.
• Strong understanding of Data Modeling and Data Warehousing concepts.
• Experience in Solution Design and Requirements Analysis.
• Hands‑on experience with Data Migration projects.
• Strong stakeholder communication and technical consulting skills.
• Experience with Data Vault 2.0.
• Experience with Azure Data Factory (ADF).
• Experience with Databricks.
• Strong experience in Teradata‑to‑Snowflake migration is highly preferred.
• Good understanding of data integration, data quality, performance tuning, and enterprise data architecture.