ETL Tester
Velocia
Key Responsibilities:
- Design, develop, and execute test plans and test cases for ETL processes focused on data integration and data conversion within an Azure cloud environment.
- Automate test scripts and processes using industry-standard tools and frameworks to validate ETL pipelines, ensuring they meet business and technical requirements.
- Perform comprehensive testing of data extraction, transformation, and loading (ETL) processes to ensure data accuracy, completeness, and integrity across different data sources.
- Collaborate closely with data engineers, developers, and business analysts to understand data requirements and translate them into effective test strategies.
- Validate data conversion processes during migrations and integrations, ensuring that data is accurately transformed and loaded into target systems.
- Monitor and validate data flows and transformations within Azure services, including Azure Data Factory, Azure SQL Database, and other related technologies.
- Identify, document, and track defects, working closely with the development team to ensure timely resolution.
- Produce detailed test reports, including defect summaries and recommendations for improving data quality and ETL processes.
- Stay current with the latest developments in ETL testing, data integration technologies, and Azure cloud services, continuously improving testing methodologies.
What will it take to succeed:
- Bachelor’s degree in Computer Science, Information Technology, or a related field.
- 5+ years of experience in ETL testing, with a strong emphasis on data integration, validation, conversion, and test automation.
- Hands-on experience with Azure cloud services, particularly Azure Data Factory, Azure SQL Database, Microsoft Fabric and related technologies.
- Proficiency in SQL and experience with database testing in a data warehouse environment.
- Experience with test automation tools such as Selenium, JUnit, or similar, and scripting languages like Python, Java, or Shell.
- Familiarity with CI/CD pipelines and version control systems, such as Git, in an Azure environment.
- Strong analytical skills and attention to detail, with the ability to identify and troubleshoot issues effectively.
- Excellent communication and collaboration skills, with the ability to work effectively in a cross-functional team environment.
- Knowledge of banking industry standards and practices, particularly in data management and regulatory compliance, is an advantage.