Software Engineer in Test (ETL)
- ON, Canada
- Ontario, Canada, Canada
Contract
Applications open in a new tab.
Job details
- Job type
- Contract
- Experience
- Experience: 8–10 years
- Posting language
- English
- Posted
Original job description
Job Title: Senior SDET / ETL Test Automation Engineer
Experience: 8–10 years
Domain: Healthcare / Healthcare Payer / Provider
Job Summary
We are looking for a Senior SDET / ETL Test Automation Engineer with strong experience in software development, test automation, ETL/data validation, APIs, databases, and healthcare applications.
The candidate should be hands-on with Python or Java development, automation framework design, SQL, ETL/ELT pipeline testing, API testing, CI/CD, and healthcare data. Experience with HL7, FHIR, X12, EHR/EMR, claims, eligibility, member, provider, and encounter data is highly desirable.
Key Responsibilities
- Design, develop, and maintain automated testing frameworks using Python/Java.
- Develop reusable automation libraries, utilities, test frameworks, and data-validation tools.
- Perform ETL/ELT testing across source, staging, warehouse, and target systems.
- Validate source-to-target mappings, transformations, business rules, aggregations, and data reconciliation.
- Write complex SQL queries for data validation, reconciliation, data quality, and defect analysis.
- Develop Python utilities for automated ETL/data-quality testing and large-volume data validation.
- Automate REST/SOAP API testing using tools such as RestAssured, Postman/Newman, or Python frameworks.
- Perform UI, API, database, integration, regression, and end-to-end testing.
- Validate healthcare data exchanged through HL7/FHIR interfaces.
- Work with healthcare datasets such as:
- Claims
Development Experience – Must Have
The candidate should have genuine software development experience, not only manual testing experience.
- Strong programming experience in Python or Java.
- Object-oriented programming concepts.
- Data structures and exception handling.
- Writing reusable libraries and utilities.
- REST API/microservices development or integration experience.
- Git and branching strategies.
- Unit testing using PyTest/unittest/JUnit/TestNG.
- Design patterns and clean-code principles.
- Debugging and troubleshooting application code.
- Experience working with CI/CD pipelines.
- Knowledge of Docker/cloud environments is preferred.
Healthcare development roles are increasingly combining Python, REST APIs, ETL pipelines, SQL, cloud platforms, and interoperability standards such as HL7/FHIR. IIndeed
More about this job
Responsibilities
Design and maintain automated testing frameworks for ETL pipelines and APIs using Python or Java. Validate healthcare data transformations and source-to-target mappings across warehouse systems.
Requirements
Requires 8-10 years of experience with strong software development skills in Python or Java and expertise in SQL and ETL testing. Proficiency in healthcare interoperability standards like HL7 and FHIR is highly desired.
Skills
- Python
- Java
- ETL Testing
- SQL
- API Testing
- CI/CD
- HL7
- FHIR
- X12
- Automation Framework Design
- Data Validation
- REST API
- Docker
- JUnit
- PyTest
- Object-Oriented Programming
Visa sponsorship
Not detected in the job text
Categories
- Software
- Technology
- Healthcare
- Data & Analytics
- Engineering
Keywords
- Python
- Java
- ETL
- ELT
- SQL
- API Testing
- RestAssured
- Postman
- Newman
- HL7
- FHIR
- X12
- EHR
- EMR
- CI/CD
- Docker
- PyTest
- JUnit
- TestNG
- Git
- Healthcare Payer
- Healthcare Provider
- Data Reconciliation
- Microservices
- Object-Oriented Programming
- Data Structures
- Clean Code
- Integration Testing
- Regression Testing
- End-to-End Testing