CrawlJobs Logo

ETL Tester

realign-llc.com Logo

Realign

Location Icon

Location:
United States , Charlotte, NC/Plano, TX

Category Icon

Job Type Icon

Contract Type:
Not provided

Salary Icon

Salary:

110000.00 USD / Year

Job Description:

Job Title : ETL Tester

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

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

Nice to have:

  • Familiarity with Hadoop or Spark
  • Banking knowledge
  • Payment’s knowledge preferred

Additional Information:

Job Posted:
March 21, 2026

Employment Type:
Fulltime
Job Link Share:

Looking for more opportunities? Search for other job offers that match your skills and interests.

Briefcase Icon

Similar Jobs for ETL Tester

ETL Tester

We are seeking an experienced ETL Tester to validate data extraction, transforma...
Location
Location
United States , Milford
Salary
Salary:
50.00 USD / Hour
realign-llc.com Logo
Realign
Expiration Date
Until further notice
Flip Icon
Requirements
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
Job Responsibility
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
Read More
Arrow Right

Officer-ETL Tester

The primary purpose of this role is to work on the QA and development work for t...
Location
Location
India , Pune
Salary
Salary:
Not provided
https://www.citi.com/ Logo
Citi
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 5+ Year Software development and QA experience
  • 3+ Year Oracle PL/SQL experience
  • 3+ Year ETL QA Experience (AbInitio or Informatica)
  • Hands on experience in testing complex ETL applications
  • Development experience in a fast-paced, time-to-market driven environment
  • Experience with test automation, test scenario and test scripts creation and modification
  • Comfortable with writing complex queries
  • Experience with reporting tools
  • Hands on experience with testing automation tools
  • Proficiency with Oracle PL/SQL, SQL tuning, writing packages, triggers, functions and procedures
Job Responsibility
Job Responsibility
  • Understanding Business Requirements and Functional Requirements provided by Business Analysts and to convert into Technical Design Documents and leading the development team to deliver on those requirements
  • Leading a Technical Team in Pune supporting GTPL in Product Processor Departments
  • Ensure projects Plans are created and PTS documentation is up to date
  • Work closely with Cross Functional Teams e.g. Business Analysis, Product Assurance, Platforms and Infrastructure, Business Office, Controls and Production Support
  • Prepare handover documents, manage SIT , UAT, automation of Unit Tsting
  • Identify and proactively resolve issues that could impact system performance, reliability, and usability
  • Demonstrates an in-depth understanding of how the development function integrates within overall business/technology to achieve objectives
  • requires a good understanding of the industry
  • Work proactively & independently to address testing requirements and articulate issues/challenges with enough lead time to address risks
  • Ability to understand complex data problems, analyze and provide generic solutions compatible with existing Infrastructure
  • Fulltime
Read More
Arrow Right

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

IT Tester/ QA

FinXL IT Professional Services is an innovative Australian owned company providi...
Location
Location
Australia , Melbourne
Salary
Salary:
80000.00 - 100000.00 AUD / Year
finxl.com.au Logo
FinXL
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 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
New

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
New

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

Offshore Data Tester

The Offshore Data Tester role involves designing and executing test plans for da...
Location
Location
India , Bangalore
Salary
Salary:
Not provided
nttdata.com Logo
NTT DATA
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Strong knowledge of data testing methodologies, including ETL and data migration testing
  • Proficiency in SQL for data validation and query-based testing
  • Hands-on experience with Python or other scripting languages for automation
  • Familiarity with data warehousing concepts, data modeling, and big data technologies
  • Experience with testing tools and frameworks for data validation and automation
  • Understanding of cloud platforms (Azure, AWS, or GCP) and data services
  • Ability to analyze large datasets and troubleshoot data-related issues effectively
  • Excellent communication skills and ability to work independently in a remote environment
  • Bachelor's degree in Computer Science or a related field
Job Responsibility
Job Responsibility
  • Design and execute test plans for validating data pipelines, ETL processes, and data transformations
  • Perform functional, regression, and integration testing on large-scale data systems
  • Validate data accuracy, completeness, and consistency across multiple sources and environments
  • Collaborate with data engineers and developers to identify and resolve defects in data workflows
  • Develop automated test scripts for data validation using tools like PyTest, Selenium, or custom frameworks
  • Ensure compliance with data quality standards and document test results for audit purposes
  • Analyze root causes of data discrepancies and provide actionable recommendations
  • Work closely with stakeholders to understand business requirements and translate them into test scenarios
  • Fulltime
Read More
Arrow Right
New

EL - OffS Tester

The EL - OffS Tester role involves executing test cases and validating data accu...
Location
Location
India , Bangalore
Salary
Salary:
Not provided
nttdata.com Logo
NTT DATA
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 5+ years of experience in data testing or ETL testing roles
  • Strong SQL querying skills
  • Experience validating data pipelines and transformations
  • Basic familiarity with Python-based data pipelines (reading logs, outputs)
  • Understanding of ETL/ELT concepts and data reconciliation techniques
  • Experience working in Agile or wave-based delivery models
Job Responsibility
Job Responsibility
  • Execute test cases for Python-based extract/load processes, validating: Record counts
  • Field-level data accuracy
  • Schema and data type consistency
  • Perform dbt transformation validation using SQL-based reconciliation queries
  • Compare legacy Informatica outputs with dbt-generated results based on agreed criteria
  • Log, track, and re-test defects through resolution
  • Support SIT and UAT test cycles across multiple migration waves
  • Maintain test artifacts, evidence, and execution logs
  • Assist in regression testing as new waves are onboarded
  • Collaborate with Data Engineers to clarify expected outputs and resolve issues
Read More
Arrow Right