Lead SDET with ETL

Role: Lead SDET with ETL

Location: Fort Mill, SC

Must have financial/Baking Exp

Key Responsibilities

• Design & execute test plans for ETL/ELT workflows, data feeds, and batch extracts, ensuring comprehensive data validation
• Write and maintain manual and automated tests for data accuracy, completeness, and consistency against mapping documents and specification rules
• Develop SQL-based validation logic—supporting complex queries, joins, aggregates, and stored procedures—to verify data correctness
• Collaborate with data engineering, BI, architecture teams to identify and resolve data quality issues across data pipelines
• Develop or support CI/CD pipelines for automated data quality checks and data-flow validations
• Analyze test results, document defects, track resolution, and report status to stakeholders; act as advocate for quality in an Agile delivery process

Required Skills & Experience

• Bachelor’s or Master’s degree in Computer Science, Engineering, or related field
• 5–6+ years of experience in QA, SDET, or data quality roles—preferably in data engineering/test test automation in the financial services industry
• Strong programming and automation experience in Python or Java, with focus on testing frameworks and automation tools (e.g. Selenium, TestNG, Appium)
• Advanced SQL skills, capable of building complex queries to validate ETL, data loads, and data transformations
• Hands‑on with ETL/Database testing—manual & automated—covering batch pipelines, API integrations, and data feeds
• Experience with AWS-based data environments (e.g. S3, RDS, DynamoDB, Lambda, Snowflake, Redshift) and familiar in working with data lakes
• Knowledge of CI/CD tools (Jenkins, TeamCity, GitHub Actions, Octopus), test automation in pipelines, and Agile methodologies including Scrum ceremonies

Preferred Qualifications

• Familiarity with data quality tools, metrics frameworks, rule validation engines, or profiling platforms
• Exposure to big data technologies—such as Hadoop, Snowflake, DBT, Kafka, DBT, Airflow, FiveTran, PySpark—for data testing contexts
• Understanding of dimension modeling (star schema, SCD), data governance standards, metadata management, and change data capture patterns
• Financial services domain experience and familiarity with regulatory/operational compliance testing contexts