ETL Data Warehousing Tester

Fint Solutions; Hyderabad; Hybrid; INR 1.200.000 - 1.800.000; Vollzeit

Zusammenfassung

Fint Solutions is seeking a skilled Data Warehouse Testing Engineer to design and execute test cases and automation scripts for our Snowflake-based data warehouse. The role focuses on data validation, performance, and data quality across multiple sources and targets.

You will work on ETL testing with Matillion, develop SQL-based validation queries, and monitor performance to meet SLAs, while collaborating with data engineers and BI teams to ensure accurate reporting.

Qualifikationen

• Experience with Snowflake data warehousing and SQL performance tuning.
• Proficient in Matillion ETL and cloud ETL tools.
• Strong SQL skills for data validation and transformation logic.
• Experience in data quality assessment across multiple sources.
• Background in testing data pipelines: functional, regression, integration.

Aufgaben

• Develop and execute test plans, test cases, and scripts for Snowflake-based data warehouses.
• ETL testing for Matillion pipelines to ensure accurate extraction, transformation and loading.
• Validate data quality, completeness and consistency across sources/targets.
• Conduct end-to-end testing for data ingestion, transformation and reporting layers.
• Collaborate with data engineers, BI developers and analysts; document defects and drive resolutions.
• Provide timely test status, metrics and sign-offs.

Kenntnisse

Snowflake

Matillion ETL

SQL

Data validation

ETL testing

Data quality

Jira

Cloud knowledge

Python scripting

Tools

Jira

Jobbeschreibung

Job Summary:

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 type2 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.