K
QA Engineer - ETL & DWH
Kumaran Systems · Tiruporur, Tamil Nadu, India
IT Services and IT Consulting · 1,001-5,000 employees
22 h ago
Senior (5-10 yrs)
Full-time
India
Log in
to apply, save this posting, or score it against your profile with AI.
About the role
Develop and execute comprehensive test plans to validate data within on-prem and cloud data warehouses. Conduct thorough testing of ETL processes, dimensional models, and reporting outputs while collaborating with engineers to resolve quality issues.
What they look for
ETL Testing
SQL Scripting
Data Warehousing
RDBMS
Data Quality Validation
Snowflake
Tableau
MS Power BI
Data Transformation
Dimensional Data Modeling
Requirements
Requires 2 to 5 years of experience in data warehouse development and ETL testing with strong proficiency in SQL and RDBMS. Experience validating dashboards in Tableau or Power BI and knowledge of Snowflake is highly desired.
Full description
Hands-on experience with:
- EDW source-to-target testing (SQL scripting - manual and automation)
- Data transformation/manipulation testing (SQL scripting - manual and automation)
- Data quality/completeness validation (SQL scripting - manual and automation)
- Working knowledge and testing experience of ETL
- Experience in running the processes through the scheduler
Quality Assurance, Process Improvement and Collaboration:
- Develop and execute comprehensive test plans to validate data within on-prem and cloud data warehouses.
- Conduct thorough testing of ETL processes, dimensional data models, and reporting outputs.
- Identify, document, and track data quality issues, working closely with data engineers to resolve them.
Requirements
- Strong understanding of Data Warehouse & Data Quality fundamentals.
- 2 to 5 years of experience in data warehouse development/testing.
- 2 to 5 years of experience with relational databases and ETL testing
- Must be experienced in Data Warehousing Projects with good knowledge of ETL testing.
- Strong in SQL, RDBMS, ETL, and DW concepts.
- Experience in validating Reports/Dashboards on tools like Tableau, MS Power BI, etc.
Desirable qualifications/pluses:
- Knowledge of Insurance Data & its processes
- Data validation experience between on-prem & cloud (i.e. hybrid) architecture.
- Familiarity with cloud computing and the data ecosystem on Snowflake.
