Junior Etl Tester

As a Junior ETL Tester with 13 years of experience, your role will involve validating and ensuring the accuracy, completeness, and reliability of data integration processes across source and target systems. You will be responsible for understanding ETL requirements, executing test cases, validating data transformations using SQL queries, and supporting testing activities throughout the data pipeline. **Key Responsibilities:** - Understand ETL requirements, data mappings, and transformation logic. - Develop and execute test cases and test scenarios for ETL workflows. - Perform source-to-target data validation to ensure data accuracy and completeness. - Write SQL queries to validate and reconcile data between source and target systems. - Validate data transformations, data loading, and ETL job execution. - Perform data quality checks such as null checks, duplicates, and data consistency. - Identify, log, and track defects using tools like JIRA or similar defect tracking tools. - Work with developers and business analysts to clarify requirements and resolve defects. - Support regression testing and system integration testing. - Assist in UAT support and production validation. **Qualifications Required:** - Strong knowledge of SQL for data validation, including joins, aggregations, subqueries, and data comparison queries. - Understanding of ETL processes, data mappings, and transformation logic. - Experience in ETL/Data Warehouse testing and Source-to-Target validation. - Knowledge of data validation techniques and data reconciliation methods. - Familiarity with ETL tools such as Informatica, Talend, SSIS, DataStage, or similar tools. - Experience with defect tracking and test management tools such as JIRA, TestRail, or ALM. - Basic understanding of Data Warehouse concepts such as fact tables, dimension tables, star schema, and data marts. - Experience in executing test cases, regression testing, and system integration testing. - Ability to perform data quality checks including null validation, duplicate checks, and data consistency checks. - Basic knowledge of Unix/Linux commands for validating ETL jobs and logs. As an ETL Tester, you should possess strong analytical skills, attention to detail, and problem-solving abilities. Good communication and collaboration skills are essential for working with developers, business analysts, and stakeholders. Your ability to analyze large datasets, understand business requirements, and translate them into test scenarios will be crucial for this role. Additionally, you should be able to work both independently and in a team environment effectively. As a Junior ETL Tester with 13 years of experience, your role will involve validating and ensuring the accuracy, completeness, and reliability of data integration processes across source and target systems. You will be responsible for understanding ETL requirements, executing test cases, validating data transformations using SQL queries, and supporting testing activities throughout the data pipeline. **Key Responsibilities:** - Understand ETL requirements, data mappings, and transformation logic. - Develop and execute test cases and test scenarios for ETL workflows. - Perform source-to-target data validation to ensure data accuracy and completeness. - Write SQL queries to validate and reconcile data between source and target systems. - Validate data transformations, data loading, and ETL job execution. - Perform data quality checks such as null checks, duplicates, and data consistency. - Identify, log, and track defects using tools like JIRA or similar defect tracking tools. - Work with developers and business analysts to clarify requirements and resolve defects. - Support regression testing and system integration testing. - Assist in UAT support and production validation. **Qualifications Required:** - Strong knowledge of SQL for data validation, including joins, aggregations, subqueries, and data comparison queries. - Understanding of ETL processes, data mappings, and transformation logic. - Experience in ETL/Data Warehouse testing and Source-to-Target validation. - Knowledge of data validation techniques and data reconciliation methods. - Familiarity with ETL tools such as Informatica, Talend, SSIS, DataStage, or similar tools. - Experience with defect tracking and test management tools such as JIRA, TestRail, or ALM. - Basic understanding of Data Warehouse concepts such as fact tables, dimension tables, star schema, and data marts. - Experience in executing test cases, regression testing, and system integration testing. - Ability to perform data quality checks including null validation, duplicate checks, and data consistency checks. - Basic knowledge of Unix/Linux commands for validating ETL jobs and logs. As an ETL Tester, you should possess strong analytical skills, attention to detail, and problem-solving abilities. Good communication and collaboration skills are essential for working with developers, business ana