Senior Software Development Engineer in Test - Database Automation

Fivetran; Oakland (CA); Hybrid; USD 42,000 - 63,000; Full time

Benefits offered by this job

100% employer-paid medical insurance

Generous PTO, sick time, parentalLeave

RSU stock grants

Professional development

Team-building activities

Monthly cell phone stipend

Mental health support platform access

Job summary

Fivetran in Bengaluru, India, is seeking a Senior SDET to define and run automation for our data integration platform. You will design scalable Java-based test frameworks, improve CI/CD, and lead QA efforts with a focus on reliability and data correctness.

You will mentor quality engineers, build AI-assisted tooling to accelerate testing, and collaborate with product and engineering to ensure high standards across ELT pipelines and databases.

Qualifications

• 6+ years in software with a focus on quality and automation.
• Proficiency in Java and OOP.
• Experience designing scalable automation frameworks and identifying edge and high-risk scenarios.
• Strong understanding of distributed systems risks (schema drift, idempotency, data inconsistencies).
• Hands-on experience with cloud platforms (AWS, GCP, Azure) and containerized environments.
• Experience building CI/CD pipelines with Jenkins, Buildkite.
• Experience with backend automation frameworks.
• Experience testing data pipelines/ELT platforms and validating data accuracy at scale.
• Able to leverage AI/LLM tools to accelerate development, debugging, and test design.
• Experience building AI-assisted tools integrated into pipelines.

Responsibilities

• Review requirements, specifications and design documents to provide feedback.
• Design and evolve scalable automation frameworks in Java with reliability and performance focus.
• Write high-signal test strategies and automate them across multiple environments.
• Improve CI/CD pipelines with robust validation layers to prevent silent failures.
• Build internal AI-powered tools to accelerate debugging and generate test scenarios.
• Design AI-assisted workflows integrated into automation and release pipelines.
• Experiment with agent-based systems or LLM-powered tooling to streamline development.
• Measure engineering impact through reliability metrics and automation efficiency.
• Collaborate with engineering teams to promote quality ownership and automation-first thinking.
• Collaborate with leadership to align testing priorities with business objectives.

Skills

Java

OOP

CI/CD

Cloud: AWS/GCP/Azure

Docker

Kubernetes

Terraform

Buildkite

ELT pipelines

SQL/NoSQL

Tools

Docker

Kubernetes

Terraform

Bazel

Buildkite

Job description

Bengaluru, Karnataka, India, APAC

Position Title: Senior Software Development Engineer in Test - Database Automation

From Fivetrans founding until now, our mission has remained the same: to make access to data as simple and reliable as electricity. With Fivetran, customer data arrives in their warehouses, canonical and ready to query, with no engineering or maintenance required. Were proud that more organizations continue to leverage our technology every day to become truly data-driven.

About Us

Fivetran and dbt Labs are bringing together two industry-leading companies with a shared mission: helping organizations unlock the full value of their data.

Together, were delivering the data infrastructure layer that helps organizations move, transform, and trust their data from the moment data moves, through every transformation, to the context teams and AI systems rely on.

Fivetran helps organizations automate data movement across the systems, clouds, engines, and tools they rely on. dbt Labs pioneered analytics engineering, helping teams transform data into reliable, governed insights. Together, we support thousands of organizations as they build a trusted foundation for analytics, AI, and better business decisions.

As we bring our teams and technology together, were building on the strengths of both companies while continuing to deliver the products and experiences our customers know and trust. its an exciting time to join us: were creating a company with the scale, talent, and technology to help more organizations put their data to work with greater speed, confidence, and impact.

During this transition period, you may see references to both Fivetran and dbt Labs throughout our recruiting process as we integrate our teams, systems, and career sites.

About the Role

Fivetran is building data pipelines to power the modern data stack for thousands of companies.

Were looking for a Senior Software Development Engineer in Test with extensive industry experience to define and execute the design, development, and maintenance of Fivetrans test automation tools and framework using reliable and scalable techniques.

As a Senior SDET, you will focus on solving complex testing difficulties by designing, developing and improving automation and reporting frameworks. You will invest in improving test stability and performance of the framework by developing innovative solutions to boost Fivetrans testing efficiency. You will also coach Fivetran quality engineers to be the best in class automation engineers, and will continuously work with the team to ensure high standards for automation. The ideal candidate will be highly technical, detail-oriented, creative, motivated, and focused on achieving results.

In addition, this role emphasizes leveraging AI driven solutions to accelerate testing, enhance developer productivity, and improve operational insights, making Fivetrans quality practices smarter, faster, and more scalable.

This is a full-time position based out of our Bangalore office. Our hybrid work model offers a blend of remote flexibility and in-person collaboration, including two days in the office each week to connect and build as a team.

Technologies You’ll Use

• Languages & Frameworks: Java (17+), JUnit, REST Assured, Shell scripting; Python
• Infrastructure & Tooling: Docker, Kubernetes, Terraform, Bazel, Buildkite
• Cloud & Platform: AWS, GCP, Azure
• Observability & Monitoring: Grafana, Prometheus, Datadog
• CI/CD & Automation: Jenkins, CircleCI, GitHub Actions
• Data & Testing:ELT pipelines, test automation utilities, whitebox testing strategies
• Databases: SQL and NoSQL databases (e.g., Postgres, SAP , Oracle, DB2 ertc)

What You’ll Do

• Review requirements, specifications and technical design documents to provide meaningful, risk-focused feedback.
• Design and evolve scalable automation frameworks in Java with a strong emphasis on reliability, performance, and data correctness.
• Write high-signal test strategies for complex features and automate them across multiple environments.
• Improve CI/CD pipelines by building robust validation layers that prevent silent failures and regressions.
  • Build internal tools and proof-of-concepts using AI/LLM technologies to:
  • Accelerate debugging and failure triaging
  • Generate high-quality test scenarios
  • Detect flaky patterns or regression risks
  • Improve log analysis and root-cause identification
  • Enhance developer and QA productivity
• Design AI-assisted workflows that integrate seamlessly into the existing automation and release pipelines.
• Experiment with and implement agent-based systems or LLM-powered tooling that streamline development and testing processes.
• Actively measure and improve engineering impact through reliability metrics, automation efficiency, and defect prevention signals.
• Collaborate with engineering teams to drive a culture of quality ownership and automation-first thinking.
• Collaborate with engineering and product leaders to align testing priorities and business objectives.

Skills Were Looking For

• 6+ years of experience in the software industry with strong passion for quality, automation, and engineering excellence.
• Deep understanding of OOP principles and strong proficiency in Java.
• Expertise in designing scalable automation frameworks and identifying negative, edge, and high-risk scenarios.
• Strong understanding of distributed systems risks such as schema drift, idempotency failures, data inconsistencies, and race conditions.
• Hands-on experience with cloud platforms (AWS, GCP, Azure) and containerized environments (Docker, Kubernetes).
• Experience building and maintaining CI/CD pipelines with tools such as Jenkins, Buildkite.
• Experience working with backend automation frameworks.
• Testing data pipeline or ELT platforms, with hands-on exposure to Change Data Capture (CDC) mechanisms, connector-based data ingestion, and validating data accuracy and consistency across source and destination systems at scale.
• Deep understanding of database internals
• Demonstrated ability to leverage AI/LLM tools to significantly accelerate development, debugging, test design or automation activities.
• Experience building AI-assisted tools, workflows, or agents that integrate into engineering pipelines.

Bonus Skills

• Experience testing against cloud data warehouses (Snowflake, BigQuery, Redshift) or CDC source databases (Oracle, SQL Server, PostgreSQL, MySQL)
• Familiarity with log-based CDC mechanisms (binlog, WAL, ) and handling schema drift or evolution scenarios.
• Exposure to distributed systems testing, large-scale data reconciliation, and containerized environments (Docker, Kubernetes) on cloud platforms (AWS/GCP/Azure).
• Familiarity with data extraction using API-based polling, batch/file ingestion, and query-based incremental syncs.

#LI-HYBRID

#LI-VM1

Perks and Benefits

• 100% employer-paid medical insurance*
• Generous paid time-off policy (PTO), plus paid sick time, inclusive parental leave policy, holidays (including a year end Global Week of Rest), and volunteer days off
• RSU stock grants*
• Professional development and training opportunities
• Company virtual happy hours, free food, and fun team-building activities
• Monthly cell phone stipend
• Access to an innovative mental health support platform that offers personalized care and resources in areas such as: therapy, coaching, and self-guided mindfulness exercises for all covered employees and their covered dependents.

*May vary by country and worker type - please reach out to your recruiter for more information

We value and recognize that our customers benefit from having innovative teams made of people from many backgrounds, experiences, and identities. Fivetran promotes diversity, equity, inclusion & belonging through attracting, recruiting, developing, and retaining a diverse workforce, not only because it is the right thing to do, but because it helps us build a world-class company to better serve our customers, our people and our communities.

To learn more about our candidate privacy policy, you can read our statement here.

We are committed to ensuring that all candidates have an equal opportunity to participate in our interview process. If you require accommodations at any stage of the process due to a disability, medical condition, or any other circumstance, please don't hesitate to submit your request by filling out this form. We will work with you to provide reasonable accommodations to facilitate your participation and ensure a fair and accessible interview experience. Your request and any information provided will be kept confidential and will not impact your candidacy. We look forward to hearing from you and accommodating your needs to the best of our ability.

Equal Opportunity Employer, including disability/protected veterans

Equal employment opportunity, including veterans and individuals with disabilities.