QA Engineer – Data & ETL Testing

Important Information:

• Years of Experience: 5+ years

• Job Mode: Full-time

• Work Mode: Remote

• Job Name: QA Engineer – Data & ETL Testing

Job Summary:
We are seeking a skilled QA Engineer to join our team and take ownership of validating data pipelines and ETL workflows in a cloud-based environment. The ideal candidate will be proficient in SQL, data testing, and cloud-based data platforms, and will contribute to the reliability and accuracy of data across our systems. This role requires a collaborative mindset and a passion for quality assurance in data-driven applications.

Responsibilities and Duties:

• Design and execute test scenarios and validation strategies for data pipelines.

• Manage and prepare test data using platforms such as MS SQL Server, MySQL, Hive, RDS, and DBeaver.

• Perform end-to-end testing of data ingestion processes from diverse sources (Source DBs, Kafka, Files) to target systems.

• Leverage AWS services such as Athena, Redshift, Glue, S3, Airflow, and EC2 for testing data workflows.

• Analyze test results, identify issues, and collaborate with development teams to drive resolution.

• Conduct REST API testing using tools such as Swagger.

• Support CI/CD efforts using Jenkins, Bitbucket, and Harness.

• Work within large-scale data environments including Hadoop.

Qualifications and Skills:

• Strong hands-on experience in ETL testing and SQL.

• Expertise in validating data pipelines and ensuring data quality.

• Familiarity with cloud-based environments, particularly AWS.

• Solid understanding of various data storage and processing technologies.

• Experience in testing APIs and managing automated testing tools.

• Familiarity with version control and CI/CD systems.

Role-specific Requirements:

• Proficiency in working with diverse database systems such as MS SQL Server, MySQL, Hive, and RDS.

• Experience analyzing workflows and test data using tools like DBeaver.

• Ability to identify and resolve data quality issues across complex pipelines.

• Exposure to AWS-based data environments and pipeline orchestration tools.

Technologies:

• Databases: MS SQL Server, MySQL, Hive, RDS

• Tools: DBeaver, Swagger, Jenkins, Bitbucket, Harness

• Cloud: AWS (Athena, Redshift, Glue, S3, EC2, Airflow)

• Data Ecosystem: Hadoop, Kafka, File-based ingestion

Skillset Competencies:

• ETL Process Validation

• Advanced SQL for Data Testing

• API Testing and Automation

• CI/CD Integration and Version Control

• Cloud-based Data Quality Assurance

• Cross-functional Collaboration

Nice to Have:

• Experience with a programming language such as Python or Java

• Familiarity with API testing tools like ReadyAPI

About Encora
Encora is the preferred digital engineering and modernization partner of some of the world’s leading enterprises and digital-native companies. With over 9,000 experts in 47+ offices and innovation labs worldwide, Encora’s technology practices include Product Engineering & Development, Cloud Services, Quality Engineering, DevSecOps, Data & Analytics, Digital Experience, Cybersecurity, and AI & LLM Engineering.

At Encora, we hire professionals based solely on their skills and qualifications, and do not discriminate based on age, disability, religion, gender, sexual orientation, socioeconomic status, or nationality.