Senior Data Quality Test Engineer - Snowflake

We are looking for a Senior Data Quality Engineer to join our team for a permanent role.

The ideal candidate will have deep hands-on experience with ETL, Python and a strong proficiency in SQL.

You will play a critical role to enhance our automated regression testing coverage, maintain our test automation framework and ensuring that complex data transformations meet rigorous quality and performance standards within Snowflake and Databricks environments.

In this role, you will

• Design, develop, and maintain automated test frameworks to validate complex ETL data transformations, source-to-target mapping, and data consistency.
• Execute rigorous validation of data movement and processing within Snowflake and Databricks, ensuring optimal performance, schema compliance, and data integrity.
• Automate assigned areas/features using the existing Framework and provide the test estimations, build automation scripts using Python & Unix.
• Develop Python scripts to automate data validation and transformation tasks.
• Develop automated test scripts using SQL, Python, or other testing frameworks.
• Utilize SQL or any database querying language to compare, manage and manipulate data efficiently.

Required skills

• Overall 7-10 years of overall testing experience with focus on ETL/Data Testing projects in the banking domain.
• Minimum 3 years of experience in automated testing with Python.
• Must have experience validating data within Snowflake or Databricks.
• 2+ years of hands on experience in UNIX. Strong knowledge and expertise of Unix / Linux commands and scripting including file operations, manipulation and compare.
• Must have good experience with SQL database and writing complex SQL queries.
• 3+ years of hands on experience in SQL. Should be able to write complex joins, unions, case and aggregations. Ability to compare large datasets using SQL, Python.
• Strong understanding the database concepts (indexes, constrains, normalization).
• Experience in a variety of test automation frameworks/tools e.g., (Cucumber, Robot Framework, SoapUI, Selenium, TestNG) and script development using Python.
• Extensive experience across the full QE lifecycle, including test planning, test case design, execution, and defect management.