Senior Software Test Engineer - ETL and SQL

Location: Chennai/Pune, India Employment Type: Full-time Location Type: Remote

Company Description

NielsenIQ and GfK together offer The Full View™, recognized as the world's leading consumer intelligence company. We provide the world’s most complete and clear view of consumer buying behavior combined with unparalleled omnichannel coverage, data platforms, and predictive analytics. The combined company has over $4 billion in sales and 30,000+ clients covering 150+ countries. Our complementary and unmatched global reach, along with investments in coverage and technology, will enable further strategic growth. The strategic combination of NIQ and GfK brings together two companies that have independently made significant investments in omnichannel coverage, business intelligence tools, and predictive analytics. With unmatched global reach and industry expertise, we are positioned to accelerate our growth by offering The Full View™ of consumer behavior around the globe.

Position Overview

We are seeking a Senior Software Test Engineer with expertise in ETL and SQL to join our team. This role is crucial for ensuring the quality and accuracy of our data-centric applications and data pipelines.

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.

Qualifications

• 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.