Job Description

Location:

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 digitalvideo and social platforms. The companys portfolio includes many of the worldsmost respected and influential media properties including Vogue Vanity FairGlamour 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.

Job Description:

We are seeking a skilled and experienced Data Testing Engineer to join our dynamic 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.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 doesnt 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
• ) 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 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 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

What happens next

If you are interested in this opportunity please apply below and we will review your application as soon as possible. You can update your resume or upload a cover letter at any time by accessing your candidate profile.

Condé Nast is an equal opportunity employer. We evaluate qualified applicants without regard to race color religion sex sexual orientation gender identity national origin disability veteran status age familial status and other legally protected characteristics.