Job description
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.
