ETL QA Automation Engineer

Job Summary

Synechron is seeking a experienced and detail-oriented ETL QA Automation Engineer to develop enhance and execute automated testing solutions for data integration and data flow this role you will collaborate closely with data engineers QA teams and business stakeholders to validate data transformations ensure data quality and support continuous deployment of scalable ETL solutions. Your efforts will improve testing efficiency data integrity and system reliability supporting the organizations data-driven initiatives.

Software Requirements

Required Skills:

• Strong experience in ETL testing data validation and automation scripting

• Proficiency in SQL scripting and data validation for testing data transformations and flow

• Hands-on experience with Python for automation and scripting tasks

• Familiarity with data warehousing concepts and ETL workflows (Informatica Talend etc.)

• Knowledge of API testing and validation techniques

• Experience working with version control systems like Git and CI/CD pipelines (Jenkins Azure DevOps)

Preferred Skills:

• Knowledge of cloud data platforms (AWS Azure GCP) and their data services

• Experience with data modeling and data quality tools

• Familiarity with automation frameworks such as Robot Framework or Apache Airflow

• Experience with big data testing technologies (Hadoop Spark) is a plus

Overall Responsibilities

• Design and develop automated test scripts to validate ETL data flow and transformations

• Validate data quality consistency and integrity across multiple systems and platforms

• Perform root cause analysis and troubleshoot issues related to data discrepancies and process failures

• Maintain and enhance automation frameworks to support ongoing testing efforts

• Work closely with data engineers QA and product teams to align testing activities with project delivery timelines

• Generate detailed test reports defect logs and documentation to support ongoing quality assurance efforts

• Support and execute data migration validation system upgrades and process optimizations

• Contribute to continuous improvement initiatives in testing processes and tools

Technical Skills (By Category)

Languages & Tools:

• Required: SQL Python (preferred for scripting and test automation)

• Preferred: Shell scripting Java or other scripting languages for automation tasks

Data & Data Management:

• Required: Deep understanding of data warehouse concepts data validation and data integrity testing

• Preferred: Working knowledge of big data tools and platforms such as Hadoop Spark or Amazon Redshift

ETL & Data Integration:

• Required: Experience with ETL platforms such as Informatica Talend or similar tools

• Preferred: Support of complex workflows involving multiple data sources and destinations

Testing & Automation Frameworks:

• Required: Development and maintenance of automation scripts for data testing using tools like Python or Robot Framework

• Preferred: Familiarity with API testing tools like Postman RestAssured or similar

DevOps & Continuous Testing:

• Required: Experience integrating automated tests into CI/CD pipelines with Jenkins Azure DevOps or GitLab CI

• Preferred: Knowledge of containerization (Docker) and orchestration (Kubernetes) in testing environments

Experience Requirements

• Minimum 5 years of experience in data validation ETL testing or automation testing within data environments

• Proven track record in designing and executing automated testing strategies for ETL workflows

• Experience working with cross-functional data and QA teams in Agile projects

• Demonstrated ability to troubleshoot data and process issues effectively and deliver quality results

• Prior experience supporting data migration integration or big data projects is advantageous

Day-to-Day Activities

• Develop and automate data validation scripts for ETL testing covering data transformations and flow

• Investigate and resolve data discrepancies and failures in data pipelines or staging environments

• Collaborate with data engineers developers and QA teams to optimize test coverage and efficiency

• Support system upgrades patches and continuous deployment activities for data platforms

• Review existing automation frameworks refactor scripts and implement process improvements

• Generate detailed test reports defect logs and documentation for audit and compliance purposes

• Support data migration and data quality assurance activities during project rollouts

• Stay updated on the latest automation tools scripting techniques and industry best practices

Qualifications

• Bachelors or Masters degree in Computer Science Data Science Information Technology or related field

• Certifications in Data Testing ETL Tools (Informatica Talend) or Cloud Data Services are a plus

• Proven hands-on experience in automating ETL testing and data validation workflows for enterprise-scale systems

Professional Competencies

• Strong analytical and troubleshooting skills for data discrepancies

• Effective communication skills for working with technical and business stakeholders

• Ability to work independently and as part of a collaborative team in a fast-paced environment

• Strong attention to detail and adherence to quality standards

• Continuous learner eager to stay current with emerging data and automation technologies

• Process-oriented with a focus on efficiency accuracy and scalability

SYNECHRONS DIVERSITY & INCLUSION STATEMENT

Diversity & Inclusion are fundamental to our culture and Synechron is proud to be an equal opportunity workplace and is an affirmative action employer. Our Diversity Equity and Inclusion (DEI) initiative Same Difference is committed to fostering an inclusive culture promoting equality diversity and an environment that is respectful to all. We strongly believe that a diverse workforce helps build stronger successful businesses as a global company. We encourage applicants from across diverse backgrounds race ethnicities religion age marital status gender sexual orientations or disabilities to apply. We empower our global workforce by offering flexible workplace arrangements mentoring internal mobility learning and development programs and more.

All employment decisions at Synechron are based on business needs job requirements and individual qualifications without regard to the applicants gender gender identity sexual orientation race ethnicity disabled or veteran status or any other characteristic protected by law.

Candidate Application Notice