Address
Form of workETL Tester (SQL, SSIS, Azure Data Factory) Job Description: We are looking for a skilled ETL Tester with expertise in SQL, SSIS, and Azure Data Factory to join our team. As an ETL Tester, you will be responsible for ensuring the quality and accuracy of our Extract, Transform, Load (ETL) processes and data integration workflows. You will collaborate closely with developers, data engineers, and business stakeholders to design and execute comprehensive test plans, identify and report defects, and ensure the smooth functioning of our ETL systems. Responsibilities: - Design and execute test plans, test cases, and test scripts to validate the functionality, performance, and reliability of ETL processes, data transformations, and data integration workflows - Collaborate with developers and data engineers to understand ETL requirements, data mappings, and business rules, ensuring test coverage aligns with project objectives - Develop and maintain test data sets and test environments to simulate real-world scenarios and edge cases - Execute and analyze test results, identifying defects, data quality issues, and performance bottlenecks, and documenting them in a clear and concise manner - Collaborate with cross-functional teams to troubleshoot and resolve issues, working closely with developers and data engineers to ensure timely resolution of defects - Validate data integrity and accuracy across various data sources, data warehouses, and data lakes using SQL queries and data validation techniques - Utilize ETL tools and frameworks, such as SSIS and Azure Data Factory, to validate end-to-end data integration workflows and ensure data consistency and completeness - Develop and maintain test documentation, including test plans, test cases, and test scripts, to facilitate knowledge sharing and ensure repeatability of testing processes - Stay up-to-date with emerging technologies and best practices in ETL testing and data integration, contributing to continuous improvement and innovation within the team Requirements: - Proven experience as an ETL Tester or similar role, with a focus on SQL, SSIS, and Azure Data Factory - Strong proficiency in SQL for data querying, data validation, and data integrity checks - Experience with ETL tools and frameworks, such as SSIS and Azure Data Factory, for designing and executing ETL workflows - Familiarity with data warehousing concepts and methodologies, including star schemas and dimensional modeling - Solid understanding of ETL testing concepts, methodologies, and best practices - Experience with data validation techniques, data profiling, and data quality assessment - Strong problem-solving and analytical skills, with the ability to troubleshoot complex data issues and propose effective solutions - Excellent attention to detail and a strong commitment to data quality and integrity - Excellent communication and collaboration abilities, with the capability to work effectively in a team environment - Bachelor's degree in Computer Science, Engineering, or a related field is preferred, but not required Note: We are looking for immediate joiners only.
