ETL SDET with Pyspark

ETL SDET with Pyspark

Posted 4 days ago by 1759492291

Negotiable
Outside
Remote
USA

Summary: The ETL SDET with Pyspark role focuses on ensuring the quality and reliability of ETL processes and data integration workflows through automated testing. The position requires collaboration with data engineers and developers to address data quality issues while leveraging expertise in ETL testing and data validation. The ideal candidate will have extensive experience in automation frameworks and strong SQL skills, particularly in cloud environments. This is a remote contract position with a focus on enhancing data pipeline performance and integrity.

Key Responsibilities:

  • Review requirements specifications and technical design documents to understand and provide feedback.
  • Develop and implement 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.
  • 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.

Key Skills:

  • At least 10 years of IT experience with a minimum of 5 years in ETL testing and automation framework development.
  • Proficiency in ETL Testing and developing automation framework test cases in at least one scripting language.
  • Mandatory experience in Pyspark.
  • Strong SQL skills with experience in handling big data using ETL tools (e.g., Informatica).
  • Testing experience in cloud environments (AWS S3).
  • Experience with Test Automation and DevOps practices in ETL and Cloud.
  • Experience providing testing oversight in Agile teams.
  • Excellent business communication skills to interact with business and cross-functional teams.

Salary (Rate): undetermined

City: undetermined

Country: USA

Working Arrangements: remote

IR35 Status: outside IR35

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:

ETL SDET with Pyspark Coding Experience

Location

NYC, NY (Remote)

Duration

Contract

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 10 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

Experience in Pypark is Mandatory

Strong SQL skill with experience in handling big data using ETL tools eg Informatica

Testing experience in cloud environment AWS s3

Experience with Test Automation and DevOps practices in ETL and Cloud

Experience providing testing oversight in Agile team

Should have excellent business communication to interact with Business teams and crossfunctional 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