QA Engineer II

Condé Nast is seeking a skilled and experienced Data Testing Engineer to join their dynamic team in Chennai. This role involves designing and executing comprehensive test plans for ETL processes, ensuring data integrity and accuracy throughout the data lifecycle. The engineer will perform functional, integration, and regression testing on ETL workflows and data pipelines, working with technologies like Databricks, advanced SQL, and cloud platforms. Responsibilities also include creating SIT test cases, validating data, troubleshooting erroneous results, and collaborating with development teams.

Must Have

• Design and execute comprehensive test plans for ETL processes, ensuring data integrity and accuracy.
• Perform functional, integration, and regression testing on ETL workflows and data pipelines.
• Knowledge of dimensional modeling and data warehouse concepts (star schemas, snowflakes, dimensions, facts).
• Ensure all sign-offs on deliverables and that testing meets governance requirements.
• Responsible for ensuring quality of their work and the entire development team.
• Experience in API and UI validation testing.
• Create SIT test cases/test data and perform Test execution.
• Review Data Models, Data Mappings, Architectural Documentation.
• Validate data by running queries in the database and verify results.
• Analyze and troubleshoot erroneous results, determine root cause of defects, log defects in Jira.
• Work closely with Business Analysts, Developers & other testers.
• Write queries to extract data for test case data comparison.
• Perform Dashboard Testing and Data analytical queries to synchronise with Data against Metrics.
• Working experience in end-to-end data flow automation.
• Proficiency in Databricks, Python, Advanced SQL queries.
• Experience with Cloud platforms (AWS, Azure, GCP) and testing in cloud.
• Develop and maintain automated test scripts using Databricks tool.
• Execute automated and manual tests to ensure the quality of DSC.
• Collaborate with development and PMO team to understand requirements and design test plans.
• Perform functional, regression, integration, and Backend testing on data applications.

Good to Have

• CI/CD - Github actions or any equivalent.
• Rest APIs and Graphql.
• Scripting knowledge in Pyspark, Python.
• Functional & Regression testing.
• BI Analytics Dashboard Testing.
• Strong communication and interpersonal skills.
• Ability to meet challenging deadlines and work in a fast-paced environment.
• Experience in using data testing and automation tools.
• Experience in using configuration management or version control tools.

Location:

Chennai, TN

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.

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