ETL QA Tester

Fint Solutions; Chennai; On-site; INR 800,000 - 1,200,000; Full time

Job summary

Fint Solutions invites applications for a Data Warehouse Testing Engineer to join our Chennai team. The role focuses on Snowflake-based data warehouse testing, ETL validation with Matillion, and data quality across sources and targets.

You will design and execute test plans, automate where possible, and monitor performance to meet SLAs. The candidate should demonstrate strong SQL skills, experience with data modeling concepts, and familiarity with cloud environments (AWS/Azure/GCP).

Qualifications

• Strong hands-on experience with Snowflake Data Warehouse (SQL, performance tuning, data modeling concepts).
• Hands-on Matillion ETL experience (or similar cloud ETL tools).
• Strong SQL skills for complex data validation and transformation logic testing.
• Experience in DWH concepts (star/snowflake schemas, slowly changing dimensions, fact/dimension tables).
• Experience in functional, regression, and integration testing of data pipelines.

Responsibilities

• Develop and execute test plans, test cases, and test scripts for Snowflake-based data warehouse solutions.
• Perform ETL testing on Matillion pipelines to ensure data is accurately extracted, transformed, and loaded.
• Validate data quality, completeness, and consistency across multiple data sources and targets.
• Conduct end-to-end testing for data ingestion, transformation, and reporting layers.
• Develop SQL queries to perform data validation, reconciliation, and exception reporting.
• Implement test automation for ETL workflows where possible.
• Monitor and test performance of Snowflake queries and ETL jobs to ensure SLAs are met.
• Document defects clearly and work with engineering teams to drive resolution.

Skills

Snowflake Data Warehouse

SQL

Data validation

ETL testing

DWH concepts

Jira

Cloud environments

Automation scripting

Python or Shell scripting

Test automation frameworks

Tools

Matillion ETL

Job description

We are looking for a skilled Data Warehouse Testing Engineer with expertise in Snowflake, Matillion ETL, and data validation processes. The ideal candidate will be responsible for designing and executing test cases and automation scripts to ensure data accuracy, integrity, and performance in our cloud-based data warehouse environment.

Key Responsibilities:

Data Warehouse Testing:

• Develop and execute test plans, test cases, and test scripts for Snowflake-based data warehouse solutions.
• Perform ETL testing on Matillion pipelines to ensure data is accurately extracted, transformed, and loaded.
• Validate data quality, completeness, and consistency across multiple data sources and targets.
• Conduct end-to-end testing for data ingestion, transformation, and reporting layers.
• Ability to work independently
• Must have excellent interpersonal and communication skills, both written and oral.
• Must have the ability and desire to quickly learn new skills and technologies

Automation and Performance:

• Develop SQL queries to perform data validation, reconciliation, and exception reporting.
• Implement test automation for ETL workflows where possible.
• Monitor and test performance of Snowflake queries and ETL jobs to ensure SLAs are met.

Collaboration Status Reporting:

• Work closely with data engineers, BI developers, and business analysts to understand data requirements.
• Document defects clearly and work with engineering teams to drive resolution.
• Provide timely test status reports, metrics, and sign-offs.

Required Skills:

• Strong hands-on experience with Snowflake Data Warehouse (SQL, performance tuning, data modeling concepts).
• Hands-on Matillion ETL experience (or similar cloud ETL tools).
• Strong SQL skills for complex data validation and transformation logic testing.
• Experience in DWH concepts (star/snowflake schemas, slowly changing dimensions, fact/dimension tables).
• Experience in functional, regression, and integration testing of data pipelines.
• Familiarity with defect tracking tools (e.g., Jira).
• Good understanding of cloud ecosystems (AWS/Azure/GCP as applicable).

Preferred Skills:

• Experience in automation frameworks for ETL testing.
• Experience and exposure to Slowly Changing Dimension type 1 and type 2 and Fact tables.
• Data reconciliation and Comparison between on prem and Cloud systems.
• Exposure to any BI tools (e.g., Tableau, Power BI) for report validation.
• Familiarity with version control (e.g., Git) and CI/CD pipelines.

Nice to Have:

• Snowflake / Matillion certifications.
• Experience in Python or Shell scripting for test automation.

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.