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
- Solid 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.
- Good 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