The Judge Group · 14 hours ago
ETL Testers (1117092)
Plano, TX
Full-time
Onsite
Senior Level, Lead/Staff
$100K/yr - $120K/yr
10+ years expThe Judge Group is seeking experienced ETL Testers to join their team in Plano, TX. The role involves analyzing data mapping documents, designing test plans, and performing data validation and reconciliation to ensure data integrity and transformation accuracy.
E-LearningInformation TechnologyProfessional Services
Responsibilities
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
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
Validate HiveQL, HDFS file structures, and data processing within the Hadoop cluster
Strong analytical and troubleshooting skills
Excellent communication for collaborating with developers and stakeholders
Knowledge in Metadata dependent ETL process and batch/job framework
Qualification
Required
Minimum 10 years of experience
Primary Skill: ETL testing
Secondary: ETL Testing, Autosys, SQL, Shell Scripting, Exposure to IDMC/Informatica
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
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
Preferred
Familiarity with Hadoop or Spark is often preferred
Validate HiveQL, HDFS file structures, and data processing within the Hadoop cluster
Company
The Judge Group
Results through the Power of Experience.
1001-5000 employees
H1B Sponsorship
The Judge Group has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2021 (3)
Funding
Current Stage
Public CompanyTotal Funding
unknown1997-02-14IPO
Leadership Team
Charlton Monsanto
Executive Vice President of Integrated Services and Innovation
Recent News
Seattle TechFlash
2025-09-12
2025-08-05
The Judge Group
2025-05-07
Company data provided by crunchbase