QA Lead

The QA Lead will play a pivotal role in ensuring the success of the Data Modernization initiative by overseeing system integration testing, A/B testing, and user acceptance testing (UAT). This role focuses on maintaining data integrity, performance, and functionality as legacy systems transition to a modern, cloud-native stack leveraging PostgreSQL, Snowflake, and advanced ETL pipelines. The ideal candidate will possess strong expertise in automated testing frameworks, data validation processes, and iterative feedback mechanisms. They will collaborate closely with cross-functional teams, including data engineers, project managers, and business stakeholders, to deliver seamless integration with minimal downtime and maximum reliability.

Responsibilities and Duties

1. System Integration Testing:

• Design, implement, and maintain automated testing frameworks to validate data workflows and system integrations.
• Develop test plans and scripts for end-to-end workflows across SQL Server, PostgreSQL, and Snowflake environments.
• Monitor and report on system performance and compliance with project benchmarks.

1. A/B Testing:

• Oversee A/B testing of the legacy SQL Server system against the new tech stack to ensure feature parity and data consistency.
• Collaborate with business stakeholders to set clear objectives for test scenarios, metrics, and success criteria.

1. User Acceptance Testing (UAT):

• Lead iterative UAT sessions with business teams, capturing feedback to refine system functionality.
• Develop documentation and training materials to ensure end-user satisfaction and system adoption.

1. Collaboration and Communication:

• Act as a liaison between QA, Data Engineering, and Product teams to align on testing priorities and timelines.
• Provide regular updates to stakeholders using dashboards and status tracking systems, flagging risks early.

1. Automation and Process Improvement:

• Implement and optimize automated regression testing for scalability and efficiency.
• Continuously evaluate and recommend tools and processes to enhance testing coverage and reliability.

Qualifications and Skills

• Proven experience (10+ years) in QA roles, with a focus on data system migrations and cloud-native platforms.
• Strong expertise in automated testing tools (e.g., Selenium, JUnit, pytest) and frameworks.
• Hands-on experience with SQL-based data systems and data validation testing.
• Familiarity with PostgreSQL, Snowflake, and data pipeline tools such as Apache Airflow and AWS Glue.
• Exceptional problem-solving skills with a keen eye for detail and data accuracy.
• Strong communication and leadership abilities to coordinate across teams and stakeholders.
• Experience conducting UAT sessions and working in Agile environments.

Additional Requirements

1. Technology:

• Knowledge of Babelfish for PostgreSQL or similar compatibility tools.
• Experience in A/B testing methodologies and data performance analysis.
• Familiarity with data governance and security frameworks (e.g., Great Expectations, DataHub).

1. Competencies

• Ability to articulate complex testing plans and results in a clear, non-technical manner for business stakeholders.
• Strong written and verbal communication for reporting, documentation, and coordination.
• Collaborative mindset to work with cross-functional teams and resolve conflicting priorities.
• Analytical approach to identifying, understanding, and resolving data or process inconsistencies.
• Proactive problem-solving to anticipate and mitigate risks before they escalate.
• Keen attention to detail to ensure system reliability and data accuracy.
• Flexibility to adjust testing strategies as project goals evolve or unforeseen issues arise.
• Leadership to inspire confidence in testing strategies and decisions.
• Conflict resolution to mediate between competing priorities or team disagreements.
• Stakeholder engagement to foster trust and transparency throughout the project.
• Effective prioritization to focus on critical testing activities with the greatest business impact.