ETL Test
Posted 1 week ago by Uniting People
£250 Per day
Inside
Hybrid
EC2N, Cornhill, Greater London
Summary: The role of Test Lead involves overseeing ETL testing and data validation processes within a data warehouse environment. The position requires strong technical skills in SQL and programming languages, along with experience in managing testing activities and ensuring quality standards. The contract is for an initial duration of three months, with a hybrid working arrangement based in London. The role is classified as inside IR35, indicating specific tax implications for contractors.
Key Responsibilities:
- Validate data sources and transformation logic, ensuring accurate data uploads to target tables.
- Design, test, and troubleshoot the company's data storage system prior to deployment.
- Define scope, execution plans, and coordinate test activities while ensuring governance compliance.
- Ensure quality assurance across the development team’s deliverables and manage defect resolution.
- Participate in data conversion testing and maintenance, authoring SQL queries for data analysis.
- Create and execute SIT test cases and validate data against expectations.
- Analyze and troubleshoot defects, logging issues in JIRA and collaborating with the development team.
- Work closely with various stakeholders, including Data Engineers and Business Analysts, to facilitate effective testing.
Key Skills:
- 4+ years of experience as a Data Warehouse Developer Tester or ETL Tester.
- Graduate degree in Computer Science, Statistics, Informatics, Information Systems, or a related field preferred.
- Expertise in QA/Testing Lifecycle and DB-related testing.
- Proficient in writing SQL queries for data integrity and transformation testing.
- Experience with reporting and BI tools, and familiarity with Agile Testing practices.
- Strong analytical skills and ability to work independently on complex projects.
- Knowledge of database objects, relational data models, and ETL requirements.
- Test automation experience is a significant advantage.
Salary (Rate): £250 per day
City: London
Country: United Kingdom
Working Arrangements: hybrid
IR35 Status: inside IR35
Seniority Level: Mid-Level
Industry: IT
Urgent Contract Test Lead
Location: London (3 days/week from office)
Employment Type: 3 months contract initial
Key Skills: ETL Testing
Daily Rate: £250 per day (inside IR35)
As a Data Test Engineer / ETL tester you would be responsible for validating data sources, extracting data applications of transformation logic, and uploading data in target tables.
You would be responsible for designing, testing, and troubleshooting the company's data storage system before it goes live.
Knowledge of dimensional modeling and data warehouse concepts, such as star schemas, snowflakes, dimensions, facts
Define scope, execution plans, and coordinate test activities
Ensure all sign-offs on deliverables (overall test strategy, test plan, test cases, ) and that testing meets governance requirements
Responsible for ensuring the quality of their work the work of the entire development team
Strong experience in of the following technologies preferred -SQL, PYTHON, JavaScript, Java
Participate in data conversion Testing and data maintenance, authoring SQL queries to fetch the data between various databases, execute them and analyze the data
Create SIT test cases/test data and perform Test execution
Validates data by running queries in the database and verify that the results match the expectations
Will be responsible to ensure quality of process and measurements are acceptable in accordance with the specifications
Analyses and troubleshoots erroneous results, determines the root cause of defects, logs the defects in JIRA and enables defect management, including working with the development team on the resolution of Software related defects
Works closely with the software development team (Data Engineer, Business Analysts, Developers & other testers) to ensure timely and effective testing effort
Writing queries to extract data for test case data comparisons
Requirements:
4+ experience as Data warehouse developer tester or ETL Tester
Graduate degree preferred in Computer Science, Statistics, Informatics, Information Systems or another quantitative field.
Expert in understanding and implementing QA/Testing Lifecycle
Expertise in DB-related testing and ETL testing
Testing experience with reporting and BI tools
Writing basic SQLs to check record counts, data truncation, invalid data types, NULLs and data integrity, data transformation, aggregate functions testing
Expertise preferred in testing our current or a similar analytics stack
Experience in transforming complex Business logic into SQL or PL/SQL queries
Must be a self-starter with the ability to work on complex projects and analyzes business requirements independently
Must be able to identify and document testing issues and quality risks, participate in defect remediation
Willingness to follow Agile Testing practices and guidelines, including Defect Management
Actively participate in all test management activities like assessment, test strategies and test plans
Knowledge of Database objects and relational data model
Experience in scripting
Test automation experience is huge plus
Understanding of ETL requirements (source-to-target mappings)
Testing experience with different file types