Test Analyst (SDET) - Data
Apply NowCompany: Hexaware Technologies
Location: New York, NY 10025
Description:
Job Description
Job Description: ETL Tester The ETL Tester will play a critical role in ensuring the accuracy, reliability, and performance of data pipelines and transformations. The ideal candidate will have a strong understanding of ETL processes, data warehousing, and testing methodologies to validate data integrity and quality across systems. Key Responsibilities: Design, develop, and execute test plans, test cases, and test scripts for ETL processes and data pipelines. Validate data transformations, data mapping, and data integration workflows between source and target systems. Perform data quality checks and ensure data consistency, completeness, and accuracy. Collaborate with developers, business analysts, and stakeholders to understand ETL requirements and define testing strategies. Identify, document, and track defects, and work with the development team for resolution. Conduct regression testing and performance testing for ETL processes. Ensure compliance with data governance, security, and privacy standards. Create and maintain test documentation, including test plans, test results, and defect reports. Use SQL queries to validate data at various stages of the ETL process. Automate ETL testing processes using appropriate tools and frameworks. Required Skills and Qualifications: Strong experience in ETL testing, data validation, and data quality assurance. Proficiency in writing complex SQL queries for data validation and analysis. Hands-on experience with ETL tools such as Informatica, Talend, SSIS, or similar. Familiarity with data warehousing concepts, including star schema, snowflake schema, and dimensional modeling. Knowledge of testing tools like Selenium, JMeter, or similar (optional but preferred). Understanding of data governance, data security, and compliance standards. Excellent analytical and problem-solving skills. Strong communication skills to collaborate effectively with cross-functional teams.
Job Description: ETL Tester The ETL Tester will play a critical role in ensuring the accuracy, reliability, and performance of data pipelines and transformations. The ideal candidate will have a strong understanding of ETL processes, data warehousing, and testing methodologies to validate data integrity and quality across systems. Key Responsibilities: Design, develop, and execute test plans, test cases, and test scripts for ETL processes and data pipelines. Validate data transformations, data mapping, and data integration workflows between source and target systems. Perform data quality checks and ensure data consistency, completeness, and accuracy. Collaborate with developers, business analysts, and stakeholders to understand ETL requirements and define testing strategies. Identify, document, and track defects, and work with the development team for resolution. Conduct regression testing and performance testing for ETL processes. Ensure compliance with data governance, security, and privacy standards. Create and maintain test documentation, including test plans, test results, and defect reports. Use SQL queries to validate data at various stages of the ETL process. Automate ETL testing processes using appropriate tools and frameworks. Required Skills and Qualifications: Strong experience in ETL testing, data validation, and data quality assurance. Proficiency in writing complex SQL queries for data validation and analysis. Hands-on experience with ETL tools such as Informatica, Talend, SSIS, or similar. Familiarity with data warehousing concepts, including star schema, snowflake schema, and dimensional modeling. Knowledge of testing tools like Selenium, JMeter, or similar (optional but preferred). Understanding of data governance, data security, and compliance standards. Excellent analytical and problem-solving skills. Strong communication skills to collaborate effectively with cross-functional teams.