Description
You will focus on validating complex data transformations and ensuring data integrity within our warehousing environment.
Responsibilities
- Validate data accuracy by writing and debugging complex SQL queries.
- Test ETL processes using Informatica to ensure correct data loading.
- Verify data models including Star Schema and dimensional structures.
- Perform data validation on large datasets using multi-table joins and aggregations.
Required Skills
- 7+ years of experience in ETL testing or data validation.
- Expert-level SQL skills for complex query development and debugging.
- Proficiency with window functions, subqueries, and aggregations.
- Hands-on experience with Informatica.
- Strong understanding of data warehousing concepts and dimensional modeling.
- Ability to manage and validate large-scale datasets.
- Bachelor's degree in any field.