Software Testing
usource
Job Description
- Design, develop, and execute test strategies, test plans, and test cases for ETL and Data Warehouse applications.
- Perform ETL, Database, Data Warehouse, Functional, Smoke, Regression, Acceptance, Compatibility, and Exploratory Testing.
- Validate source-to-target data movement and ensure data integrity across systems.
- Perform comprehensive Snowflake database testing and validation activities.
- Create and execute test scenarios for complex ETL workflows and data transformation processes.
- Analyze business requirements and translate them into effective test cases and validation procedures.
- Write and execute complex SQL queries for data validation and testing.
- Validate Data Warehouse structures including fact tables, dimension tables, star schemas, and snowflake schemas.
- Prepare test data and validation scenarios based on business requirements and healthcare datasets.
- Develop and maintain automation frameworks using ICEDQ and other testing tools.
- Manage defects through Jira and participate in defect tracking, triaging, and resolution activities.
- Perform production support validation and participate in WAR room discussions for critical incidents.
- Analyze and troubleshoot production failures and data quality issues.
- Understand and validate job scheduling workflows using Control-M.
- Collaborate with business analysts, developers, and stakeholders to ensure quality deliverables.
- Create technical documentation, test reports, and knowledge transfer materials.
- Participate in Agile ceremonies including sprint planning, backlog grooming, daily stand-ups, and retrospectives.