Job Description

Job Title: Lead QA Tester

Job Location: Columbus, OH (Hybrid)

Contract Length: 3 Months (Contract to Hire)

Key Responsibilities

• Actively participate in the review of project requirements, data mappings, and technical design specifications.
• Create test strategies and test plans for Data Warehouse projects, mapping back to the project requirements to ensure proper test coverage.
• Execute test cases using manual and/or automated test processes.
• Execute database queries to support test execution in Azure DevOps.
• Perform ETL validation according to data mapping, execute data profiling, reconciliation of data, metadata validation, initial and delta validation for different SCD types.
• Analyze data, troubleshoot data issues, and create action plans to address data quality issues.
• Coordinate test execution with other application teams and UAT partners.
• Create and communicate test status with project team members and stakeholders.
• Identify, document, and communicate testing defects.
• Collaborate with the project team on defect analysis and triage.
• Support continuous improvement by identifying and solving opportunities to define or enhance QA process.
• Perform Functional, Regression, Negative, and migration testing for Data Warehouse projects.

Required Skills and Experience

• Theoretical and practical knowledge of quality assurance, testing principles, ETL technologies, and tools: including AWS, Snowflake, Snowsight, DataStage, Python/PySpark, ASG Zena, Infogix, Tableau, Azure DevOps, Mainframe, and SharePoint.
• Bachelor's degree or military experience in a related field (preferably computer science).
• Minimum 2 years of experience with Snowflake and AWS Cloud.
• Minimum 5 years of ETL testing experience in a data warehouse environment.
• Minimum 5 years of experience analyzing data, troubleshooting data issues, and creating action plans to address data quality issues.
• Minimum 5 years of experience writing SQL queries.
• Understanding of enterprise data warehousing best practices and standards.
• Experience leading QA Analysts on a project team.
• Excellent verbal and written communication skills.
• Highly motivated with strong organizational, analytical, and problem-solving skills.
• Ability to effectively prioritize and execute tasks.

Preferred Skills

• Experience in the financial services industry.
• Experience testing on Snowflake and AWS S3/EC2/EMR.

Required Skills : QA, lead experience, ETL, will be working with Python/PySpark, Snowflake, Etc.

Job Tags

Similar Jobs