ETL SDET with Strong Development Experience
Posted 1 day ago by Alchemy Software Solutions LLC
Negotiable
Undetermined
Remote
Remote
Summary: The role of ETL SDET with Strong Development Experience focuses on ensuring the quality and reliability of ETL processes and data integration workflows. The candidate will design and implement automated tests, collaborate with data engineers and developers, and leverage their expertise in ETL testing to enhance data pipeline performance. A minimum of 10 years of experience is required, with a strong emphasis on ETL testing and automation. This position is remote and seeks a highly skilled individual to contribute to the organization's data quality initiatives.
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:
- ETL Testing, Python/PySpark
- AWS S3, Redshift
- Complex SQL
- Kafka, Shell scripting, Healthcare domain
- Proficiency in developing automation frameworks and test cases in at least one scripting language.
- Experience in cloud environments (AWS S3).
- Testing experience in Agile teams.
- Excellent business communication skills.
Salary (Rate): undetermined
City: undetermined
Country: undetermined
Working Arrangements: remote
IR35 Status: undetermined
Seniority Level: undetermined
Industry: IT
Role: ETL SDET with Strong Development Experience
Location: NYC, NY (Remote)
We have an urgent ETL SDET requirement. Please share profiles with 10+ years of experience.
Must-Have Skills:
- ETL Testing, Python/PySpark
- AWS S3, Redshift
- Complex SQL
Good to Have:
- Kafka, Shell scripting, Healthcare domain
Note: Only ETL SDET profiles will be considered.
Skill Matrix
Skills | Years of Exp | Year lastly Used | Rating Out of 10 |
SDET (MUST) |
|
|
|
ETL (MUST) |
|
|
|
Python |
|
|
|
Pyspark |
|
|
|
AWS S3 |
|
|
|
Strong SQL |
|
|
|
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.
Alchemy: Transforming Your Professional Vision into Reality
Since our inception in 2013, Alchemy has been dedicated to reshaping organizational performance through innovative IT services. With a vision to empower businesses seeking a transformative edge, we ve positioned ourselves at the forefront of digitization and software modernization.
Our name reflects our mission: to transmute technology into gold-standard solutions for our esteemed clients. We proudly serve a diverse range of sectors, including IT and ITES, BFSI, Telecom and Media, Automotive, Manufacturing, Energy, Oil and Gas, Real Estate, Retail, Healthcare, and more.
With a global footprint spanning the USA, India, Europe, Canada, Singapore, Japan, and parts of Central and West Africa, we harness a unique blend of competencies, frameworks, and cutting-edge technologies. Together, we drive growth and innovation across industries, helping organizations turn their visions into reality.
Alchemy Connecting Talent with Opportunities (Diversity, Equity and Inclusion)