Qa Tester Engineer

is the creative transformation company We use the power of creativity to build better futures for our people planet clients and communities Working at WPP means being part of a global network of more than 100 000 talented people dedicated to doing extraordinary work for our clients We operate in over 100 countries with corporate headquarters in New York London and Singapore WPP is a world leader in marketing services with deep AI data and technology capabilities global presence and unrivalled creative talent Our clients include many of the biggest companies and advertisers in the world including approximately 300 of the Fortune Global 500 Our people are the key to our success We re committed to fostering a culture of creativity belonging and continuous learning attracting and developing the brightest talent and providing exciting career opportunities that help our people grow Why we re hiring WPP is at the forefront of the marketing and advertising industry s largest transformation Our Global CIO is leading a significant evolution of our Enterprise Technology capabilities bringing together over 2 500 technology professionals into an integrated global team This team will play a crucial role in enabling the ongoing transformation of our agencies and functions GroupM is the world s leading media investment company responsible for more than 63B in annual media investment through agencies Mindshare MediaCom Wavemaker Essence and m SIX as well as the results-driven programmatic audience company Xaxis and data and technology company Choreograph GroupM s portfolio includes Data Technology Investment and Services all united in a vision to shape the next era of media where advertising works better for people By leveraging all the benefits of scale the company innovates differentiates and generates sustained value for our clients wherever they do business The GroupM IT team in WPP IT are the technology solutions partner for the GroupM group of agencies and are accountable for co-ordinating and assuring end-to-end change delivery managing the GroupM IT technology life cycle and innovation pipeline This role will work as part of the Business Platform Team for EMEA You will be part of a new team Data team in Chennai that will support our existing and future BI setup for EMEA markets You will be responsible for delivering the solutions formulated by product owners and key stakeholders for different EMEA markets In collaboration with the Data development team you update the architecture and data models to new data needs and changes in source systems What you ll be doing Responsible for planning deployment and managing the quality assurance and testing for the shared services team Develop and establish quality assurance deliverables and testing framework including creating and maintaining test plans and test cases in accordance with changing requirements throughout the development of the Application Software and data services Create and manage the automated test framework where applicable such as preparing the test environment and maintaining functional testing scripts in accordance with the changing Checking data source locations and formats performing a data count and verifying that the columns and data types meet requirements reviewing keys and removing duplicate data Identifying key ETL mapping scenarios and creating SQL queries that simulate them Each ETL test case should be able to replicate one or more ETL mappings and compare them against real output Confirming that all data was loaded and that invalid data was rejected and loaded to the appropriate location rejects table etc Perform thorough testing of datasets reports and dashboards developed in Power BI to ensure data accuracy and completeness Validate data transformation processes and ETL pipelines that feed into Power BI Work with the deployment team on setting up continuous integration build and release automation Work with the development team i e the business analysts and testers for user stories elaboration test automation bug fixes etc Ensure defects are tracked in the product backlog and conduct impact analysis of defect fixes discovered during manual or automated tests validate completed stories pass the acceptance criteria raising defects as needed and work with the development team to improve the expected behavior and test cases Ensure that only the tested stories are demonstrated during the Sprint review s What you ll need 4-5 years in the capacity of a QA Lead Solid Backend experience by writing PL SQL Queries Experience in Data Modelling Understanding of Data warehouse Data Migration ETL concepts Aware of the concepts related to Datawarehousing OLTP and OLAP Experience in Power Bi Dashboards and reports testing Excellence analytical skills Experience automated testing tools is a plus In depth understanding of development methodologies Agile Waterfall etc Working with 1 or more agile development teams Familiar with Agile tools e g JIRA Azure Devops Continuous QA process improvement Who you are You re open We are inclusive and collaborative we encourage the free exchange of ideas we respect and celebrate diverse views We are accepting of new ideas new partnerships new ways of working You re optimistic We believe in the power of creativity technology and talent to create brighter futures or our people our clients and our communities We approach all that we do with conviction to try the new and to seek the unexpected You re extraordinary we are stronger together through collaboration we achieve the amazing We are creative leaders and pioneers of our industry we provide extraordinary every day What we ll give you Passionate inspired people - We promote a culture of people that do extraordinary work Scale and opportunity - We offer the opportunity to create influence and complete projects at a scale that is unparalleled in the industry Challenging and stimulating work - Unique work and the opportunity to join a group of creative problem solvers Are you up for the challenge LI-Onsite We believe the best work happens when we re together fostering creativity collaboration and connection That s why we ve adopted a hybrid approach with teams in the office around four days a week If you require accommodations or flexibility please discuss this with the hiring team during the interview process WPP is an equal opportunity employer and considers applicants for all positions without discrimination or regard to particular characteristics We are committed to fostering a culture of respect in which everyone feels they belong and has the same opportunities to progress in their careers Please read our Privacy Notice for more information on how we process the information you provide