Back to Jobs
Recently postedFull-timeTechnology

SDET / Data Test Automation Engineer

SynechronNorth Carolina🇺🇸United States

Quick overview

Salary$90k - $100k/yr
Employment typeFull-time
Work modeHybrid
LocationNorth Carolina, United States
SQLGitApache SparkAWSETLScrumSnowflakeAirflowApacheBlockchainDatabricksGitHub ActionsHadoopHiveJenkinsPostmanPythonpytestRESTAzureJiraAgileCI/CDAzure DevOps

Job description

Job Description

We are:

At Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital solutions. Synechron's progressive technologies and optimization strategies span end-to-end Artificial Intelligence, Consulting, Digital, Cloud & DevOps, Data, and Software Engineering, servicing an array of noteworthy financial services and technology firms. Through research and development initiatives in our FinLabs we develop solutions for modernization, from Artificial Intelligence and Blockchain to Data Science models, Digital Underwriting, mobile-first applications and more. Over the last 20+ years, our company has been honored with multiple employer awards, recognizing our commitment to our talented teams. With top clients to boast about, Synechron has a global workforce of 17,000+, and has 58 offices in 22 countries within key global markets.

Our challenge:

We are seeking a highly skilled SDET / Data Test Automation Engineer with expertise in data engineering, ETL/ELT testing, and data warehouse validation within enterprise-scale and financial services environments. The ideal candidate will be responsible for designing and implementing robust data testing frameworks, validating large-scale data pipelines, ensuring data quality, and integrating automated testing into CI/CD processes. This role requires strong proficiency in Python, SQL, PySpark, and modern cloud-based data platforms.

Additional Information

The base salary for this position will vary based on geography and other factors. In accordance with law, the base salary for this role if filled within Charlotte, NC is $90k - $100k/year & benefits (see below).

The Role:

Requirement:

Data Validation & Data Warehouse Testing

  • Perform end-to-end validation of ETL and ELT pipelines across source, staging, and target systems.
  • Verify source-to-target mappings, transformation rules, data completeness, accuracy, and reconciliation.
  • Execute schema validation, duplicate detection, null value checks, referential integrity testing, and data profiling.
  • Perform data reconciliation across multiple layers to ensure consistency and accuracy.
  • Validate batch and incremental data loads, including CDC (Change Data Capture) processes.

Test Automation Development

  • Design, develop, and maintain scalable PySpark-based test automation frameworks for large-volume data validation.
  • Implement automated data quality checks using DataFrame comparisons, row-count reconciliation, checksums, and business rule validations.
  • Create reusable test utilities and automation libraries using Python and PyTest.
  • Build automated regression suites for data pipelines and warehouse testing.

Data Quality & Governance

  • Implement and maintain data quality frameworks such as Great Expectations and custom PySpark-based validation engines.
  • Validate Slowly Changing Dimensions (SCD Type 1 and Type 2) implementations.
  • Develop automated checks for threshold validations, referential integrity, and business rule compliance.
  • Monitor and report data quality metrics across enterprise data platforms.

Big Data & Cloud Testing

  • Validate data processing workflows built on:
  • Apache Spark
  • Hadoop/HDFS
  • Hive
  • Databricks
  • Snowflake
  • Test cloud-based data platforms and pipelines across:
  • AWS (S3, Glue, EMR)
  • Azure (ADF, ADLS)
  • Ensure data integrity before and after transformations across cloud environments.

Workflow Orchestration Testing

  • Validate data workflows orchestrated using:
  • Apache Airflow
  • Autosys
  • Control-M
  • Ensure scheduling, dependency management, and execution accuracy of complex data pipelines.

API, Performance & Volume Testing

  • Perform API testing for data ingestion and integration services using:
  • Postman
  • Python Requests
  • REST Assured
  • Conduct performance, scalability, and volume testing for large-scale batch processes and data pipelines.
  • Identify bottlenecks and provide recommendations for optimization.

CI/CD & DevOps Integration

  • Integrate automated data testing into CI/CD pipelines.
  • Enable shift-left testing practices and automated regression validation.
  • Work with tools such as:
  • Jenkins
  • GitHub Actions
  • Azure DevOps
  • Collaborate with development teams to ensure quality gates are enforced throughout release cycles.

Test Management & Agile Delivery

  • Develop test strategies, test plans, test cases, and validation approaches for data programs.
  • Maintain Requirement Traceability Matrices (RTMs).
  • Manage defects, test execution, and reporting using:
  • JIRA
  • Zephyr
  • qTest
  • ALM
  • Participate actively in Agile/Scrum ceremonies and collaborate with Product Owners, Business Analysts, and Data Engineers.

Required Skills:

  • Bachelor's degree in Computer Science, Information Technology, Engineering, or related field.
  • 6+ years of experience in Software Testing, SDET, Data Testing, or Test Automation roles.
  • Strong hands-on experience in ETL/ELT testing and Data Warehouse testing.
  • Proficiency in Python, SQL, and PySpark.
  • Experience building scalable automation frameworks for data validation.
  • Hands-on experience with Databricks, Snowflake, Spark, Hive, Hadoop/HDFS.
  • Experience validating cloud-based data platforms on AWS and/or Azure.
  • Strong understanding of data modeling concepts and data warehousing architectures.
  • Experience with CI/CD tools and automated testing integration.
  • Working knowledge of API testing methodologies and tools.

Preferred Qualifications:

  • Experience in Banking, Financial Services, Insurance (BFSI), or other highly regulated industries.
  • Experience with Data Governance and Data Quality initiatives.
  • Knowledge of modern Data Lake and Lakehouse architectures.
  • Exposure to data observability platforms and metadata-driven testing.
  • Relevant certifications in AWS, Azure, Databricks, Snowflake, or Test Automation.

We offer:

A highly competitive compensation and benefits package.

A multinational organization with 58 offices in 22 countries and the possibility to work abroad.

10 days of paid annual leave (plus sick leave and national holidays).

Maternity & paternity leave plans.

A comprehensive insurance plan including medical, dental, vision, life insurance, and long-/short-term disability (plans vary by region).

Retirement savings plans.

A higher education certification policy.

Commuter benefits (varies by region).

Extensive training opportunities, focused on skills, substantive knowledge, and personal development.

On-demand Udemy for Business for all Synechron employees with free access to more than 5000 curated courses.

Coaching opportunities with experienced colleagues from our Financial Innovation Labs (FinLabs) and Center of Excellences (CoE) groups.

Cutting edge projects at the world's leading tier-one banks, financial institutions and insurance firms.

A flat and approachable organization.

A truly diverse, fun-loving, and global work culture.

SYNECHRON'S 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 applicant's gender, gender identity, sexual orientation, race, ethnicity, disabled or veteran status, or any other characteristic protected by law.

Will your resume get past this employer's screening? Check your resume against this job, free

Similar jobs