ETL Tester

ETL Tester

Posted 1 week ago by Adroit People Limited (UK)

Apply
Negotiable
Undetermined
Hybrid
London Area, United Kingdom
Apply
Aggregate Functions Agile Methodology Agile Testing Business Logic Business Requirements Computer Science Data Analysis Data Conversion Data Extraction Data Integrity Data Maintenance Datamodel Data Modeling Data Store Data Transformation Data Validation Data Warehousing Extract Transform Load (ETL) Geostationary Operational Environmental Satellite Informatics Information Systems JavaScript (Programming Language) JIRA Management PL/SQL Probability And Statistics Python (Programming Language) Software Development SQL (Programming Language) Statistics Storage Systems Test Case Test Engineering Test Execution Engine Test Management Test Planning Test Strategy Verification And Validation

Summary: The ETL Tester role involves validating data sources, executing transformation logic, and ensuring data integrity within the company's data storage system. The position requires designing and troubleshooting testing processes, coordinating test activities, and collaborating with development teams to resolve defects. Strong technical skills in SQL, Python, and JavaScript are essential for effective data analysis and testing. The role is based in London and operates in a hybrid working arrangement.

Key Responsibilities:

  • Validate data sources and transformation logic, ensuring data integrity in target tables.
  • Design, test, and troubleshoot the data storage system prior to deployment.
  • Define scope, execution plans, and coordinate test activities.
  • Ensure all deliverables meet governance requirements and obtain necessary sign-offs.
  • Participate in data conversion testing and maintenance, authoring SQL queries for data extraction.
  • Create SIT test cases/test data and perform test execution.
  • Analyze and troubleshoot erroneous results, logging defects in JIRA and managing defect resolution.
  • Collaborate with software development teams to ensure effective testing efforts.
  • Document testing issues and quality risks, participating in defect remediation.
  • Follow Agile Testing practices and actively engage in test management activities.

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.
  • Experience with ETL testing and reporting/BI tools.
  • Proficient in writing SQL queries for data validation and integrity checks.
  • Ability to transform complex business logic into SQL or PL/SQL queries.
  • Self-starter with strong analytical skills and independent work capability.
  • Familiarity with Agile Testing practices and defect management.
  • Knowledge of database objects and relational data models.
  • Understanding of ETL requirements and source-to-target mappings.

Salary (Rate): undetermined

City: London

Country: United Kingdom

Working Arrangements: hybrid

IR35 Status: undetermined

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:

Job Title: ETL Tester

Location: London, UK (Hybrid - 3days Onsite)

Job Type: Contract

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.

  • 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
  • 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
  • Analyzes 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 comparison

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
  • Understanding of ETL requirements (source-to-target mappings)
Apply
Similar Jobs
Loading data...