Quality Engineer

ETL Test Engineer

Responsibilities

• Develop and Implement Automation Frameworks

  : Design, build, and maintain scalable test automation frameworks tailored for data warehousing environments.

• Test Strategy and Execution

  : Define and execute automated test strategies for ETL processes, data pipelines, and database integration across a variety of data sources.

• Data Validation

  : Implement automated tests to validate data consistency, accuracy, completeness, and transformation logic.

• Performance Testing

  : Ensure that the data warehouse systems meet performance benchmarks through automation tools and load testing strategies.

• Collaborate with Teams

  : Work closely with data engineers, software developers, and data analysts to understand business requirements and design tests accordingly.

• Continuous Integration

  : Integrate automated tests into the CI/CD pipelines, ensuring that testing is part of the deployment process.

• Defect Tracking and Reporting

  : Use defect-tracking tools (e.g., JIRA) to log and track issues found during automated testing, ensuring that defects are resolved in a timely manner.

• Test Data Management

  : Develop strategies for handling large volumes of test data while maintaining data security and privacy.

• Tool and Technology Evaluation

  : Stay current with emerging trends in automation testing for data warehousing and recommend tools, frameworks, and best practices.

Job Qualifications:

Key focus areas include:

• Automation using

  Python/

• Testing ETL processes with tools like

  Matillion

  and

  Qlik Replicate

• Strong

  SQL

  skills for data validation
• Working with

  Snowflake

  ,

  Azure services

  (ADF, Logic Apps), and

  Power BI

• Knowledge of

  data warehousing concepts

  (Star/Snowflake schema, Data Vault)
• Experience: 4-6 Yrs

Experience with the following tools and technologies are desired.

• QLIK Replicate
• Matillion ETL
• Snowflake
• Data Vault Warehouse Design
• Power BI
• Azure Cloud – Including Logic App, Azure Functions, ADF