Senior Software Test Engineer - ETL Automation testing

Company Description

NielsenIQ and GfK together offer the Full View™ and are recognized as the world's leading consumer intelligence company. 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. Complementary and unmatched global reach and 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, the company is positioned to accelerate its growth by offering The Full View™ of consumer behavior around the globe.

Job Description

Senior Software Test Engineer - ETL Automation testing and SQL Location: Chennai/Pune, India Location Type: Remote Employment Type: Full-time

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