Senior Data Engineer (Senior Individual Contributor / Technical Lead)

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

Job summary

Bootminds in Bengaluru, Karnataka, India is seeking a Senior Data Engineer to design and operate enterprise data pipelines and data warehouses with a focus on performance and data quality.

The role entails building batch and near-real-time ETL/ELT with SQL, Python and PySpark on Snowflake, implementing CI/CD for data products, expanding data modeling, quality checks and observability, and collaborating with cross-functional teams.

Qualifications

• Bachelor's or master's degree in computer science, engineering, mathematics or related discipline, or equivalent practical experience.
• Substantial experience designing and operating enterprise data pipelines and data warehouses in production.
• Advanced SQL skills and hands-on Python and/or PySpark for data processing.
• Deep experience with Snowflake including performance optimization and scalable data modeling.
• Experience with dbt, Informatica PowerCenter or comparable tools.
• CI/CD pipelines for data engineering with Git-based workflows and automated testing/deployment.

Responsibilities

• Design and deliver scalable pipelines using SQL, Python and PySpark, with Snowflake as the primary platform.
• Engineer reliable data models to support enterprise reporting and analytics.
• Own data quality with automated profiling, schema checks and lineage.
• Build CI/CD for data products and manage version control and deployment.

Skills

SQL

Python

PySpark

Snowflake

dbt

Informatica PowerCenter

CI/CD

Data quality

Data profiling

Data modeling

Education

Bachelor's or Master's in CS/Engineering/Math

Tools

dbt

Git

Airflow

Job description

Senior Data Engineer (Senior Individual Contributor / Technical Lead)

We are seeking a highly skilled Senior Data Engineer 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 performance optimization and data quality.

Key Responsibilities

• Design and deliver scalable pipelines. Build batch and near-real-time ETL/ELT pipelines using SQL, Python and PySpark, with Snowflake as a primary cloud data platform.
• Engineer reliable data models. Create dimensional, normalized and analytical models that support efficient querying, traceability and reuse across enterprise reporting and analytics.
• Own data quality by design. Implement 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. Create and maintain automated build, test and deployment pipelines for SQL, dbt, orchestration code and infrastructure configuration, including version control, peer review, environment promotion and safe rollback.
• Strengthen observability and operations. Monitor pipeline health, lineage, cost, performance and service-level objectives; troubleshoot incidents, perform root-cause analysis and eliminate recurring manual support.
• Integrate diverse sources. Ingest and standardize data from databases, APIs, files and event sources, applying secure access patterns and appropriate handling for sensitive information.
• Modernize legacy workflows. Migrate or refactor Informatica PowerCenter and other legacy ETL processes into maintainable cloud-native patterns using tools such as dbt and modern orchestration platforms.
• Partner from requirement to adoption. Translate stakeholder needs into technical designs, validate production outcomes and communicate tradeoffs, risks and delivery progress clearly.
• Lead through engineering practice. Set coding and testing standards, review designs and pull requests, mentor engineers and coordinate 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