Snowflake DBT Developer

VMC Soft Technologies, Inc; Hyderabad; On-site; INR 2,500,000 - 4,000,000; Part time

Job summary

VMC Soft Technologies, Inc. is seeking an experienced Snowflake DBT Developer to design, build, and optimize enterprise data pipelines for Insurance/BFSI domain.

You will work with Snowflake, DBT, DataStage, and advanced SQL to migrate on-prem data warehouses to cloud, tune performance, and implement best practices across the data stack. The role requires 6–10 years in data engineering, hands-on Snowflake/DBT expertise, and experience with DataStage and scheduling tools like Control-M.

Qualifications

• 6–10 years of experience in Data Engineering.
• Strong hands-on expertise in Snowflake Development.
• Strong experience with DBT including Macros, Materializations, Snapshots, Configurations.
• Advanced SQL programming and optimization skills.
• Hands-on experience with IBM DataStage.
• Knowledge of ETL/ELT and Data Warehousing concepts.
• Experience with SnowSQL and Snowflake utilities.
• Experience with Control-M or similar scheduling tools.
• Knowledge of cloud data migration and modernization.
• Excellent analytical and problem-solving skills.

Responsibilities

• Design, develop, and optimize ELT pipelines using Snowflake SQL and DBT.
• Build scalable data transformation models using DBT Macros, Materializations, Snapshots, Seeds, and Configurations.
• Develop SQL queries, stored procedures, and data pipelines in Snowflake.
• Migrate on-premises data warehouses to Snowflake Cloud using DBT and DataStage.
• Work with Snowflake features including Virtual Warehouses, RBAC, Time Travel, Data Sharing.
• Develop and maintain ETL processes using IBM DataStage.
• Monitor and schedule ETL jobs using Control-M or similar tools.
• Collaborate with architects to implement best practices for cloud migration.
• Troubleshoot data pipelines and optimize performance.
• Prepare technical documentation and participate in code reviews.

Skills

Snowflake Development

DBT

IBM DataStage

Advanced SQL

ETL/ELT

SnowSQL

Control-M

Job description

Job Description

We are seeking an experienced

Job Title: Snowflake DBT Developer
Experience: 6 10 Years
Location: Chennai / Hyderabad / Pune
Domain: Insurance (BFSI)
Employment Type: C2H

Job Description

We are seeking an experienced Snowflake DBT Developer with strong expertise in Snowflake, DBT, DataStage, and Advanced SQL. The ideal candidate will be responsible for designing, developing, and optimizing enterprise data pipelines, implementing cloud data warehouse solutions, and supporting large-scale data migration initiatives for the Insurance domain.

Key Responsibilities

• Design, develop, and optimize ELT pipelines using Snowflake SQL and DBT (Data Build Tool).
• Build scalable data transformation models using DBT Macros, Materializations, Snapshots, Seeds, and Configurations.
• Develop complex SQL queries, stored procedures, and data pipelines in Snowflake.
• Migrate and modernize on-premises data warehouses to Snowflake Cloud using DBT and DataStage.
• Work with Snowflake advanced features including:
• Virtual Warehouse sizing
• Resource Monitors
• RBAC (Role-Based Access Control)
• Query Performance Tuning
• Zero Copy Clone
• Time Travel
• Data Sharing
• Develop and maintain ETL processes using IBM DataStage.
• Build data transformation processes, metadata management, dependency management, and workload optimization.
• Monitor and schedule ETL jobs using Control-M or similar scheduling tools.
• Collaborate with architects and technical leads to implement best practices for cloud migration and data engineering.
• Troubleshoot complex data pipeline issues and optimize performance.
• Prepare technical documentation and participate in code reviews.

Mandatory Skills

• 6 10 years of experience in Data Engineering.
• Strong hands-on expertise in Snowflake Development.
• Strong experience with DBT (Data Build Tool) including:
• Macros
• Materializations
• Snapshots
• Configurations
• Advanced SQL programming and optimization skills.
• Hands-on experience with IBM DataStage.
• Strong understanding of ETL/ELT and Data Warehousing concepts.
• Experience with SnowSQL and Snowflake utilities.
• Experience with Control-M or similar job scheduling tools.
• Knowledge of cloud data migration and modernization.
• Excellent analytical and problem-solving skills.

Good to Have

• Experience with Hadoop, Apache Spark, or other Big Data technologies.
• Cloud platform exposure (AWS, Azure, or GCP).
• Experience in the Insurance/BFSI domain.
• Snowflake performance tuning and optimization expertise.
• Knowledge of CI/CD pipelines and Git.
• SnowPro Core and DBT Certification (Preferred).