ETL SDET Job at Purple Drive, New York, NY

b0s1RVNQS1p4ZDFIc2VicjVyY01MTUVYT0E9PQ==
  • Purple Drive
  • New York, NY

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.

Job Tags

Work experience placement,

Similar Jobs

The Sheridan at Green Oaks

Security Guard Job at The Sheridan at Green Oaks

 ...you will be responsible for maintaining a secure environment for all employees and...  ...Description Part Time Overnight Security Guard - $19 per hour Secure all areas of the...  ...situations. Qualifications No experience necessary, although previous experience in... 

FGS LLC

Audio Visual Engineer Job at FGS LLC

 ...School or equivalent Salary Band - $95,000 to $110,000 Job Description: The successful candidate will support the Audiovisual Engineering team by providing design packages, review construction drawings for new MILCONS, Develop material equipment lists, and interface... 

Maple Village Waldorf Schoool

Spanish Teacher - 2026-27 Job at Maple Village Waldorf Schoool

 ...As a member of the faculty at Maple Village Waldorf School, the Spanish Teacher is responsible for the Spanish education of elementary and...  ...for partial school days. Our school was recently one of six private schools in the country to be named a U.S. Department of Education... 

Gordon Food Service

Full Time - 2nd Shift Warehouse Package Handler Job at Gordon Food Service

 ...of who we are and the impact you could have on the food service industry. There's a seat at our table for you... 2nd Shift Warehouse Package Handler - Full Time Distribution Center Address: Springfield, OH Pay: Starting at $21.13/hour (includes a $1.00 2nd shift... 

Taco Bell

Assistant General Manager Job at Taco Bell

 ...Taco Bell? Taco Bell is a leading Mexican-inspired quick service restaurant brand that is a part of Yum! Brands, Inc. which includes Pizza Hut and KFC. Founded on innovation and passion with Glen Bell bringing tacos to the masses in a world of hot dog and hamburger stands...