We are looking for a highly skilled and experienced ETL Database Tester with a strong background in T-SQL, Data Warehousing, and Azure cloud technologies. As part of our team, you will play a crucial role in ensuring the accuracy, consistency, and reliability of data processed through ETL workflows. This position requires a keen eye for detail, strong analytical skills, and a deep understanding of database testing methodologies, particularly in cloud-based environments. You will collaborate closely with developers, data engineers, and business teams to validate data, troubleshoot issues, and improve data quality.
Key Responsibilities
- Perform comprehensive testing of ETL processes, ensuring that data extraction, transformation, and loading (ETL) functions as expected.
- Validate data accuracy and integrity across different stages of data movement, ensuring alignment with business requirements.
- Write and execute complex SQL queries to verify data correctness, consistency, and performance in an Azure cloud SQL database.
- Conduct data profiling, transformation, and quality testing to identify anomalies and inconsistencies.
- Work closely with ETL developers and business analysts to troubleshoot issues and enhance data quality.
- Ensure compliance with data warehousing best practices, including data modeling, integration, and storage strategies.
- Utilize Azure Data Factory, SSIS, and other ETL tools (if applicable) for end-to-end data testing.
- Manage test cases, track defects, and coordinate with development teams to resolve issues using tools like TFS and Azure DevOps.
- Participate in Agile/Scrum development cycles, contributing to sprint planning, retrospectives, and continuous process improvements.
Required Skills & Qualifications
- 5 to 7 years of hands-on experience in database testing, ETL testing, and data validation.
- Expertise in T-SQL for querying and validating data.
- Strong knowledge of data warehousing concepts, data modeling, and data integration techniques.
- Experience testing data in an Azure cloud SQL database environment.
- Exposure to Azure Blob Storage and cloud-based data warehousing platforms.
- Familiarity with ETL tools like SSIS and Azure Data Factory is a plus.
- Understanding of data governance, data profiling, and data quality management.
- Experience working with version control, defect tracking, and test management tools (e.g., TFS, Azure DevOps).
- Ability to work in fast-paced Agile/Scrum environments, collaborating with cross-functional teams.
- Strong problem-solving skills, attention to detail, and ability to troubleshoot complex data issues.
Why Join Us?
- Opportunity to work with cutting-edge cloud technologies in a data-driven environment.
- Collaborate with a highly skilled team in a fast-paced, Agile work culture.
- Gain hands-on experience with Azure cloud, big data, and modern data engineering practices.
- Competitive salary, career growth opportunities, and a supportive work environment.
If you are passionate about data quality, ETL testing, and cloud-based database solutions, we would love to hear from you! Apply today and be part of an exciting journey in data engineering and analytics.