ETL SDET Job at Purple Drive, New York, NY

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

Worldwide Flight Services

Passenger Service Agent Job at Worldwide Flight Services

 ...in your career and join Worldwide Flight Services. WFS employs over 22,200 of the finest...  ...capability that includes Aviation cargo, Airline passenger, and Aviation ramp services. Our team of...  ...instructions from supervisor or lead agent.* Ability to work as an effective team... 

The Crossing Church

Music Director Job at The Crossing Church

 ...experience the message of Jesus in practical and life-changing ways. Music Director. .....is a full-time position that willoversee the...  ...song and music ideas to programmingwriting, recording, and producing demos when necessary Oversee the execution of all worship-... 

Nanning Zest Global HR Co.,Ltd.

Japenese/German/French/Spanish teacher needed in Beijing Foreign Language school Job at Nanning Zest Global HR Co.,Ltd.

Requirements:1; Japenese/ German/French /Spanish as native language, below 58 years old2; BA or above3; teaching certificates 4; have Japenese/Genman/French /Spanish/ English teaching experience preferred 5; physically and mentally healthy6; love kids, enjoy teaching...

Hampton Inn & Suites Speedway

Hotel Housekeeper Job at Hampton Inn & Suites Speedway

 ...their home away from home, be it for a night or a week, and its perfect. Everything...  ...good hands while staying with us. As a Hotel Housekeeper, your contribution helps ensure guests...  ...Associate DiscountsSchedule: * Day Shifts* Weekend Availability* Flexible... 

Colgate-Palmolive Company

Process Operator Job at Colgate-Palmolive Company

 ...Colgate-Palmolive Company is a global consumer products company operating in over 200 countries specializing in Oral Care, Personal Care,...  ...healthier future for all. This role is a multi-purpose process position in the manufacturing processes that is either process...