Full-Time Senior Software Test Engineer - ETL

Senior Software Test Engineer - ETL

Responsibilities

• Participate in "3 Amigos" sessions (Business, Development, QA) to define and refine acceptance criteria.
• Review user stories and acceptance criteria to identify test scenarios.
• Provide accurate test estimates during sprint planning.
• Design, develop, and execute comprehensive test plans for database-centric applications.
• Verify data mapping, transformation logic, and business rule implementations.
• Write and maintain complex SQL queries to validate data accuracy and consistency.
• Validate data across SQL and NoSQL databases (e.g., PostgreSQL, SQL Server, MongoDB), ensuring consistency, accuracy, and integrity.
• Work with cloud-based data platforms like Google BigQuery to test data pipelines and analytical queries.
• Participate in root cause analysis for data-related issues and discrepancies.
• Log, track, and retest defects; ensure issues are resolved in a timely manner.
• Create and manage required test data and test environments.
• Conduct exploratory testing in every sprint.
• Automate tests to increase efficiency and coverage.
• Develop and run non-functional test automation (e.g., performance testing).
• Capture quality metrics to drive continuous improvement of testing practices.
• Support production releases and perform post-implementation validation.
• Collaborate with DevOps teams to integrate testing into CI/CD pipelines.

Requirements

• 4+ years of hands-on experience in ETL testing or database testing.
• Strong SQL skills, with proficiency across platforms like Oracle, SQL Server, and PostgreSQL.
• Experience testing across both relational (SQL) and non-relational (NoSQL) databases such as MongoDB.
• Hands-on experience validating datasets within cloud data warehouses, particularly Google BigQuery.
• Experience validating data pipelines, data warehouses, and dimensional models.
• Solid understanding of data warehousing and ETL concepts.
• Familiarity with performance tuning and optimization of complex SQL queries.
• Experience in programming with Java or TypeScript.
• Hands-on experience with automation tools like Selenium, Playwright, or equivalent.
• Skilled in automated API testing.
• Familiar with CI/CD pipelines (e.g., GitLab CI/CD) and cloud platforms (preferably GCP).
• Strong analytical and troubleshooting skills.
• Excellent written and verbal communication skills.
• Able to work as an embedded tester in a Scrum/Agile team.
• Ability to evaluate the complexity of user stories and contribute to estimation and planning.
• Basic understanding of microservices architecture.

What is the last date for applying to the job?

Which countries are accepted for this remote job?