Snowflake DBT Engineer total years of experience- 7+ yearsLocation- Pune/Mumbai/Chennai/BangaloreMandatory Skills:Snowflake- 6 yearsDBT-6 yearsPython-3 yearsAirflow:2 yearsAzure cloud exp is good to have5+ years of working experience in Snowflake, Databricks, DBT and Python on Azure/GCP/AWS in production environments and hands-on experience in developing moderate to complex ETL/ELT data pipelinesStrong in Apache Spark and Delta Lake, strong SQL and Python abilities, experience with data engineering and ETL pipelinesAdvanced SQL in Snowflake (CTEs, Views, UDFs, Materialized Views) & DBTPartitioning, clustering, and performance tuning in SnowflakeStreams, Tasks, and Snowpipe for real-time and incremental data pipelinesCost and query optimization (e.g., using result cache, pruning, compute credits control)DBT-Data Modeling, SQL Mastery,Jinja Templating, Workflow Optimization & Configuration, Data Loading and CleaningHands on Python3+ years of hands-on experience with Cloud Composer (Airflow) developing DAGs3+ years of hands-on experience with Databricks and the ability to resolve complex SQL query performance issues4+ years of ETL Python development experience; experience parallelizing pipelines a plusDemonstrated ability to troubleshoot complex query, pipeline, and data quality issuesDevelop, test, and deploy robust ETL pipelines on Snowflake on MS Azure/AWS/GCP Platform using, but not limited to, Snowflake/dbt/Databricks, Cloud Composer, and Cloud Run to ingest structured/unstructured data from on-prem SQL Server instances into Snowflake Models/Database/SchemaImplement data validation checks, error handling, and logging to ensure pipeline reliabilityAutomate deployment workflows using CI/CD pipelines (GitHub Actions, etc.) and infrastructure-as-code (IaC) toolsMonitor pipelines via Cloud Logging and Cloud Monitoring, implementing alerting for data latency or quality issues
Job Title
Data Engineer