Job Title : Lead Software Quality Automation Engineer

Experience : 9 years to 12 years

Location : Pune

Word Mode : Hybrid (2-3 days WHO/ week)

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.

- 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)

Required Qualification :

Bachelor of Engineering - Bachelor of Technology (B.E./B.Tech.) ,

Master of Engineering - Master of Technology (M.E./M.Tech.) ,

Bachelor of Computer Applications (B.C.A.) ,

Master of Computer Applications (M.C.A.) ,

Bachelor of Computer Science (B.Sc. (Computer Science)) ,