> Markdown version of [/jobs/ext/2536748-senior-software-development-engineer-in-test-database-automation](https://www.wearedevelopers.com/jobs/ext/2536748-senior-software-development-engineer-in-test-database-automation). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Senior Software Development Engineer in Test - Database Automation - **Company:** Fivetran - **Location:** Oakland, CA, United States - **Experience:** Expert - **Salary:** $72,800.0 - $95,680.0 - **Contract:** Permanent contract - **Skills:** Java (Programming Language), Artificial Intelligence, Amazon Web Services, Automation of Tests, Microsoft Azure, Big Data, BigQuery, Cloud Computing, Cloud Database, Databases, Continuous Integration, Data Mining, IBM DB2, Software Debugging, Distributed Systems, Github, White-Box Testing, Monitoring of Systems, Junit, Python (Programming Language), PostgreSQL, Log Analysis, Microsoft SQL Server, MySQL, Regression Analysis, NoSQL, Oracle (Applications), Prometheus, Oop Languages, SAP (Applications), Shell Script, Software Engineering, SQL Databases, Strategies of Testing, Datadog, Circleci, Google Cloud, Data Ingestion, Delivery Pipeline, Large Language Models, Snowflake, Grafana, Change Data Capture, Backend, Containerization, Kubernetes, Api Design, Terraform, Data Inconsistencies, Data Pipelines, Docker, SDET, Jenkins, Amazon Redshift, Programming Languages - **Published:** August 22, 2026 - **Apply:** https://www.jofdav.com/jobs/59360015-senior-software-development-engineer-in-test-database-automation ## About the Role * 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. ## Description 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 Youll 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 Youll 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., 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. ## Related Videos - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [Leveraging Real time data in FSIs](https://www.wearedevelopers.com/videos/806-leveraging-real-time-data-in-fsis) - [MySQL Protocol Features You Should Be Aware Of](https://www.wearedevelopers.com/videos/100267-mysql-protocol-features-you-should-be-aware-of) - [Continuous testing - run automated tests for every change!](https://www.wearedevelopers.com/videos/190-continuous-testing-run-automated-tests-for-every-change) - [NoSQL Data Modeling for Front-end Developers](https://www.wearedevelopers.com/videos/297-nosql-data-modeling-for-front-end-developers) - [Coding for Good: Achieving social change with an app](https://www.wearedevelopers.com/videos/1645-coding-for-good-achieving-social-change-with-an-app) ## Related Articles - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [The 8 Best Code Testing Tools](https://www.wearedevelopers.com/magazine/402-the-8-best-code-testing-tools) - [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again) - [Dev Digest 120 - Apple and peers](https://www.wearedevelopers.com/magazine/455-dev-digest-120-apple-and-peers) - [Résumé-Driven Development: How IT trends affect the job market for software developers](https://www.wearedevelopers.com/magazine/59-resume-driven-development-how-it-trends-affect-the-job-market-for-software-developers) - [Dev Digest 121 - AI goes offline](https://www.wearedevelopers.com/magazine/456-dev-digest-121-ai-goes-offline)