Lead Software Quality Automation Engineer

Experience
9 to 12 Years

Mandatory Skills

Automation Testing
ETL testing
DB queries
automation scripts
BDD Framework
AWS/Cloud
Python
Additional Skills

Communication Skills.
Leadership Skills
Job Description

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

● Excellent communication skills (written, verbal, listening, and articulation)

Additional Information

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)
Required Qualification
Bachelor of Computer Applications (B.C.A.) ,
Bachelor of Computer Science (B.Sc. (Computer Science)) ,
Bachelor of Engineering - Bachelor of Technology (B.E./B.Tech.) ,
Master of Computer Applications (M.C.A.) ,
Master of Engineering - Master of Technology (M.E./M.Tech.) ,

Job Insights: Important Tips to source better

Look for candidates with an official notice period of maximum 1 month.
Excellent communication skills are a must.
Candidates should have team handling experience.
All key skills must be clearly mentioned in the project details section of the resume.
Validate relocation cases thoroughly.
Questionnaire

Question1 : Years of experience in Python? ?

Question2 : Team handling experience? ?

Desired answer : yes

Question3 : Years of experience in ETL/data warehouse testing (DBT/Informatica, Snowflake, SQL)? ?

Desired answer : Minimum 6 years