NielsenIQ
Senior Software Test Engineer - Automation testing and SQL, Chennai/Pune India
Roles and responsibilities for a Senior Software Test Engineer focused on automation testing and SQL within Chennai/Pune, India. 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 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 state-of-the-art 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 NIQ.com Our commitment to Diversity, Equity, and Inclusion
At NIQ, we are steadfast in our commitment to fostering an inclusive workplace that mirrors the rich diversity of the communities and markets we serve. We believe that embracing a wide range of perspectives drives innovation and excellence. All employment decisions at NIQ are made without regard to race, color, religion, sex (including pregnancy, sexual orientation, or gender identity), national origin, age, disability, genetic information, marital status, veteran status, or any other characteristic protected by applicable laws. We invite individuals who share our dedication to inclusivity and equity to join us in making a meaningful impact. To learn more about our ongoing efforts in diversity and inclusion, please visit NIQs diversity and inclusion information resources. #J-18808-Ljbffr
Roles and responsibilities for a Senior Software Test Engineer focused on automation testing and SQL within Chennai/Pune, India. 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 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 state-of-the-art 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 NIQ.com Our commitment to Diversity, Equity, and Inclusion
At NIQ, we are steadfast in our commitment to fostering an inclusive workplace that mirrors the rich diversity of the communities and markets we serve. We believe that embracing a wide range of perspectives drives innovation and excellence. All employment decisions at NIQ are made without regard to race, color, religion, sex (including pregnancy, sexual orientation, or gender identity), national origin, age, disability, genetic information, marital status, veteran status, or any other characteristic protected by applicable laws. We invite individuals who share our dedication to inclusivity and equity to join us in making a meaningful impact. To learn more about our ongoing efforts in diversity and inclusion, please visit NIQs diversity and inclusion information resources. #J-18808-Ljbffr