Senior Database Test Engineer – Automation

SDETSDETFull TimeRemoteTeam 10,001+Since 1843H1B No SponsorCompany SiteLinkedIn

Location

Colorado

Posted

4 days ago

Salary

$90K - $162K / year

Bachelor DegreeEnglishETLMy SQLSQL

Job Description

• Design, develop, and execute test cases for database objects including stored procedures, functions, triggers, and views • Validate business logic and complex calculations implemented in stored procedures • Perform ETL pipeline testing to ensure accurate data extraction, transformation, and loading • Validate data across source, staging, and target systems for completeness, accuracy, and consistency • Conduct data reconciliation using row counts, aggregates, and field-level comparisons • Identify, analyze, and report data discrepancies and defects with clear root cause analysis • Develop and maintain SQL queries and scripts for automated data validation • Validate handling of edge cases, null values, and exception scenarios • Support UAT and production data validation activities • Collaborate with data engineers, backend developers, and business stakeholders to clarify requirements and resolve issues • Document test cases, test results, and data validation reports

Job Requirements

  • Strong proficiency in SQL, including complex joins, subqueries, CTEs, and aggregations
  • Experience in implementing strategies to reduce contention and deadlocks in multi-user environments
  • Demonstrated experience in assessing and benchmarking database performance, including identifying bottlenecks and optimizing query execution
  • Hands-on experience testing stored procedures, functions, triggers, and views
  • Experience in ETL testing and data validation across multiple systems
  • Solid understanding of data warehousing concepts (fact/dimension tables, Slowly Changing Dimension (SCDs), star/snowflake schemas)
  • Experience with relational databases such as Maria DB or MySQL
  • Strong understanding of data quality, data reconciliation, and validation techniques
  • Positive attitude with passion for customer value
  • Excellent communication and teamwork skills
  • Experience in construction and pre-fabrication a Bonus

Benefits

  • Medical, dental, life, vision, disability, 401(k)
  • Employee Stock Purchase Plan
  • Paid time off
  • Tuition reimbursement
  • Discounts on Stanley Black & Decker tools and other partner programs
  • Wellness programs

Related Categories

Related Job Pages

More SDET Jobs

Full TimeRemoteTeam 10,001+Since 1954H1B Sponsor

Automation Test Engineer at GDIT developing cloud-based solutions for federal courts

ChaiCloudJestMochaNode.jsReactSelenium
United States
$96.6K - $130.7K / year
Full TimeRemoteTeam 201-500

The role involves owning the test strategy and execution for feature areas, designing complex IT configurations for testing, and performing manual and automated test verifications including load and performance testing. Responsibilities also include performing root cause analysis for bugs and collaborating within a scrum team to promote a culture of quality.

United States
Full TimeRemote

The Senior Software Engineer In Test is responsible for delivering and maintaining automation across the test pyramid, including automating user journeys, developing frameworks, and migrating existing automation suites. This role involves close collaboration with Developers, DevOps, and the QA Automation Lead to scale automation while ensuring test reliability and efficiency.

United States
$130K - $150K / year
Full TimeRemoteTeam 201-500

The role involves designing and building automated unit and integration tests using .NET/C# or Java, while enhancing the UI automation framework built with Playwright and TypeScript. Responsibilities also include leveraging Generative AI to transform QA workflows and integrating automated test suites into CI/CD pipelines.

United States