SDET

Overview

Remote
On Site
Full Time
Part Time
Accepts corp to corp applications
Contract - Independent
Contract - W2

Skills

ETL Testing
ETL
SDET

Job Details

ETL SDET with Strong Development Experience -

NYC, NY (Remote)

Must-Have Skills:

  • ETL Testing, Python/PySpark
  • AWS S3, Redshift
  • Informatica, Complex SQL

Good to Have:

  • Kafka, Shell scripting, Healthcare domain

Note: Only ETL SDET profiles will be considered.

Important:

  • All the skills mentioned in the skill matrix must be clearly highlighted in the candidate's resume.
  • Resumes without the required skills and experience explicitly mentioned will be treated as invalid and will not be considered.

Skill Matrix


Skills

Years of Exp

Year lastly Used

Rating Out of 10

SDET (MUST)

ETL (MUST)

Python

Pyspark

AWS S3

Redshift

Informatica

Strong SQL Skill

Kafka

Shell scripting

Healthcare experience


Position Details

Requirement

Role

ETL SDET with Strong Development Experience

Location

Remote)

Type of Hire - Contract/ C2H

Long-term

Rate (Max)

Only w2

Duration

C2H

Number of Interviews

L1+HR+Client

In person interviews Yes/No

No

Client Interview Yes/No

Yes

Position requirements (Remote/ Hybrid/Fully onsite)

Remote

Job Description

Position Summary:

The SDET (Software Development Engineer in Test) is responsible for ensuring the quality and reliability of ETL processes and data integration workflows.

This role involves designing and implementing automated tests to validate data transformation and migration, as well as collaborating with data engineers and developers to identify and resolve data quality issues.

The ideal candidate will leverage their expertise in ETL testing and data validation to enhance the overall data pipeline performance and integrity.

Minimum Qualification:

  • At least 8 years of IT experience with minimum 5 years of experience in below skills:
  • Tech Skills
    • Proficiency in ETL Testing and developing automation framework & testcases in atleast one scripting language.
    • Strong SQL skills, with experience in handling big data using ETL tools (e.g., Informatica).
    • Testing experience in cloud environment (AWS s3)
    • Experience with Test Automation and DevOps practices in ETL and Cloud
    • Work experience in a Big Data ecosystem processing data in data lakehouse.
    • Familiarity with DBT (Data Build Tool) or similar data transformation tools is a plus.
  • Experience providing testing oversight in Agile team.
  • Should have excellent business communication to interact with Business teams and cross-functional teams.

Responsibilities:

  • Review requirements, specifications, and technical design documents to understand and feedback.
  • Experience in developing and implementing test strategies for complex initiatives.
  • Estimate, prioritize, plan and coordinate testing activities.
  • Create automation test framework.
  • Design, develop and execute automation scripts.
  • Identify, record, document thoroughly and track bugs.
  • Strong problem-solving skills, troubleshooting, and root cause analysis skills.
  • Perform thorough regression testing when bugs are resolved.
  • Develop and apply testing processes for new and existing features to meet client needs.
  • Liaise with cross functional teams to identify system requirements.
  • Track quality assurance metrics, like defect densities and open defect counts.
  • Stay up to date with new testing tools and test strategies requirements.
  • Support and guide junior team members.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.