Sr. QA Engineer(ETL)

SpectraMedix; Hyderabad; On-site; INR 1,000,000 - 1,500,000; Full time

Job summary

A healthcare technology provider in Hyderabad seeks a highly skilled Senior QA Engineer (ETL). The ideal candidate must possess over 6 years of experience in QA/ETL, strong SQL scripting skills, and a proven ability to mentor teams. Responsibilities include automating ETL processes and validating data integrity. This position requires collaboration with cross-functional teams to ensure effective product development and data management.

Qualifications

• Minimum 6 years of experience in QA/ETL.
• Strong experience in creating and automating complex SQL queries.
• Experience in validating data reconciliation scripts.

Responsibilities

• Develop and maintain automated ETL test scripts.
• Create test data according to new features.
• Mentor the QA team and create test scripts.

Skills

SQL scripting

ETL validation

Database testing

Test data management

Tools

Databricks

Version control tools

Job description

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.

Our Values

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.

• 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 tools
  
• 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