ETL Testing

Job Description:
QA Automation EngineerAs a QA Automation Engineer specializing in Data Warehousing, you will play a criticalrole in ensuring that our data solutions are of the highest quality. You will work closelywith data engineers and analysts to develop, implement, and maintain automatedtesting frameworks for data validation, ETL processes, data quality, and integration.Your work will ensure that data is accurate, consistent, and performs optimally acrossour data warehouse systems.ResponsibilitiesDevelop and Implement Automation Frameworks: Design, build, and maintain scalabletest automation frameworks tailored for data warehousing environments.Test Strategy and Execution: Define and execute automated test strategies for ETLprocesses, data pipelines, and database integration across a variety of data sources.Data Validation: Implement automated tests to validate data consistency, accuracy,completeness, and transformation logic.Performance Testing: Ensure that the data warehouse systems meet performancebenchmarks through automation tools and load testing strategies.Collaborate with Teams: Work closely with data engineers, software developers, anddata analysts to understand business requirements and design tests accordingly.Continuous Integration: Integrate automated tests into the CI/CD pipelines, ensuringthat testing is part of the deployment process.Defect Tracking and Reporting: Use defect-tracking tools (e.g., JIRA) to log and trackissues found during automated testing, ensuring that defects are resolved in a timelymanner.Test Data Management: Develop strategies for handling large volumes of test datawhile maintaining data security and privacy.Tool and Technology Evaluation: Stay current with emerging trends in automationtesting for data warehousing and recommend tools, frameworks, and best practices.Job Qualifications:Requirements and skills· At Least 4+ Years ExperienceSolid understanding of data warehousing concepts (ETL, OLAP, data marts, datavault,star/snowflake schemas, etc.).· Proven experience in building and maintaining automation frameworks using tools likePython, Java, or similar, with a focus on database and ETL testing.· Strong knowledge of SQL for writing complex queries to validate data, test datapipelines, and check transformations.· Experience with ETL tools (e.g., Matillion, Qlik Replicate) and their testing processes.· Performance Testing· Experience with version control systems like Git· Strong analytical and problem-solving skills, with the ability to troubleshoot complexdata issues.· Strong communication and collaboration skills.· Attention to detail and a passion for delivering high-quality solutions.· Ability to work in a fast-paced environment and manage multiple priorities.· Enthusiastic about learning new technologies and frameworks.Experience with the following tools and technologies are desired.QLIK ReplicateMatillion ETLSnowflakeData Vault Warehouse DesignPower BIAzure Cloud – Including Logic App, Azure Functions, ADF