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

Senior sotware Test Engineer ETL and SQL Chennai/Pune India

RIN

• NielsenIQ and GfK together offer the Full View & recognized as the worlds leading consumer intelligence company.
• The worlds 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 30000 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 databasecentric 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 cloudbased data platforms like Google BigQuery to test data pipelines and analytical queries.
• Participate in root cause analysis for datarelated 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 nonfunctional test automation (e.g. performance testing).
• Capture quality metrics to drive continuous improvement of testing practices.
• Support production releases and perform postimplementation validation.
• Collaborate with DevOps teams to integrate testing into CI/CD pipelines.

Qualifications :

• 4 years of handson 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 nonrelational (NoSQL) databases such as MongoDB.
• Handson 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.
• Handson 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 cuttingedge 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
• EmployeeAssistanceProgram (EAP)

Our Benefits

• Flexible working environment
• Volunteer time off
• LinkedIn Learning
• EmployeeAssistanceProgram (EAP)

About NIQ

NIQ is the worlds 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 insightsdelivered with advanced analytics through stateoftheart platformsNIQ delivers the Full View. NIQ is an Advent International portfolio company with operations in 100 markets covering more than 90% of the worlds population.

For more information visit

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 ActionEmployer 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 nondiscrimination 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:  Work :

Yes