Lead QA Engineer (ETL)

SpectraMedix; Gurugram District; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

SpectraMedix in Gurugram is looking for a Lead QA Engineer specializing in ETL testing. You will lead a team, develop SQL scripts, and ensure quality in a hybrid work environment.

Applicants should have a minimum of 8 years of experience in database testing and be adept at problem-solving within an Agile framework. Strong communication and leadership skills are essential for success in this role.

Benefits include a supportive work culture and opportunities for growth.

Qualifications

• 8+ years of experience in database testing and SQL scripting.
• Strong experience in complex SQL queries and optimizations.
• Experience leading teams and managing quality initiatives.

Responsibilities

• Prepare QA documents and artifacts based on ETL mapping.
• Mentor team members and help them understand requirements.
• Develop SQL scripts according to business rules.

Skills

ETL testing

SQL scripting

Team leadership

Problem-solving

Agile methodologies

Education

Bachelor’s degree in Engineering or related discipline

Tools

JIRA

Bugzilla

TestRail

Job description

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.

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.

Position: Lead QA Engineer (ETL)

Location: Gurugram

Employment Type: Permanent

Work Mode: Hybrid

What Are We Looking For

SpectraMedix is seeking an experienced QA Lead with strong expertise in ETL testing, team leadership, test strategy, and quality assurance best practices. The ideal candidate should possess excellent communication skills, a problem‑solving mindset, and the ability to drive quality initiatives in an Agile environment.

Roles & Responsibilities

• Understand ETL source‑to‑target mapping documents and prepare QA documents and related artifacts accordingly
• Create test data for new features, data platform upgrades, and business requirements
• Mentor the team and help them understand business requirements
• Develop SQL scripts based on defined business rules
• Work closely with Data Platform, product, and business teams to complete back‑end validations as part of QA delivery
• Create ETL, database validation, and other QA scripts in the offshore team, and coordinate with the onshore team to ensure execution and reporting are shared with business leads
• Automate existing and newly developed SQL scripts during the product development and implementation lifecycle
• Perform data and portal testing in both UAT and production environments

Mandatory Skills

• Minimum 8 years of experience working in database testing and SQL scripting
• Strong experience in creating complex SQL queries and query optimizations
• Design, create and execute test cases for ETL and DB testing 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 SQL query automation
• Experience in leading and managing teams
• Experience with version control tools
• Strong problem‑solving and analytical skills

Good to Have

• Healthcare domain experience
• Knowledge of Spark SQL
• Some experience in Databricks
• Familiarity with tools like JIRA, Bugzilla, TestRail

Educational Qualification

• Bachelor’s degree in Engineering, Computer Applications, or a related discipline (B. Tech / B.Sc. / BCA)

Non‑Technical / Behavioral Competencies Required

• Having worked with US‑based clients in on‑site/off‑shore delivery model, will be a positive
• 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

Contact

Please email your resume to [e-mail] or [e-mail] to apply