Snowflake

Responsibilities

Design, develop, and maintain data pipelines using Snowflake and dbt.

Build and optimize ELT processes for large-scale data ingestion and transformation.

Develop reusable dbt models, macros, tests, and documentation.

Design dimensional and data warehouse models (Star Schema, Snowflake Schema).

Optimize Snowflake performance, query tuning, clustering, and cost management.

Implement data quality checks, monitoring, and governance standards.

Collaborate with business stakeholders, data analysts, and BI teams to gather requirements.

Integrate data from multiple sources such as APIs, databases, and cloud storage.

Support CI/CD implementation for dbt projects using Git and deployment tools.

Troubleshoot and resolve data pipeline and performance issues.

Required Skills

3+ years of experience in Data Engineering/Data Warehousing.

Strong hands-on experience with Snowflake.

Experience with dbt (Data Build Tool) development and deployment.

Advanced SQL development and query optimization.

Knowledge of ETL/ELT concepts and best practices.

Experience with cloud platforms such as AWS, Azure, or GCP.

Understanding of data modeling techniques and data warehouse design.

Experience with version control tools like Git.

Knowledge of scheduling/orchestration tools such as Airflow, ADF, or Prefect.

Strong analytical and problem-solving skills.

Preferred Skills

Snowflake Certifications.

Experience with Python for data engineering tasks.

Exposure to BI tools such as Power BI, Tableau, or Looker.

Experience with DevOps, CI/CD pipelines, and Infrastructure as Code.

Knowledge of Data Governance and Data Quality frameworks.

Technical requirements

Primary skills:Technology->Data on Cloud-DataStore->Snowflake

Education

MCA,MSc,MTech,BCA,BSc,BTech