What are the responsibilities and job description for the Software Test Automation Engineer position at Avtech Solutions?
Job Details
Test Automation Engineer:
Test Automation Engineer in a data migration project is responsible for designing and implementing automated test frameworks to validate data accuracy, integrity, and consistency between the source and target systems. The Automaton Engineer develop and execute automated scripts for data reconciliation, schema validation, performance testing, and error detection. The automation engineer collaborate with Data Engineers and DBAs to identify migration issues early, ensure compliance with business rules, and enhance the efficiency of the testing process, reducing manual effort and ensuring a smooth transition.
Technical Skills:
- Experience with automation frameworks for database testing such as Selenium (for UI-based DB validation), PyTest, or JUnit.
- Proficiency in Python, Java, or PowerShell for writing automated data validation scripts.
- Hands-on experience with SQL automation tools like dbFit, QuerySurge, or Toad Data Point Automation.
- Familiarity with ETL testing and tools such as Informatica, Talend, or SSIS.
- Ability to test data transformation logic, mapping rules, and data quality checks in ETL pipelines.
- Experience with automated reconciliation scripts to compare row counts, data mismatches, and duplicates.