Senior Database Test Engineer – Automation
Employment Information
Report this job
Job expired or something wrong with this job?
Job Description
Sr. Database Test Engineer ensuring database quality and performance for Construction Technology team. Collaborating on test case design and executing automated validation processes.
Responsibilities:
- 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
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
Similar Jobs
Data Test Engineer
Data Test Engineer at GDIT ensuring quality for CMS's UCM system while collaborating with remote teams. Engage in QA processes and execute test plans for system validation.
Test Engineer
Test Engineer analyzing requirements and performing software testing for innovative betting solutions. Collaborate with development teams to ensure top-tier product quality.
Senior QA Automation Engineer
Senior QA Automation Engineer at Super Dispatch designing and building automation frameworks. Collaborating with developers and leading the quality assurance process in a remote team.
Intermediate QA Automation Engineer – APAC/LATAM
QA Automation Engineer at MedMe responsible for quality assurance in pharmacy care management platform. Collaborating with agile teams to maintain testing strategies and high standards for clients.
QA Automation Engineer
QA Automation Engineer ensuring quality of software products through automated and manual testing methodologies. Developing and executing test cases while collaborating with developers and stakeholders.
Lead Test Engineer – Procedure Writer 2, Nuclear
Lead Test Engineer & Procedure Writer in Nuclear Power Group facilitating client communications and coordinating project activities. Reviewing and revising procedures for nuclear projects with a focus on safety and compliance.
QA Test Engineer II
QA Test Engineer II at CSG working on software testing, automation and AI-assisted testing methodologies. Collaborating with cross-functional teams to improve testing efficiency and quality.
Reliability & Parametric Test Engineer
Reliability & Parametric Test Engineer at leading semiconductor manufacturer specializing in ultra-low power integrated circuits. Responsibilities include WLR strategy development, testing, and collaboration with engineering teams.
Test Automation Engineer
Test Automation Engineer for Enroute focusing on innovation and quality assurance. Involved in building and maintaining automated test suites and contributing to team success in agile environments.
Senior SDET, API – Security
Senior SDET at Keeper Security focusing on API and security testing while designing automated test frameworks. Collaborating with development teams to ensure quality and security of applications.
Manual Test Engineer
Manual Test Engineer at GDIT ensuring quality for mission-critical government projects. Develop and execute tests to validate functionality in cloud-based applications.
Automation Test Engineer
Automation Test Engineer at GDIT responsible for developing automated testing solutions for modernization of case management systems for federal courts. Engaging in continuous deployment and collaborating with agile teams.
Senior Test Automation Engineer
Senior Test Automation Engineer at OneStudyTeam enhancing clinical trials with automation. Collaborating across teams to develop testing frameworks for improved software quality.
Senior Software Test Engineer – Technical
Senior Technical Test Engineer testing features for CSG Quote & Order product. Collaborating with a cross-functional team to ensure quality standards and execute tests with modern tools.
Senior Automation Test Engineer
Senior Automation Test Engineer at ELEKS developing automated UI test solutions for clients. Collaborating with teams on testing strategies and maintaining robust test environments.
SDET – Wallet Platform
SDET role at Phantom designing and owning test infrastructure for financial systems. Collaborate with engineering teams to ensure high-quality software delivery.
Tech Lead, SDET
Tech Lead, SDET overseeing automation frameworks for a healthcare EMR platform. Leading quality engineering strategies and mentoring distributed teams.
Associate SDET
Associate Software QA Engineer at Swimlane, focusing on high-quality security automation applications. Collaborating in an Agile environment to ensure robust software quality and performance testing.
Lead Automation Test Engineer
Lead Automation Test Engineer responsible for building automated testing solutions. Engaging with development teams and ensuring quality in software lifecycle with remote operations from the UK.
Senior SONiC CI/CD, Test Automation Engineer
Senior Software Engineer specializing in SONIC CI/CD and test automation for networking solutions. Collaborating on testing frameworks and developing validation tools in a team environment.