Overview MUST HAVE SKILLS Performance Testing snowflake Automation Comprehensive ETL Testing Documentation Skills Talend Regulatory Compliance Data Masking sql
The Senior ETL QA (Extract Transform Load Quality Assurance) plays a critical role in ensuring the integrity and performance of data as it moves through the ETL process. This position is vital within our organization as it directly impacts data accuracy reliability and overall business intelligence outcomes used for strategic decisionmaking. The Senior ETL QA will lead testing initiatives develop robust testing procedures and collaborate closely with data engineers developers and business analysts. Leveraging a deep understanding of ETL processes this role focuses on identifying data issues early in the development cycle enabling the team to deliver highquality solutions. This is a handson position that combines technical skills with leadership ability fostering a culture of excellence in data quality across project teams. Proficiency in automation is also key as the Senior ETL QA will implement automated test scripts to improve testing efficiency and effectiveness. Thereby ensuring trust in data and analytics initiatives crucial for driving business performance.
Key Responsibilities
- Develop and execute test strategies for ETL processes
- Perform data validation and verification through all ETL stages
- Design and implement test plans test cases and test scripts
- Collaborate with Data Engineers to understand ETL pipeline requirements
- Analyze and document defects and issues discovered during testing
- Utilize SQL and other tools to perform indepth data analysis
- Automate testing processes to enhance testing efficiency
- Conduct regression testing during system updates and enhancements
- Train and mentor junior QA team members on ETL testing
- Facilitate reviews of test outputs and provide feedback
- Support root cause analysis and reporting for data discrepancies
- Participate in Agile ceremonies and contribute to continuous improvement
- Ensure compliance with best practices in data quality and governance
- Manage testing environments and ensure data privacy standards
- Provide regular updates to stakeholders regarding testing status and issues
Required Qualifications
- Bachelors degree in Computer Science or related field
- Minimum8 to 12 years of experience in ETL testing
- Strong proficiency in SQL and data manipulation
- Experience with ETL tools such as Informatica Talend or SSIS
- Solid understanding of data warehouses and data modeling concepts
- Familiarity with testing automation tools such as Selenium or QTP
- Knowledge of scripting languages (Python Shell) is a plus
- Experience working in Agile/SCRUM environment
- Ability to communicate complex technical concepts effectively
- Strong analytical skills and attention to detail
- Proven problemsolving capabilities in datarelated issues
- Knowledge of data visualization tools (Tableau Power BI) is advantageous
- Experience in performance and load testing is preferred
- Certifications in QA methodologies (e.g. ISTQB) are a plus
- Proven track record of delivering projects on time
- Ability to work effectively in a teamoriented environment
power bi,sql,etl testing,ssis,regulatory compliance,informatica,qtp,comprehensive etl testing,performance testing,shell,snowflake,python,documentation skills,selenium,automation,data masking,tableau,talend