CrawlJobs Logo

ETL Tester

United States, Milford 50.00 USD / Hour · Job Posted December 11, 2025
Apply Position
Job Link Share

Job Description

We are seeking an experienced ETL Tester to validate data extraction, transformation, and loading processes in a data warehouse or data lake environment. The ideal candidate will have strong knowledge of SQL, data analysis, and ETL tools to ensure data quality, consistency, and reliability.

Job Responsibility

  • Understand and analyze ETL requirements, mappings, and data flows
  • Design, develop, and execute test cases for ETL processes and data validation
  • Perform data reconciliation between source and target systems
  • Use SQL extensively for data verification and issue diagnosis
  • Identify data anomalies and work with the development team to resolve defects
  • Document test results and contribute to QA reports

Requirements

  • Strong SQL skills for data validation and querying
  • Hands-on experience with ETL tools like Informatica, Talend, DataStage, or SSIS
  • Good understanding of data warehousing concepts and data models
  • Strong analytical and communication skills

Nice to have

Experience with BI/reporting tools

Looking for more opportunities?

Search for other job offers that match your skills and interests.

Similar Jobs for

ETL Tester

8 matching positions

ETL Tester

Role: ETL Tester. Location: Charlotte, NC (Onsite). Contract.
Location
Location
United States , Charlotte
Salary
Salary:
57.00 USD / Hour
realign-llc.com Logo
Realign
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Primary Skill: ETL testing
  • Secondary: ETL Testing, Autosys, SQL, Shell Scripting, Exposure to IDMC/Informatica
  • Experience: Minimum 10 years
  • Expert-level knowledge of SQL for data analysis
  • Experience with tools such as Informatica and IDMC
  • Understanding of data warehouse concepts and architectures (e.g., star/snowflake schema)
  • Familiarity with Hadoop or Spark is often preferred
  • Strong analytical and troubleshooting skills
  • Excellent communication for collaborating with developers and stakeholders
  • Knowledge in Metadata dependent ETL process and batch/job framework
Job Responsibility
Job Responsibility
  • Analyze data mapping documents and business requirements to design comprehensive test plans and cases
  • Perform source-to-target data reconciliation, check data loading, and ensure transformation rules are applied correctly
  • Write complex SQL scripts for validation (count, data completeness, data consistency, data truncation)
  • Identify, log, and track data defects using tools like JIRA or HP ALM or Octane
  • Automate test scripts and validate data volume, performance, and scalability
  • Validate HiveQL, HDFS file structures, and data processing within the Hadoop cluster
Read More
Arrow Right

ETL Tester

Job Title : ETL Tester
Location
Location
United States , Charlotte, NC/Plano, TX
Salary
Salary:
110000.00 USD / Year
realign-llc.com Logo
Realign
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Minimum 10 years experience
  • Expert-level knowledge of SQL for data analysis
  • Experience with tools such as Informatica and IDMC
  • Understanding of data warehouse concepts and architectures (e.g., star/snowflake schema)
  • Familiarity with Hadoop or Spark is often preferred
  • Strong analytical and troubleshooting skills
  • Excellent communication for collaborating with developers and stakeholders
  • Knowledge in Metadata dependent ETL process and batch/job framework
  • Banking knowledge
  • Payment’s knowledge preferred
Job Responsibility
Job Responsibility
  • Analyze data mapping documents and business requirements to design comprehensive test plans and cases
  • Perform source-to-target data reconciliation, check data loading, and ensure transformation rules are applied correctly
  • Write complex SQL scripts for validation (count, data completeness, data consistency, data truncation)
  • Identify, log, and track data defects using tools like JIRA or HP ALM or Octane
  • Automate test scripts and validate data volume, performance, and scalability
  • Validate HiveQL, HDFS file structures, and data processing within the Hadoop cluster
  • Fulltime
Read More
Arrow Right

ETL Tester

Job Title : ETL Tester
Location
Location
United States , Charlotte, NC/Plano, TX
Salary
Salary:
110000.00 USD / Year
realign-llc.com Logo
Realign
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Minimum 10 years experience
  • Expert-level knowledge of SQL for data analysis
  • Experience with tools such as Informatica and IDMC
  • Understanding of data warehouse concepts and architectures (e.g., star/snowflake schema)
  • Strong analytical and troubleshooting skills
  • Excellent communication for collaborating with developers and stakeholders
  • Knowledge in Metadata dependent ETL process and batch/job framework
  • Banking knowledge
  • Payment’s knowledge preferred
Job Responsibility
Job Responsibility
  • Analyze data mapping documents and business requirements to design comprehensive test plans and cases
  • Perform source-to-target data reconciliation, check data loading, and ensure transformation rules are applied correctly
  • Write complex SQL scripts for validation (count, data completeness, data consistency, data truncation)
  • Identify, log, and track data defects using tools like JIRA or HP ALM or Octane
  • Automate test scripts and validate data volume, performance, and scalability
  • Fulltime
Read More
Arrow Right
New

Quality Assurance / IT Tester

FinXL IT Professional Services is an innovative Australian owned company providi...
Location
Location
Australia , Melbourne
Salary
Salary:
Not provided
finxl.com.au Logo
FinXL
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • ETL
  • Data Warehousing Experience
  • API Automation skills
  • Agile project experience
  • Bachelor degree in IT preferred
  • At least 2 years experience in a similar role
  • Demonstrated process to plan, sequence, track, and report project status and outcomes
  • Understanding of Banking is desirable
  • Excellent communication skills
Job Responsibility
Job Responsibility
  • Assessing the quality of technical design documents in order to ensure timely, relevant and meaningful feedback
  • Conducting testing throughout the development process, identifying potential issues and reporting them back to development teams
  • Preparing (incl. test estimations), reviewing and executing Test Plans and strategies
  • Leading and mentoring team members and driving quality output
  • Fulltime
Read More
Arrow Right

Test Engineer (Back end)

The Senior Backend Data Test Engineer will be responsible for validating large-s...
Location
Location
United States , Baltimore
Salary
Salary:
45.00 - 50.00 USD / Hour
bhsg.com Logo
Beacon Hill
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Minimum of 5+ years of direct experience as a Backend/Data Tester
  • Strong expertise in backend database testing using PostgreSQL, Snowflake, and advanced SQL
  • Experience performing data validation within a big‑data environment (Databricks, Snowflake, etc.)
  • Proficiency with collaboration tools such as Jira, Confluence, and Slack
  • Solid experience working within Agile or SAFe methodologies
  • Hands‑on experience writing user stories, defect tickets, and clear acceptance criteria
  • Ability to create detailed test cases based on user stories and functional requirements
  • Strong communication skills with the ability to collaborate effectively with Product Owners, DBAs, and Developers
  • Proven ability to work independently, take initiative, and manage tasks with minimal direction
Job Responsibility
Job Responsibility
  • Perform comprehensive ETL and backend data validation across big‑data technologies including Databricks, Snowflake, PostgreSQL, and related platforms
  • Analyze, interpret, and validate complex CMS datasets, including Shared Systems Claims, Final Action Indicator logic, Provider data, and Beneficiary data etc
  • Validate data sourced from CMS’s Integrated Data Repository
  • Conduct detailed data comparison and reconciliation between backend datasets (PostgreSQL/Snowflake) and corresponding Frontend/UI outputs and/or Databricks Unity Catalog results
  • Collaborate with Business Analysts, DBAs, Developers, DevOps engineers, and Scrum/Kanban teams to ensure system reliability, data accuracy, and optimal performance
  • Ensure adherence Testing Framework standards, organizational SDLC processes, quality procedures, and regulatory compliance requirements
  • Participate in functional UI validations as needed to support end‑to‑end data integrity across user-facing components
  • Independently develop, execute, and maintain detailed backend test plans, test cases, and validation scenarios with zero or minimal supervision
  • Design and execute API‑based test scenarios to validate backend services and data flows
  • Actively participate in Agile ceremonies
  • Fulltime
Read More
Arrow Right

Enterprise Quality Program Test Lead

The Alabama Medicaid Agency (AMA) has embarked on a major transition from a mono...
Location
Location
United States , Montgomery
Salary
Salary:
Not provided
dashtechinc.com Logo
Dash Technologies
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 2 - 3 years of experience in using AI tools for EE2E Testing, API testing using open-source automation tools and testing Snowflake cloud data platform
  • 2 - 5 years of experience in testing MMIS system
  • 2 - 5 years of experience in preparing and executing an EE2E Test Strategy and creating data for EE2E testing
  • 3 - 5 years of experience in preparing and executing ETL test cases
  • 3 - 5 years of experience in member and provider enrollment and management, claims adjudication, and processing payments
  • 3 - 5 years developing test strategies for complex business applications and systems
  • 3 - 5 years of experience with large multi-vendor projects or teams
  • 3 - 5 years of experience working with management and key stakeholders
  • 5 - 7 years of report testing, creating UAT test cases, conducting and executing UAT
  • 5 – 7 years quality assurance and test management experience
Job Responsibility
Job Responsibility
  • Serves as the UAT Test Lead and drives UAT for Medicaid applications, ensuring systems for claims, eligibility, and providers meet business requirements, and CMS regulations
  • Leads UAT execution, manage testers, coordinate with stakeholders, and oversee defect resolution to ensure a high-quality compliant system
  • Serve as the EE2E Test Lead and drive EE2E testing for Medicaid applications, validating the entire Medicaid Management Information System (MMIS) workflow from claim submission to payment ensuring all components, databases, and third-party interfaces function together under real-world scenarios
  • Identify the EE2E scenarios, prepare EE2E test cases, work with vendors to conduct the enterprise EE2E testing
  • Act as a trusted partner with contractors and Agency managers to ensure testing outcomes reach program goals and key initiatives achieve desired results
  • Develop, design, and oversee metrics and Key Performance Indicators (KPIs) that provide insight to the health of the quality assurance program
  • Perform Test Analyst activities with experience in developing, implementing and evaluating a multi-phase Enterprise Test Strategy
  • Experience developing software tests for functional performance, UAT and Enterprise EE2E testing that include automated, ad-hoc, and manual testing elements
  • Strong knowledge of MMIS EE2E testing
  • Strong knowledge of identifying the business processes in MMIS system
  • Fulltime
Read More
Arrow Right

Senior Test Engineer (Data Quality)

The project is a web-based platform for financial advisors. The client portal al...
Location
Location
Poland;Croatia;Ukraine
Salary
Salary:
Not provided
eleks.com Logo
ELEKS
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 5+ years of experience as a QA Engineer, QA Tester, or similar manual testing role
  • Experience testing data-heavy applications, ETL pipelines, or API-driven integrations
  • Strong understanding of software testing methodologies and QA best practices (functional, regression, integration, end-to-end, UAT)
  • Experience designing and executing test plans, test cases, and test suites based on requirements and technical specifications
  • Solid experience with defect tracking and test management tools (Jira, TestRail, or similar)
  • Experience with SQL for data validation and query-based verification of application behavior
  • Ability to perform data integrity testing across integrations and processing workflows
  • Strong analytical and troubleshooting skills with a structured approach to root cause analysis
  • Familiarity with Agile/Scrum practices and SDLC
  • Excellent communication skills
Job Responsibility
Job Responsibility
  • Participate in the development, maintenance, and ownership of quality assurance procedures, work instructions, and testing processes related to data pipeline initiatives
  • Assist in tracking, documenting, and reporting quality metrics for software and data pipeline development efforts
  • Collaborate closely with engineering and product teams to support the delivery of high-quality, defect-free solutions
  • Participate in root cause and causal analysis activities for defects and nonconformities, identifying corrective and preventive actions
  • Develop and maintain procedures for capturing, investigating, documenting, and resolving product issues and customer complaints
  • Monitor risk management processes and maintain issue and defect logs for reporting and trend analysis
  • Support CAPA (Corrective and Preventive Action) activities related to component and process quality
  • Interpret, implement, and ensure compliance with company quality assurance standards and best practices
  • Maintain accurate documentation and records for quality assurance activities, audits, defects, and remediation efforts
  • Identify opportunities for process improvement and contribute to continuous improvement initiatives
What we offer
What we offer
  • Close cooperation with a customer
  • Challenging tasks
  • Competence development
  • Team of professionals
  • Dynamic environment with a low level of bureaucracy
  • Fulltime
Read More
Arrow Right

Lead Data Tester

We are partnering with a global P&C insurance client leading a large-scale trans...
Location
Location
London
Salary
Salary:
Not provided
calibrecandidates.com Logo
Calibre Candidates
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Strong experience within London Market Reinsurance testing
  • Excellent understanding of: Contract structures, Bordereaux, Insurance data mappings and Regulatory reporting requirements
  • Proven hands-on ETL testing experience
  • Strong SQL and backend data testing capability
  • Experience working on complex transformation programmes with multiple system integrations
  • Solid understanding of: Reconciliation testing, Data migration testing, Data quality validation and Defect analysis
  • Experience across both functional and non-functional testing
  • Ability to independently generate reports using Power BI, SQL Reporting, or similar reporting tool
  • Easy access to London for hybrid working
  • Available to start within 4-6 weeks – immediate preferred
Job Responsibility
Job Responsibility
  • Lead and manage testing activities across large-scale data transformation programmes
  • Perform hands-on ETL and backend testing using SQL and data profiling techniques
  • Validate complex insurance data flows, mappings, and reconciliation processes
  • Conduct data migration testing, including legacy-to-target validation and defect analysis
  • Create test analysis, test scenarios, test conditions, and execution plans from business and technical documentation
  • Manage and prepare test data for functional and non-functional testing activities
  • Execute integration testing across multiple systems and platforms
  • Produce testing reports, metrics, and dashboards using Power BI, SQL Reporting, or equivalent reporting tools
  • Identify, manage, and escalate risks, dependencies, and data quality issues proactively
  • Work closely with stakeholders to ensure successful delivery across programme milestones
  • Fulltime
Read More
Arrow Right