SQL/ ETL Tester with SC eligible / Clearance

Mastek; Greater London; On-site; GBP 40,000 - 75,000; Full time

Job summary

An established industry player is on the lookout for a detail-oriented End-to-End Tester with expertise in SQL and ETL testing. This role is crucial for ensuring the accuracy and reliability of database applications and ETL processes. You will design and execute comprehensive test plans, validate data integrity, and collaborate with cross-functional teams in a dynamic environment. If you are passionate about data quality and have the necessary security clearance, this is a fantastic opportunity to be part of an innovative team that leverages modern data technologies and cloud platforms.

Qualifications

• 5+ years of experience in end-to-end testing with a focus on database and ETL processes.
• Expertise in SQL queries, stored procedures, and database testing methodologies.
• Hands-on experience with test automation tools for database testing.

Responsibilities

• Design and execute test plans for end-to-end testing of database and ETL applications.
• Validate ETL processes and perform data validation and integrity checks.
• Automate database and ETL testing processes using industry-standard tools.

Skills

SQL

ETL Testing

Data Integrity Checks

Analytical Skills

Problem-Solving

Communication Skills

Education

Bachelor's Degree in Computer Science

Certification in Database Technologies

Tools

Informatica

Talend

SSIS

DataStage

Selenium

Python

dbUnit

Job description

SQL/ ETL Tester with SC eligible / Clearance

SQL/ ETL Tester with SC eligible / Clearance

Get AI-powered advice on this job and more exclusive features.

Direct message the job poster from Mastek

Job Title: End-to-End Tester (SQL & ETL Expert with Security Clearance)

Job Summary: We are seeking a skilled End-to-End Tester with strong experience in SQL and ETL testing to join our quality assurance team. The ideal candidate will be responsible for ensuring the accuracy, reliability, and efficiency of database applications, data warehouses, and ETL processes. This role requires extensive hands-on experience in database testing, SQL scripting, ETL validation, and data integrity checks.

Key Responsibilities:

• Design, develop, and execute test plans, test cases, and test scripts for end-to-end testing of database and ETL applications.
• Validate ETL processes, data migration, and data transformation activities across various systems.
• Write complex SQL queries to perform data validation and integrity checks.
• Identify, document, and track defects related to databases and ETL processes.
• Work closely with developers, data engineers, and business analysts to ensure data accuracy and consistency.
• Automate database and ETL testing processes using industry-standard tools and frameworks.
• Analyze test results and provide detailed reports on defects and test coverage.
• Ensure compliance with data security and regulatory requirements.
• Participate in Agile development processes and contribute to sprint planning and reviews.
• Work effectively in a multi-vendor environment, collaborating with diverse teams and stakeholders.
• Apply risk-based testing and assessment methodologies to prioritize testing efforts and mitigate potential risks.

Required Skills and Qualifications:

• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• 5+ years of experience in end-to-end testing with a focus on database and ETL processes.
• Expertise in SQL queries, stored procedures, and database testing methodologies.
• Strong knowledge of ETL tools such as Informatica, Talend, SSIS, or DataStage.
• Experience with data warehousing concepts and testing strategies.
• Hands-on experience with test automation tools for database testing (e.g., Selenium, Python, dbUnit, or similar frameworks).
• Strong analytical and problem-solving skills.
• Excellent communication and collaboration skills.
• Experience working in Agile environments is a plus.
• Active security clearance is required for this role.
• Knowledge of cloud-based database solutions (AWS, Azure, Google Cloud) is an advantage.

Preferred Qualifications:

• Experience with big data technologies (Hadoop, Spark, Snowflake) is a plus.
• Certification in database technologies or testing methodologies.
• Knowledge of scripting languages like Python or Shell scripting for test automation.
• Hybrid/Remote flexibility based on project requirements.
• Collaboration with cross-functional teams in a dynamic, fast-paced environment.
• Opportunity to work with modern data technologies and cloud platforms.

If you are a detail-oriented End-to-End Tester with a passion for ensuring data quality and integrity, and you have the required security clearance, we encourage you to apply and be part of our innovative team!

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

• Industries

  IT Services and IT Consulting

Referrals increase your chances of interviewing at Mastek by 2x

Get notified about new Software Tester jobs in London Area, United Kingdom.

London, England, United Kingdom 3 weeks ago

Software Development Engineer in Test (SDET)

London, England, United Kingdom 3 weeks ago

London, England, United Kingdom 2 months ago

London, England, United Kingdom 3 weeks ago

London, England, United Kingdom 2 months ago

London, England, United Kingdom 2 weeks ago

London, England, United Kingdom 6 days ago

London, England, United Kingdom 1 month ago

London, England, United Kingdom 2 months ago

London, England, United Kingdom 2 months ago

Software Developer in Test - Mid Level - SDET

London, England, United Kingdom 1 week ago

London, England, United Kingdom 2 months ago

London, England, United Kingdom 4 days ago

London, England, United Kingdom 2 weeks ago

Battersea, England, United Kingdom 5 days ago

Senior Software Development Engineer Test

Woking, England, United Kingdom 1 week ago

Software Development Engineer in Test - Midnight

Greater London, England, United Kingdom 2 months ago

London, England, United Kingdom 1 month ago

Software Development Engineer in Test - Dwellant

London, England, United Kingdom 1 week ago

London, England, United Kingdom 1 week ago

London, England, United Kingdom 2 weeks ago

Intermediate Software Development Engineer in Test (Typescript)

London, England, United Kingdom 2 days ago

London, England, United Kingdom 2 weeks ago

London, England, United Kingdom 1 month ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.