Responsibilities:
Develop test strategy, analyze industry tools, and recommend any data automation tool.
Analyze and understand integration touchpoints.
Understand provided data mapping document and modify if required.
Analyze various data sources and develop SQL scripts/Store procedure to validate the data across multiple interfaces.
Outline validation and verification scripts required to perform testing. Ex: Source database tables, attributes, Environment, etc.
Outline automation solution for Data testing
Prioritize the downstream validation testing requirements.
Execute test cases and enter defects in defect management system.
Coordinate with Onsite SME’s and QA analyst for test data, test environment, and test scenarios/test cases for automation
Guide and collaborate with offshore teams and develop test automation solution for data testing.
Conduct regular checkpoint meetings with the onshore/offshore teams to track delivery & monitor progress.
Provide weekly QA status report to leadership team.
Requirements:
8+ years of data validation (testing) experience working on data projects (Datawarehouse, ODS or data lake implementation)
Understanding of DWH concepts
Experience in any of the following tools – Informatica, TIDAL and OBIEE
In-depth knowledge and experience in testing various aspects of data, including data quality, data integration, data migration, and data warehousing.
Experience in writing complex SQL queries and stored procedure.
Extensive Knowledge and work experience in ETL testing
Good experience in analyzing the scope and designing the Data strategy document.
Good experience in analyzing industry standard data automation tools and recommend the right tool based on the requirement.
Good Knowledge and work experience in EDW testing, Downstream Report testing
Proficient in working with various database management systems, such as Oracle, SQL Server, MySQL, or others.
Experience in leading and managing a team of data testers, providing guidance and support.
Awareness and usage of test automation tools like QuerySurge or ETL Validator or TOSCA DI
Ability to analyze and understand the various integrations.
Effective communication skills to collaborate with development teams, business analysts, and client stakeholders.
Eagerness to learn and adapt to new tools, technologies, and testing methodologies.
Desired Skill Set:
Good Understanding and Knowledge with Agile and Waterfall Environments.
Hands on Experience on ETL Testing
Experience in any Test management tools
Experience in Insurance domain & Azure Infrastructure would be a plus.
You must verify your mobile number to apply to this job.