Senior Software Test Engineer - ETL ( with a strong focus on database testing & automation )
Company Description 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. 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) Show more Show less
