Role & seniority: ETL Tester (senior level; 10+ years IT experience; 6+ years in ETL testing)

Stack/tools: ETL testing; SQL (complex queries); Big Data ecosystem; AWS Cloud; scripting; automation testing frameworks

Top 3 responsibilities

Review requirements, specs, and design docs to derive test scenarios
Design, develop, and execute test strategies and automation scripts
Validate ETL processes, identify data quality issues, and track/resolution of defects with data engineers

Must-have skills

10+ years IT experience with 6+ years in ETL testing
Proficiency in SQL (complex queries) and big data context
AWS Cloud experience; strong data analysis and scripting for data testing
Experience in Agile environments; excellent business communication

Nice-to-haves

Healthcare insurance domain knowledge
Location & work type: New York, NY (Remote); Contract role

Full Description

Net2Source Inc. is an award-winning total workforce solutions company recognized by Staffing Industry Analysts for our accelerated growth of 300% in the last 3 years with over 5500+ employees globally, with over 30+ locations in the US and global operations in 32 countries. We believe in providing staffing solutions to address the current talent gap - Right Talent - Right Time - Right Place - Right Price and acting as a Career Coach to our consultants.

Job Title: ETL Tester

Location: NYC, NY (Remote)

Type: Contract

Role Specific Responsibilities Include

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.

Why work with us - At Net2Source, we believe everyone has an opportunity to lead. We see the importance of your perspective and your ability to create value. We want you to fit in—with an inclusive culture, focus on work-life fit and well-being, and a supportive, connected environment; but we also want you to stand out—with opportunities to have a strategic impact, innovate, and take necessary steps to make your mark. We help clients with new skilling, talent strategy, leadership development, employee experience, transformational change management, and beyond.

ETL Tester