ETL SDET Job at Purple Drive, New York, NY

aGpOemZzTWhPQ3R4NCtRVlhyQmYxaFpydEE9PQ==
  • 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

Morgan, Lewis & Bockius LLP

Junior Full Stack Software Developer Job at Morgan, Lewis & Bockius LLP

 ...is seeking to hire a motivated Junior Full-Stack Developer to support the development of modern, cloud-based web applications. This role is ideal for someone early...  ...our Philadelphia office with a hybrid in-office/remote working schedule Key Responsibilities Front... 

WakeMed Health & Hospitals

Registered Nurse (RN) - Mother/Baby Job at WakeMed Health & Hospitals

 ...and the Clinical Nurse collaborate in the delivery of care.Department Description: Nursing Benefits/Highlights: Career Ladder RN I IV, depending on education and experience Sign-On Bonus and/or Relocation Incentive available for select positions Competitive... 

Pacsun

Assistant Designer - Women's Textiles and Graphics Job at Pacsun

Assistant Designer - Women's Textiles and GraphicsJoin the Pacsun Community Co-created in Los Angeles, Pacsun inspires the next generation...  ...on multiple floors throughout building. Hotel, Airplane, and Car Travel may be required.Position Type/Expected Hours of Work:... 

Zetrick LLC

Mail Carrier Job at Zetrick LLC

 ...industry looks forward to continued growth and job security. We invite you to join our team and work independently at your local post office for your local community! What We Offer Healthcare benefits available for most employees 401k Bi-weekly Pay Vehicle... 

Hilton Grand Vacations

Inbound Sales Agent Job at Hilton Grand Vacations

Inbound Sales Agent Location Orlando, FL (Metro West area) : At Hilton Grand Vacations you will lead future and existing Club Members to their ultimate vacation lifestyle by joining our world-class Call Center Team. With more than 325,000 Club Members, a remarkable global...