ETL Testers

Location: Plano, TX

Salary: $100,000.00 USD Annually – $120,000.00 USD Annually

Description:

Primary Skill: ETL testing

Secondary: ETL Testing, Autosys, SQL, Shell Scripting, Exposure to IDMC/Informatica

Experience: Minimum 10 years

Roles & 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

By providing your phone number, you consent to: (1) receive automated text messages and calls from the Judge Group, Inc. and its affiliates (collectively “Judge”) to such phone number regarding job opportunities, your job application, and for other related purposes. Message & data rates apply and message frequency may vary. Consistent with Judge’s Privacy Policy, information obtained from your consent will not be shared with third parties for marketing/promotional purposes. Reply STOP to opt out of receiving telephone calls and text messages from Judge and HELP for help.

Contact:

This job and many more are available through The Judge Group. Please apply with us today!