SpectraMedix - Senior QA Engineer - ETL/Datawarehouse Testing

About Us :SpectraMedix is at the forefront of transforming healthcare, empowering health plans and health systems with the tools and insights they need to provide better, more cost-effective care to the communities they serve. Our cutting-edge platform delivers advanced analytics that help organizations excel in the transition to new value-based payment (VBP) models. By combining advanced technology with a team of seasoned experts, we provide a unique solution tailored to meet the needs of the healthcare industry during this critical phase of value-based care evolution. Our platform is strategically designed to guide health plans, accountable care organizations, and health systems in their journey toward achieving success in value-based payment initiatives. We are committed to creating an environment where innovation thrives, employees are empowered to drive meaningful change, and every team member plays a key role in reshaping the value and quality equation in healthcare. Our organization's long-term stability is grounded in this commitment, and we prioritize our employees' growth, well-being, and success as the foundation for a thriving future-both for them and for the communities we serve. Diversity & Inclusivity :At SpectraMedix, we believe that diversity drives innovation and inclusivity fosters collaboration. We are committed to creating a workplace where everyone feels valued, respected, and empowered to bring their authentic selves to work. We celebrate diverse perspectives and are dedicated to providing equal opportunities for all, regardless of race, gender, age, disability, or background. Join us in building a culture of belonging and mutual respect. What are we looking for :We are looking for a highly skilled Sr. QA Engineer (ETL) with extensive experience in database testing, ETL validation, and test data management. The ideal candidate will have strong expertise in writing and automating complex SQL scripts, ensuring data accuracy across platforms, and optimizing query performance. This role requires collaboration with business, product, and data platform teams to validate backend data processes and support seamless product development. A proven ability to mentor teams, handle large data volumes, and streamline QA automation is essential for success. Location : Hyderabad/ Gurgaon Roles & Responsibilities :- Experience in understanding ETL Source to Target Mapping Document and create 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 onshore team to make sure execution and reports are shared with business leads.- Automate the existing and new SQL scripts being developed during 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.Required Experience :- 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 Big Volume of data.- Experience on version control tools.- Good to have US healthcare experience- Good to have experience in Databricks- Good to have exposure to any AI/Automation toolsNon-Technical / Behavioural competencies required :- Must have worked with US based clients in onsite/off shore 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, self-starter, proactive, and an effective team player- Must have experience working under tight deadlines within a matrix organizational structure (ref:hirist.tech)