Senior Software Test Engineer - ETL ( with a strong focus on database testing & automation )

Job Description

Senior sotware Test Engineer - ETL and SQL ,Chennai/Pune India

R25_0003037|IN

• NielsenIQ and GfK together offer the Full View™ & 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.
• 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.

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

Additional Information

• Dynamic and energizing work environment fostering collaboration and teamwork
• Utilize cutting-edge digital technologies to stay at the forefront of innovation
• Continuous training programs designed to enhance and support your professional development
• Unlock avenues for both personal and career growth within our organization
• Enjoy the flexibility of adjustable working hours (hybrid model
• Flexible working environment
• Volunteer time off
• LinkedIn Learning
• Employee-Assistance-Program (EAP)

Our Benefits

• Flexible working environment
• Volunteer time off
• LinkedIn Learning
• Employee-Assistance-Program (EAP)

About NIQ

NIQ is the world’s leading consumer intelligence company, delivering the most complete understanding of consumer buying behavior and revealing new pathways to growth. In 2023, NIQ combined with GfK, bringing together the two industry leaders with unparalleled global reach. With a holistic retail read and the most comprehensive consumer insights—delivered with advanced analytics through state-of-the-art platforms—NIQ delivers the Full View™. NIQ is an Advent International portfolio company with operations in 100+ markets, covering more than 90% of the world’s population.

For more information, visit NIQ.com

Want to keep up with our latest updates?

Follow us on: LinkedIn | Instagram | Twitter | Facebook

Our commitment to Diversity, Equity, and Inclusion

NIQ is committed to reflecting the diversity of the clients, communities, and markets we measure within our own workforce. We exist to count everyone and are on a mission to systematically embed inclusion and diversity into all aspects of our workforce, measurement, and products. We enthusiastically invite candidates who share that mission to join us. We are proud to be an Equal Opportunity/Affirmative Action-Employer, making decisions without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability status, age, marital status, protected veteran status or any other protected class. Our global non-discrimination policy covers these protected classes in every market in which we do business worldwide. Learn more about how we are driving diversity and inclusion in everything we do by visiting the NIQ News Center: https://nielseniq.com/global/en/news-center/diversity-inclusion