Job
Description
As a Data QA Engineer, you will play a crucial role in ensuring the accuracy and reliability of data through ETL testing, data validation, and dashboard verification. Your strong expertise in SQL, ETL layers validation, and automation-driven approach will be key to success in this role. **Key Responsibilities:** - Perform comprehensive end-to-end testing of ETL pipelines and data workflows. - Validate data integrity across various ETL layers including Source, Staging, Curated, and Reporting. - Utilize advanced SQL skills to execute complex queries for data validation and reconciliation purposes. - Validate Snowflake tables, views, transformations, and stored procedures to maintain data accuracy. - Conduct dashboard validation by comparing Tableau dashboards with Snowflake data to ensure consistency. - Perform data reconciliation checks to guarantee accuracy and completeness. - Develop and maintain automated data validation frameworks for efficient testing processes. - Conduct regression testing for data releases and schema changes to identify potential issues. - Collaborate with Data Engineers to address and resolve data quality defects effectively. - Create detailed test documentation, test cases, and validation scripts to support testing activities. **Qualifications Required:** - Strong background in ETL Testing and Data Validation. - Proficient in advanced SQL concepts including joins, aggregations, window functions, and complex queries. - Hands-on experience in validating data across multiple ETL layers. - Familiarity with Snowflake data warehouse validation processes. - Experience in testing Tableau dashboards and reports. - Sound knowledge of data reconciliation techniques. - Previous exposure to regression testing in data pipelines. - Excellent analytical and problem-solving skills. - Domain experience in BFSI/Financial domain is preferred. **Additional Details:** - Preferred Skills: - Experience with cloud platforms like AWS, Azure, or GCP. - Proficiency in data testing tools and automation frameworks. - Exposure to dbt testing frameworks. - Familiarity with modern data warehouse environments. This role offers you the opportunity to work with cutting-edge technologies and make a significant impact on data quality assurance processes in a dynamic environment. As a Data QA Engineer, you will play a crucial role in ensuring the accuracy and reliability of data through ETL testing, data validation, and dashboard verification. Your strong expertise in SQL, ETL layers validation, and automation-driven approach will be key to success in this role. **Key Responsibilities:** - Perform comprehensive end-to-end testing of ETL pipelines and data workflows. - Validate data integrity across various ETL layers including Source, Staging, Curated, and Reporting. - Utilize advanced SQL skills to execute complex queries for data validation and reconciliation purposes. - Validate Snowflake tables, views, transformations, and stored procedures to maintain data accuracy. - Conduct dashboard validation by comparing Tableau dashboards with Snowflake data to ensure consistency. - Perform data reconciliation checks to guarantee accuracy and completeness. - Develop and maintain automated data validation frameworks for efficient testing processes. - Conduct regression testing for data releases and schema changes to identify potential issues. - Collaborate with Data Engineers to address and resolve data quality defects effectively. - Create detailed test documentation, test cases, and validation scripts to support testing activities. **Qualifications Required:** - Strong background in ETL Testing and Data Validation. - Proficient in advanced SQL concepts including joins, aggregations, window functions, and complex queries. - Hands-on experience in validating data across multiple ETL layers. - Familiarity with Snowflake data warehouse validation processes. - Experience in testing Tableau dashboards and reports. - Sound knowledge of data reconciliation techniques. - Previous exposure to regression testing in data pipelines. - Excellent analytical and problem-solving skills. - Domain experience in BFSI/Financial domain is preferred. **Additional Details:** - Preferred Skills: - Experience with cloud platforms like AWS, Azure, or GCP. - Proficiency in data testing tools and automation frameworks. - Exposure to dbt testing frameworks. - Familiarity with modern data warehouse environments. This role offers you the opportunity to work with cutting-edge technologies and make a significant impact on data quality assurance processes in a dynamic environment.
