ETL Tester/ ETL QA
Apply on
Availability Status
This job is expected to be in high demand and may close soon. We’ll remove this job ad once it's closed.
Job Title: ETL Tester/ ETL QA
Location: NYC, NY [Remote]
Duration: Long term Contract
Skills: ETL Testing, SQL, AWS, Data Test Automation, DBT, Lakehouse Experience
JD:
Position Summary:
The ETL Tester is responsible for validating and verifying data extraction, transformation, and loading processes to ensure data accuracy and integrity. This role involves designing and executing test cases, identifying data quality issues, and collaborating with data engineers to resolve discrepancies. The ETL Tester will also develop automated testing frameworks to enhance testing efficiency and coverage. A strong understanding of ETL processes and data warehousing concepts is essential for success in this role.
Minimum Qualification:
- At least 10 years of IT experience with minimum 6 years of experience in below skills:
- Work experience in ETL testing
- Proficiency in SQL with ability to write complex queries in big data ecosystem.
- Should possess AWS Cloud experience.
- Extensive data analysis skills and knowledge in scripting to optimize data testing
- Good to have knowledge in Healthcare Insurance.
- Experience working 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 derive test scenarios
- Experience in developing and implementing test strategies for complex initiatives.
- 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 understand system requirements.
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)