ETL SDET

Purple Drive Technologies

$100K — $130K *
Information Technology
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • 8+ years of IT experience, with 5+ years in ETL testing and automation.
  • Proficient in scripting and building automation test cases.
  • Strong SQL skills and experience with big data ETL tools such as Informatica.
  • Experience testing in cloud environments, specifically AWS S3.
  • Familiar with DevOps practices in testing and cloud environments.
  • Experience in data lakehouse ecosystems for big data processing.
  • Excellent business communication skills for cross-functional collaboration.

Responsibilities

  • Review and provide feedback on requirements and design documentation.
  • Develop and implement complex test strategies and test plans.
  • Estimate, prioritize, and coordinate testing tasks effectively.
  • Create and maintain a robust automation test framework.
  • Design, execute, and manage automation scripts for testing processes.
  • Identify and document bugs thoroughly, managing defect tracking.
  • Perform regression testing to ensure bug fixes and features meet standards.
  • Develop and enforce testing processes for both new and existing features.
  • Collaborate with cross-functional teams to ascertain technical requirements.
  • Track and analyze quality assurance metrics, including defect densities.
  • Stay updated with evolving testing tools and strategies.
  • Mentor and support junior team members in testing processes.

Benefits

  • Collaborative work environment with cross-functional teams.
  • Opportunities for professional growth and mentoring junior staff.
  • Exposure to cloud technologies and big data ecosystems.
  • Involvement in Agile methodologies and DevOps practices.
Full 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.

Similar Jobs

More Jobs at Purple Drive Technologies

  • .NET AI Engineer
    $100K — $130K *
    San Antonio, TX 78228 (Bexar County)
    Information Technology
    In-Person
  • GRC Engineer
    $120K — $150K *
    San Jose, CA 95123 (Santa Clara County)
    Information Technology
    In-Person
  • HRSD Architect
    $100K — $130K *
    Raritan, NJ 08869 (Somerset County)
    Information Technology
    In-Person
  • Data Modeler
    $100K — $130K *
    Los Angeles, CA 90011 (Los Angeles County)
    Finance & Insurance
    In-Person
  • MacOS QA - Automation Engineer
    $100K — $130K *
    Austin, TX 78745 (Travis County)
    Information Technology
    In-Person

More Information Technology Jobs

Find similar ETL SDET jobs: