17 Nov
|
atsMantra®
|
Hyderabad
17 Nov
atsMantra®
Hyderabad
We are looking for a hands-on Snowflake DBT Data Engineer with strong expertise in Snowflake and dbt to design, develop, and implement scalable, high-performance data solutions. The ideal candidate should have solid experience in SQL, data modeling, ELT pipeline development, and cloud data warehousing, with a focus on building efficient and reliable data pipelines.
Key Responsibilities
• Design, develop, and maintain scalable data warehouse solutions using Snowflake.
• Build and manage data transformation workflows using dbt (Data Build Tool).
• Develop, implement, and optimize ELT pipelines for integrating data from multiple sources into Snowflake.
• Write complex SQL queries, stored procedures, views, and data transformations.
• Develop and maintain dbt models, macros, snapshots, tests, and incremental models.
• Implement data quality checks, validation, and automated testing using dbt.
• Perform Snowflake query performance tuning and optimize warehouse utilization and compute costs.
• Work on data modeling techniques, including dimensional modeling (Star and Snowflake schemas).
• Develop Python scripts for data processing, automation, and integration.
• Work with Apache Airflow for workflow orchestration and pipeline scheduling.
• Support data migration initiatives from legacy data platforms to Snowflake.
• Follow coding standards, version control, and CI/CD best practices.
• Collaborate with solution architects, business analysts, and cross-functional teams to deliver data engineering solutions. Mandatory Skills
• Strong hands-on experience with Snowflake.
• Practical development experience with dbt (Data Build Tool).
• Strong expertise in SQL and complex query development.
• Experience in data modeling, data warehousing, and ELT pipeline development.
• Positive understanding of Snowflake architecture, performance tuning, and cost optimization.
• Experience with Python for data engineering.
• Exposure to Apache Airflow or similar workflow orchestration tools. Good to Have
• Experience with Snowpark.
• Exposure to AWS / Azure / GCP cloud services.
• Experience in migrating legacy data platforms to Snowflake.
• Knowledge of Git, CI/CD, and automated deployment practices.
• Experience working in Agile development environments.
📌 Data Engineer (Hyderabad)
🏢 atsMantra®
📍 Hyderabad