Lead Software QA Engineer

Role: Lead Software Quality Automation Engineer

• Experience: 9 to 12 Years
• Minimum 6 years in ETL/data warehouse testing (DBT/Informatica, Snowflake, SQL)
• Notice period: Candidates with an official notice period of maximum 1 month
• All key skills must be clearly mentioned in the project details section of the resume.
• Validate relocation cases thoroughly.
• Word Mode : Hybrid (2-3 days WHO/ week)
• Ready to work in flexible working hours and collaborate with US/India/Colombia teams
• Excellent communication skills (written, verbal, listening, and articulation)
• Candidate should have team leading experience. (Minimum 2 reportees)
• Mandatory skills- Python, ETL/data warehouse testing (DBT/Informatica, Snowflake, SQL)
  

Responsibilities

• Perform lead role in ETL testing, UI testing, DB testing and team management.
• Understand the holistic requirements, review and analyse stories, specifications, and technical design documents and develop detailed test cases and test data to ensure business functionality is thoroughly tested – both Automation & Manual.
• Validate ETL workflows, ensuring data integrity, accuracy and the Transformation rules using complex Snowflake SQL queries. Working Knowledge on DBT is a PLUS
• Create, Execute and maintain scripts on automation in BDD – Gherkin/Behave, Pytest.
• Experience in writing DB queries (preferably in Postgres/ Snowflake/ MySQL/ RDS)
• Preparation, review and update of test cases and relevant test data consistent with system requirements including functional, integration & regression, UAT testing.
• Coordinate with cross team subject matter experts to develop, maintain, and validate test scenarios to the best interest of that POD.
• Taking ownership on creating and maintaining artifacts on: Test strategy, BRD, Defect count/leakage report and different quality issues.
• Collaborate with DevOps/SRE team to integrate test automation into CI/CD pipelines (Jenkins, Rundeck, GitHub etc.)
• Should have the ability to oversee and guide a team of min 4 testers, lead them by example, institutionalizing best practices in testing processes & automation in agile methodology.
• Meet with internal stakeholders to review current testing approaches, provide feedback on ways to improve / extend / automate along with data backed inputs and provisioning senior leadership with metrics consolidation.
• Maximize the opportunity to excel in an open and recognized work culture. Be a problem solver and a team player.
  

Requirements

• 8-11 years of strong expertise in STLC, defect management, Test Strategy designing, planning and approach. Should have experience with Test requirement understanding, test data, test plan & test case designing.
• Should have minimum 6+ years of strong work experience in UI, Database, ETL testing. Experience in ETL/data warehouse testing (DBT/Informatica, Snowflake, SQL).
• Any experience with AWS/Cloud hosted applications is an added advantage.
• Hands-on experience in writing DB queries (preferably in postgres/ Snowflake/ MySQL/ RDS)
• Should have 3+ years of experience with automation scripts execution, maintenance & enhancements with Selenium web-driver (v3+)/playwright, with programming experience in Python (MUST) with BDD – Gherkin and Behave, Pytest.
• Key competencies required: Strong analytical, Problem-Solving, Communication skills, Collaboration, Accountability, Stakeholder management, passion to drive initiatives, Risk highlighting and Team leading capabilities.
• Proven Team leadership experience with min 2 people reporting.
• Experienced working with Agile methodologies, such as Scrum, Kanban.
• MS Power BI reporting. Front end vs Back end validation – Good to have.
  

Advantage if,

• Has Healthcare/Life Sciences domain experience
• Has a working knowledge on manual and automation testing, and ETL testing Professional Approach
• Ready to work in flexible working hours and collaborate with US/India/Colombia teams