Senior QA Tester (ETL Testing)

Responsibilities

• Experience in understanding ETL Source to Target Mapping Document and creating QA documents and artifacts accordingly.
• Create test data according to new features/data platform upgrades and Business Rules.
• Mentor the QA team and work with cross teams to understand the business requirements and create test scripts accordingly.
• Create ETL, DB validation, and other QA scripts in offshore and work with the onshore team to make sure execution and reports are shared with business leads.
• Automate the existing and new SQL scripts being developed during the product development and Implementation lifecycle.
• Develop and maintain automated ETL test scripts to streamline testing processes and improve efficiency.
• Testing the data and the portals in Production and UAT.
  

Requirements

• Minimum 6 years of experience working in QA/ETL.
• Minimum 6 years of experience working in Test Data Management and Database testing.
• Strong experience in creating and automating complex SQL queries, advanced SQL concepts, and query optimizations.
• Design, create, and execute test cases for ETL processes, covering data extraction, transformation, and loading.
• Experience in validating data reconciliation scripts for volume data validation in ETL and Data integration testing.
• Experience in handling a large volume of data.
• Experience with version control tools.
• Good to have US healthcare experience.
• Good to have experience in Databricks.
• Good to have exposure to any AI/Automation tools.
  

Non-Technical / Behavioural Competencies Required

• Must have worked with US-based clients in an on-site/offshore delivery model.
• Strong verbal and written communication, technical articulation, listening, and presentation skills are essential.
• Should have proven analytical and problem-solving skills.
• Demonstrated expertise in prioritization, time management, and stakeholder management (both internal and external) is necessary.
• Should be a quick learner, a self-starter, proactive, and an effective team player.
• Must have experience working under tight deadlines within a matrix organizational structure.