Job Information
Western Alliance Bank Lead Quality Assurance Engineer in Darbydale, Ohio
Job Title: Lead Quality Assurance Engineer Location: Block 23 What you'll do: As the Lead Quality Assurance (QA) Engineer, you are responsible to lead a team of QA engineers who perform Quality Assurance testing for the Enterprise Data & Analytics team. You will play key role in advancing our data maturity across the enterprise. You will leverage your expertise to identify and address systematic errors, working closely with both business and IT teams to ensure our data remains accurate and reliable for critical decision making. This role requires someone who can take the lead in ensuring the quality and reliability of products and continuously seek ways to improve processes. Lead, coordinate, manage and mentor a team of QA professionals in testing activities. Develop and implement QA processes, standards, and methodologies. Conduct a thorough review of business requirements and functional specifications to extract test requirements and craft detailed Test cases/Scripts. Develop, document, and sustain repository of test cases and supplementary test artifacts including test data, data validation procedures etc. Engage in collaborative efforts with data analysts, data stewards, and data engineers to devise comprehensive test plans. Prepare and execute manual and automation test cases with accuracy, and systematically report the outcomes. Identify, document, and communicate the bugs and errors to the development teams in a timely manner. Maintain logs of various testing phases which includes functional, integration, end to end and regression, sanity, smoke testing, and track defects. Partner with cross functional teams to promote and uphold quality throughout the software development lifecycle. Publish information and verbalize clear communication to the leadership team about QA processes, obstacles, and key milestones for the quarterly commitments. Plan to test on scope changes, estimate, prioritize, and trade-offs with Business and Technical Stakeholders. Attend sprints, ceremonies (daily stand-ups, sprint planning, backlog grooming, sprint reviews & retrospectives), evaluate and plan sprint execution velocity and lead/coordinate corresponding activities. Actively plan, participate, and contribute to Program Increment (PI) Planning sessions from QA standpoint. Ensure adherence to standard (Agile) processes, use of tools, established project delivery standards. Ensure Test Plan, Test cases, SQL scripts, and Test results reviews are done, and Approvals are provided. What you'll need: 7+ years of experience in ETL quality assurance. 7+ years of experience in automated testing of ETL/Database/Data Warehouse solutions. 7+ years of experience in SQL scripting and relational databases. Hands on experience in the following tools Azure Data Factory, Azure Synapse, SQL server, Oracle, Azure Storage Account, Data bricks, Unity catalog repository etc. Experience as QA lead on medium to large sized projects. Experience in designing and implementing data warehouse and automated testing solutions. Ability to perform integration testing of data pipelines and the services that consumes them. Experience in triggering, debugging, and troubleshooting ETL jobs/processes. Guide offshore resources on project deliverables and review their work. Experience in workload automation solutions such as Control-M. Familiarity with high-level programming languages, preferably Python. Good understanding of the Software Development Lifecyle (SDLC) and the Software Testing Lifecycle (STLC) and agile processes. Excellent communication skills and ability to work in a collaborative environment. Experience in reporting tools alike Power BI/Tableau. Experience working in an onshore-offshore model. Strong negotiation, influencing, critical thinking, coaching and facilitation skills. Excellent verbal and written communication skills a