Senior Data Engineer - Snowflake -DBT

Bootminds; Bengaluru; On-site; INR 2,400,000 - 3,600,000; Full time

Job summary

Bootminds in Bengaluru, Karnataka, India seeks a Senior Data Engineer focused on Snowflake and DBT to design and operate enterprise data pipelines and data warehouses.

You will own data quality, build CI/CD for data products, and collaborate with cross-functional teams to deliver scalable, observable data solutions. Experience with dbt and Informatica PowerCenter is a plus.

Qualifications

• Degree in CS/engineering/math or equivalent experience.
• Extensive experience designing and operating enterprise data pipelines and data warehouses.
• Advanced SQL with Python and/or PySpark for processing and automation.
• Deep Snowflake experience including tuning, security, and workload management.
• Experience with dbt and Informatica PowerCenter for ETL/ELT.
• Hands-on CI/CD for data engineering using Git and automated testing/deployment.
• Strong data profiling, cleansing, and production validation.

Responsibilities

• Design and deliver scalable batch and near-real-time ETL/ELT pipelines using SQL, Python, PySpark on Snowflake.
• Engineer data models, building dimensional/normalized and analytical schemas for reporting.
• Own data quality with automated profiling, checks, reconciliation, freshness, and validation.
• Build CI/CD for data products and deployment pipelines for SQL, dbt, and orchestration code.
• Strengthen observability by monitoring lineage, cost, performance, and SLAs; troubleshoot issues.
• Integrate data from databases, APIs, files, and event sources with secure access patterns.
• Modernize legacy ETL by migrating Informatica PowerCenter to cloud-native patterns.
• Collaborate with stakeholders from requirements to production adoption.
• Lead engineering practices: code reviews, mentoring, and cross-functional delivery.

Skills

Snowflake

DBT

SQL

Python

PySpark

Data modeling

CI/CD

Data quality

Education

Bachelor's degree in Computer Science, Engineering, Mathematics, or related

Master's degree in a related field

Tools

dbt

Informatica PowerCenter

Snowflake

Python

PySpark

SQL

Git

Job description

Senior Data Engineer - Snowflake - DBT

We are seeking a highly skilled Senior Data Engineer with expertise in Snowflake and DBT to join our team in Bengaluru, Karnataka, India. The ideal candidate will have substantial experience in designing and operating enterprise data pipelines and data warehouses, with a strong focus on data quality and automation.

Key Responsibilities

• Design and deliver scalable pipelines, building batch and near-real-time ETL/ELT pipelines using SQL, Python, and PySpark, with Snowflake as the primary cloud data platform.
• Engineer reliable data models, creating dimensional, normalized, and analytical models that support efficient querying, traceability, and reuse across enterprise reporting and analytics.
• Own data quality by design, implementing automated profiling, schema checks, reconciliation, completeness, freshness, uniqueness, and business-rule validation; publish quality results and route failures for action.
• Build CI/CD for data products, creating and maintaining automated build, test, and deployment pipelines for SQL, dbt, orchestration code, and infrastructure configuration.
• Strengthen observability and operations by monitoring pipeline health, lineage, cost, performance, and service-level objectives; troubleshoot incidents and perform root-cause analysis.
• Integrate diverse sources by ingesting and standardizing data from databases, APIs, files, and event sources, applying secure access patterns.
• Modernize legacy workflows by migrating or refactoring Informatica PowerCenter and other legacy ETL processes into maintainable cloud-native patterns.
• Partner from requirement to adoption, translating stakeholder needs into technical designs and validating production outcomes.
• Lead through engineering practice by setting coding and testing standards, reviewing designs and pull requests, mentoring engineers, and coordinating delivery across cross-functional teams.

Requirements

• Bachelor's or master's degree in computer science, engineering, mathematics, or a related discipline, or equivalent practical experience.
• Substantial professional experience designing and operating enterprise data pipelines and data warehouses in production.
• Advanced SQL skills and strong hands‑on experience with Python and/or PySpark for data processing and automation.
• Deep experience with Snowflake, including performance optimization, security, workload management, and scalable data modeling.
• Experience building ETL/ELT solutions with dbt, Informatica PowerCenter, or comparable transformation and integration tools.
• Hands‑on experience implementing CI/CD pipelines for data engineering workloads using Git-based workflows and automated testing/deployment tools.
• Experience building automated data quality systems with measurable rules, alerting, lineage, and issue‑resolution workflows.
• Strong grounding in data profiling, cleansing, standardization, reconciliation, and production data validation.
• Ability to gather ambiguous requirements, make sound design decisions, and communicate effectively with technical and non‑technical partners.

Work Arrangements

• Type: Full-Time
• Location: Bengaluru, Karnataka, India
• Remote: Not specified