Required Skill s:
- QA Mindset
- Programming Language (Python, Java, C#)
- Experience automation data testing using Java (BDD Framework), Python or equivalent.
- Strong SQL
- ability to utilize extensive SQL queries to validate data across source, staging, and target systems.
- Strong understanding of business intelligence and ETL processes and requirements.
- Proficiency in understanding ETL data flow and mapping documents.
- Understanding of ETL testing processes, testing, and how to evaluate results.
- Experience working with ETL tools such as AWS Glue, Informatica, Ab Initio, SSIS, or DataStage (or similar tools).
- Experience in testing SSRS reports, BI dashboards, and similar tools.
Nice to Have Skills:
- Certifications such as AWS, CSTE, CSQE, or CCP
- Experience in API testing using tools such as Postman or similar and defect management tools such as JIRA.
Day to Day:
The Senior Quality Assurance Engineer will lead comprehensive testing efforts on the business intelligence side. This role serves as the technical expert in ETL testing using AWS, SSRS, and dashboard testing, as well as API and performance testing.
- Establish and maintain quality assurance standards and procedures.
- Design, create, implement, and write detailed and comprehensive test plans for products.
- Conduct tests to identify software defects and ensure product quality standards are met.
- Perform inspections and audits to ensure compliance with standards.
- Oversee the entire testing lifecycle from start to finish and perform manual and automated testing.
- Document test cases, test results, and quality standards along with preparing and present reports on quality metrics.
- Maintain detailed records of tests and inspections and implement corrective actions to address quality issues.
- Collaborate with development teams to resolve issues.
- Analyze data to identify areas for quality improvement and recommend and implement process improvements.
- Design test cases based on functional and non-functional requirements.
- Conduct regression testing to ensure changes were implemented.
- Review design specifications for testability and participate in code reviews.
- Set up test environments (software configurations) at various levels of testing.
- Manage testing tools and ensure their proper utilization.