SpectraMedix named top value-based contract analytics solution provider by Healthcare Tech Outlook  >> Learn More

 

 

 

 

ROLE: LEAD QA ETL ENGINEER

EXPERIENCE: 7-10 YEARS

FULL TIME | SPECTRAMEDIX | GURUGRAM

 

DESCRIPTION:
REAL-TIME, ACTIONABLE ANALYTICS THAT FACILITATE HEALTHCARE ACCOUNTABILITY

 

Healthcare is in a state of transition. There’s never been more pressure to improve clinical, operational, and financial performance across the entire healthcare ecosystem as value-based payment model adoption grows. It all begins with data—data that lets you demonstrate improvement, gain actionable insight, and thrive in this new paradigm of care. SpectraMedix mission to assist our clients in their transition to value-based care contracts.

We are a leader in providing quality, population health, analytics and financial modelling and reconciliation in a single platform for health systems and health plans to improve outcomes and maximize incentives. We combine cutting edge technology with a team of experts to bring this unique solution to the healthcare space at a crucial juncture in its value-based care evolution.

We have well positioned our platform to power the journey for health systems, accountable care organizations and health plans moving towards value-based payment initiatives.

 

ROLE: LEAD QA ETL ENGINEER

EXPERIENCE: 7-10 YEARS

FULL TIME | SPECTRAMEDIX | GURUGRAM

 

We are seeking an experienced Lead QA ETL Testing Engineer who is proficient in Datawarehouse testing and Big Data testing to join our Gurgaon center.

 

ROLES & RESPONSIBILITIES (DETAILED PERTAINING TO THE ROLE):

  • 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/BR’s…etc
  • To Mentor the team and work with them to understand the business requirements and create SQL scripts according to business rules
  • Work closely with Data Platform, product, business teams and do all the B/E validations as part of QA delivery
  • 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 SKILL SET (MANDATORY SKILL SET):

  • Minimum 8 years of experience working in QA/ETL
  • Minimum 8 years of experience working in Test Data Management and Database testing
  • Strong experience in creating 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 in SQL Query Automation, SparkSQL
  • Experience on version control tools

 

GOOD TO HAVE:

  • Healthcare domain experience
  • Experience in Python/ PySpark
  • Experience with Databricks

 

OTHER SOFT SKILLS REQUIRED:

  • Analytical thinking
  • Good communication skills

 

Please email your resume to jobs@spectramedix.com