Condé Nast is a global media company producing the highest quality content with a footprint 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’s most respected and influential media properties including Vogue, Vanity Fair, Glamour, Self, GQ, The New Yorker, Condé Nast Traveler / Traveller, Allure, AD, Bon Appétit and Wired, among others. Condé Nast Entertainment was launched in 2011 to develop film, television and premium digital video programming. QA Engineer II Job Description : We are seeking a skilled and experienced Data Testing Engineer to join our dynamic team. In this role, you will be responsible for Design and execute comprehensive test plans for ETL processes, ensuring data integrity and accuracy throughout the data lifecycle. Perform functional, integration, and regression testing on ETL workflows and data pipelines. 1. Databricks 2. Advanced SQL queries 3. SOAP, SOA, API testing 4. Analytics and BI Dashboard Testing 5. Cloud platforms (AWS, Azure, GCP) and data testing in cloud 6. Experience with data automation tools like Informatica (PL-SQL), Databricks (Pyspark) 7. Rest APIs & Graphql 8. Git and GItHub and Reporting tools 9. Linux or Windows server This list of applications doesn’t stop with the above list, it extends as per the business needs and will include the support of development & debug the platform related issues as well. Responsibilities will include :
- Knowledge of dimensional modeling and data warehouse concepts, such as star schemas, 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 entire development team
- Should have experience in API and UI validation testing as well
- Strong experience in of the following technologies preferred –Web API (MS ASP.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 to create / execute effective SIT Test Plans and SIT test cases
- Validates data by running queries in the database and verify that the results match the expectations
- Analyzes and troubleshoots erroneous results, determines the root cause of defects, logs the defects in Jira and enables defect management, including working with the development team on the resolution of Software related defects
- 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 Data against 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 requirements and design comprehensive test plans and test cases. (M)
- Perform functional, regression, integration, and Backend testing on data applications.(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.