Talent.com
ETL Testing Engineer

ETL Testing Engineer

Condé Nast Technology LabChennai, Republic Of India, IN
1 day ago
Job description

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.
    • Create a job alert for this search

    Engineer Etl Testing • Chennai, Republic Of India, IN