Quality Engineer

Condé Nast is a global media company producing the highest quality content with afootprint of more than 1 billion consumers in 31 territories through print, digital,video and social platforms. The company’s portfolio includes many of the world’smost respected and influential media properties including Vogue, Vanity Fair,Glamour, Self, GQ, The New Yorker, Condé Nast Traveler/Traveller, Allure, AD, BonAppétit and Wired, among others. Condé Nast Entertainment was launched in 2011 todevelop film, television and premium digital video programming.QA Engineer IIJob Description:We are seeking a skilled and experienced Data Testing Engineer to join our dynamicteam. In this role, you will be responsible for Design and execute comprehensive testplans for ETL processes, ensuring data integrity and accuracy throughout the datalifecycle. Perform functional, integration, and regression testing on ETL workflows anddata pipelines.1. Databricks2. Advanced SQL queries3. SOAP, SOA, API testing4. Analytics and BI Dashboard Testing5. Cloud platforms (AWS, Azure, GCP) and data testing in cloud6. Experience with data automation tools like Informatica (PL-SQL), Databricks(Pyspark)7. Rest APIs & Graphql8. Git and GItHub and Reporting tools9. Linux or Windows serverThis list of applications doesn’t stop with the above list, it extends as per the businessneeds and will include the support of development & debug the platform related issuesas well.Responsibilities will include:● Knowledge of dimensional modeling and data warehouse concepts, such as starschemas, snowflakes, dimensions, facts● Ensure all sign offs on deliverables (overall test strategy, test plan, test cases, )and that testing meets governance requirements● Responsible for ensuring quality of their work the work of the entiredevelopment team● Should have experience in API and UI validation testing as well● Strong experience in of the following technologies preferred –Web API (MSASP.Net), MVC, WCF, HTML5, CSS, JavaScript, JSON, SOAP, REST, JQuery,Java, Ab Initio● Create SIT test cases/test data and perform Test execution● Review Data Models, Data Mappings, Architectural Documentation tocreate/execute effective SIT Test Plans and SIT test cases● Validates data by running queries in the database and verify that the resultsmatch the expectations● Analyzes and troubleshoots erroneous results, determines the root cause ofdefects, logs the defects in Jira and enables defect management, includingworking with the development team on the resolution of Software relateddefects● Works closely with software development team (Business Analysts, Developers& other testers) to ensure timely and effective testing effort● Writing queries to extract data for test case data comparison● Dashboard Testing and Data analytical queries to synchronise with Dataagainst the Metrics displayed in Dashboard.● Working experience in end - end data flow automation.Desired Skills and Qualifications● Databricks (M)● Python (M)● Advanced SQL queries (M)● Any one Cloud platforms (AWS, Azure, GCP) and testing in cloud (M)● CI/CD - Github actions or any equivalent (S)● Rest APIs and Graphql (S)● Should possess Scripting knowledge in Pyspark, Python● Functional & Regression testing.● BI Analytics Dashboard Testing (S)● Develop and maintain automated test scripts using Databricks tool. (M)● Execute automated and manual tests to ensure the quality of DSC.(M)● Collaborate with the development and PMO team to understand requirementsand design comprehensive test plans and test cases. (M)● Perform functional, regression, integration, and Backend testing on dataapplications.(M)KEY BEHAVIOURS & COMPETENCIES● Daily status report & Bug reporting and Analysis.● Bug reporting and Analysis.● Adherence to Best Practices.● Experience in using data testing and automation tools.● Experience in using configuration management or version control tools.● Strong communication and interpersonal skills.● Ability to meet challenging deadlines and work in a fast-paced environment.