← Back to jobsJob ID col-cmwp68dgh06k4d8ha2n64bsvz

SynechronPosted 1 day ago

SDET / Data Test Automation EngineerNew

Full-time
On-site
6+ years
$90K – $100K/yr
Posted 1 day ago

Synechron is seeking an SDET / Data Test Automation Engineer to build and maintain automated data-testing frameworks and validate enterprise data pipelines and warehouses. The role focuses on data quality, cloud and big-data testing, CI/CD integration, and test delivery in financial-services environments.

Posted
1 day ago
Source
ziprecruiter.com
Sector
Information Technology & AI

Opens the employer's application page in a new tab

Responsibilities

  • 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
  • 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
  • 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
  • Validate data processing workflows built on:
  • Test cloud-based data platforms and pipelines across:
  • Ensure data integrity before and after transformations across cloud environments
  • Validate data workflows orchestrated using:
  • Ensure scheduling, dependency management, and execution accuracy of complex data pipelines
  • Perform API testing for data ingestion and integration services using:
  • Conduct performance, scalability, and volume testing for large-scale batch processes and data pipelines
  • Identify bottlenecks and provide recommendations for optimization
  • Integrate automated data testing into CI/CD pipelines
  • Enable shift-left testing practices and automated regression validation
  • Work with tools such as:
  • Collaborate with development teams to ensure quality gates are enforced throughout release cycles
  • 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:
  • Participate actively in Agile/Scrum ceremonies and collaborate with Product Owners, Business Analysts, and Data Engineers

Qualifications

  • expertise in data engineering, ETL/ELT testing, and data warehouse validation within enterprise-scale and financial services environments
  • strong proficiency in Python, SQL, PySpark, and modern cloud-based data platforms
  • 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

  • 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
  • BFSI Industry Experience
  • Regulated Industry Experience

Required skills

AWSApache SparkAzureData Warehouse TestingDatabricksETL/ELT TestingHadoop/HDFSHivePySparkPythonSQLSnowflake

Full job description

Synechron is seeking an SDET / Data Test Automation Engineer to build and maintain automated data-testing frameworks and validate enterprise data pipelines and warehouses. The role focuses on data quality, cloud and big-data testing, CI/CD integration, and test delivery in financial-services environments.

Responsibilities

  • 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
  • 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
  • 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
  • Validate data processing workflows built on:
  • Test cloud-based data platforms and pipelines across:
  • Ensure data integrity before and after transformations across cloud environments
  • Validate data workflows orchestrated using:
  • Ensure scheduling, dependency management, and execution accuracy of complex data pipelines
  • Perform API testing for data ingestion and integration services using:
  • Conduct performance, scalability, and volume testing for large-scale batch processes and data pipelines
  • Identify bottlenecks and provide recommendations for optimization
  • Integrate automated data testing into CI/CD pipelines
  • Enable shift-left testing practices and automated regression validation
  • Work with tools such as:
  • Collaborate with development teams to ensure quality gates are enforced throughout release cycles
  • 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:
  • Participate actively in Agile/Scrum ceremonies and collaborate with Product Owners, Business Analysts, and Data Engineers

Preferred

  • 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
  • BFSI Industry Experience
  • Regulated Industry Experience
  • Data Governance
  • Data Quality
  • Data Lake Architecture
  • Lakehouse Architecture
  • Data Observability Platforms
  • Metadata-Driven Testing
  • AWS Certification
  • Azure Certification
  • Databricks Certification
  • Snowflake Certification
  • Test Automation Certification

Benefits

  • 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.
  • Flexible workplace arrangements.
  • Mentoring.
  • Internal mobility.
  • Learning and development programs.

Company

  • Digital consulting for financial services and technology firms
  • New York, New York, USA
  • http://www.synechron.com/
  • Founded in 2001
  • 10001+ employees

Qualifications

  • highly skilled
  • expertise in data engineering, ETL/ELT testing, and data warehouse validation within enterprise-scale and financial services environments
  • strong proficiency in Python, SQL, PySpark, and modern cloud-based data platforms
  • 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
  • Highly skilled
  • Expertise in data engineering, ETL/ELT testing, and data warehouse validation within enterprise-scale and financial services environments
  • Strong proficiency in Python, SQL, PySpark, and modern cloud-based data platforms
  • 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
  • 6+ years of experience in Software Testing, SDET, Data Testing, or Test Automation roles.

Required skills

  • AWS, Apache Spark, Azure, Data Warehouse Testing, Databricks, ETL/ELT Testing, Hadoop/HDFS, Hive, PySpark, Python, SQL, Snowflake

Preferred skills

  • Experience with Data Governance and Data Quality initiatives, Knowledge of modern Data Lake and Lakehouse architectures

Experience

  • 6+ years

Job details

Employment type

Full-time

Seniority level

6+ years

Date posted

Nov 19, 2026

Work mode

On-site

Job source

ziprecruiter.com

Company

Synechron

Information Technology & AI

Digital consulting for financial services and technology firms

See all 10 jobs from Synechron →
  • New York, New York, USA
  • Information Technology & AI
  • 10001+ employees
  • Founded 2001
  • synechron.com

Similar jobs

Matched on role, skills and location · live jobs only

See more Automation Test Engineer jobs in Charlotte

iManage

Today

New

Software Engineer (Test Automation)

Full-timeHybridChicago, IL$80K – $100K/yr

iManage is a SaaS company providing a secure, cloud-enabled knowledge work platform. The company is seeking a Software Engineer to build and maintain automated testing frameworks for Windows desktop applications, integrate test suites into CI workflows,…

Why similarSame rolePython

Global business and IT solutions provider

4d ago

Power System Engineer

Full-timeHybridTaylor County, TXCompetitive

Agile Global Solutions, Inc is hiring a Power System Engineer. The role focuses on power-system modeling and analysis, including generator performance, dynamic stability, large-load impacts, and transmission planning.

Why similarSame rolePython

Lockheed Martin

1d ago

New

Quality Engineer - E2

Full-timeOn-siteBethesda, MD$70K – $131K/yr

Lockheed Martin is hiring a Quality Engineer to apply quality principles across product and process quality for space programs.

Why similarSame role

Get new Automation Test Engineer jobs in Charlotte by email

Create job alert

SDET / Data Test Automation Engineer

Synechron · $90K – $100K/yr

Apply on company site