Job Description

P2-C2-STS




JD




Strong SQL skills to perform database queries, data validations, and data integrity checks. Familiarity with relational databases and data management concepts.


Working experience with cloud-based data warehouse platforms like Snowflake and AWS.


Experience in creating and implementing ETL testing strategy


Experience in data integrity, data accuracy and completeness testing


Proficient in source to target mapping validation test cases


Proficient in Test planning, Test design, Test execution, Test management, preferably in healthcare payor domain




Lead ETL testing and data migration projects from QA perspective, ensuring accuracy and completeness.


Validated data pipelines in order to maintaining data integrity.


Performed BI report validation on Power BI for a Enterprise level Sales and Assets dashboard which has number of important KPIs, ensuring insights are accurate and actionable.


Executed automation framework for data validation and reconciliation.


Interact with business stakeholders and give UAT support to them during UAT cycle.Write complex SQL queries on Snowflake in order to maintain data quality.


Maintain test cases on JIRA and Zephyr.


Attend all the scrum ceremonies like Sprint review meetings, daily standups.




Mandatory Skills




8 to10 years of ETL Testing experience


Snowflake and AWS.


Business intelligence and Data warehouse testing


SQL queries and testing data flow across the data layers


testing data quality, data integrity, data reconciliation


understanding on Data warehouse


working with Agile teams


ETL testing strategy

About Virtusa

Teamwork, quality of life, professional and personal development: values that Virtusa is proud to embody. When you join us, you join a team of 27,000 people globally that cares about your growth -- one that seeks to provide you with exciting projects, opportunities and work with state of the art technologies throughout your career with us.



Great minds, great potential: it all comes together at Virtusa. We value collaboration and the team environment of our company, and seek to provide great minds with a dynamic place to nurture new ideas and foster excellence.



Virtusa was founded on principles of equal opportunity for all, and so does not discriminate on the basis of race, religion, color, sex, gender identity, sexual orientation, age, non-disqualifying physical or mental disability, national origin, veteran status or any other basis covered by appropriate law. All employment is decided on the basis of qualifications, merit, and business need.