What are the responsibilities and job description for the ETL Tester position at HSK Technologies Inc?
Job Title: ETL Tester with SQL and QA Expertise
Location: NJ
Client: SMBC
Employment Type: Contract W2
Job Summary
We are seeking a highly skilled and detail-oriented ETL Tester with strong expertise in SQL and Quality Assurance (QA) to join our team. The ideal candidate will have a deep understanding of ETL processes, data validation, and testing methodologies, with a proven track record of ensuring data integrity and accuracy in complex data warehouse environments.
Key Responsibilities
Design, develop, and execute test cases, test scripts, and test plans for ETL processes.
Perform data validation and verification between source systems and target data warehouses.
Test ETL mappings, workflows, and processes to ensure data accuracy, completeness, and quality.
Utilize SQL to write complex queries for data analysis, validation, and reporting.
Conduct functional, regression, integration, and performance testing for ETL processes.
Collaborate with developers, business analysts, and stakeholders to understand business requirements and data flow.
Log and track defects in testing tools, ensuring timely resolution and re-testing.
Prepare and maintain test data for various testing scenarios.
Document test results and provide detailed reports to stakeholders.
Continuously improve QA processes and frameworks to enhance testing efficiency.
Qualifications and Skills
Required:
Bachelor’s degree in Computer Science, Information Technology, or a related field.
3-5 years of experience as an ETL Tester or similar role.
Proficiency in SQL with the ability to write complex queries for data validation.
Strong understanding of ETL concepts, data warehousing, and data modeling.
Experience with ETL tools such as Informatica, Talend, SSIS, or equivalent.
Knowledge of QA methodologies, testing lifecycle, and defect tracking tools (e.g., JIRA, Bugzilla).
Excellent analytical, problem-solving, and communication skills.
Preferred:
Familiarity with BI tools like Tableau, Power BI, or similar.
Experience with cloud platforms such as AWS, Azure, or Google Cloud.
Certification in QA or data-related technologies (e.g., ISTQB, AWS Certified Data Analytics).