ETL Tester

Overview

On Site
Hybrid
$100,000 - $110,000
Full Time

Skills

ETL testing
unix
SQL
Autosys
Python
Java
Ruby
Cucumber
Advanced SQL

Job Details

Trident Consulting is seeking a " ETL Tester " for one of our clients in " Mclean, VA ".

Position: ETL Tester

Location: Mclean, VA- Onsite - Only Eastern time zoon candidates 

Type: Full-Time - No C2C/ NO OPTCPT/H1-T

Key Responsibilities:

  • Perform comprehensive ETL testing, including validation of transformations, data mappings, and data integrity.
  • Write and execute advanced SQL queries to validate data across source, staging, and target tables.
  • Work with ETL concepts such as 3NF, dimensional modeling, fact/dimension loads, surrogate keys, and complex joins.
  • Develop and manage automation test scripts using tools like Python, Java, Ruby, or Cucumber for ETL pipelines.
  • Perform data comparison and reconciliation between legacy and new systems/databases.
  • Use UNIX shell scripting for data/file operations and validation.
  • Monitor and manage ETL job executions through Autosys or equivalent job schedulers.
  • Collaborate with data engineers, analysts, and stakeholders to ensure data quality and compliance.
  • Leverage AWS cloud services for data storage, processing, and testing automation.

Must-Have Skills:

  • Strong experience in ETL Testing and Data Warehousing concepts.
  • Expertise in Advanced SQL for large datasets and complex validations.
  • Solid knowledge of UNIX and Shell Scripting.
  • Experience with Autosys or similar job scheduling tools.
  • Proficiency in Python, Java, Ruby, or Cucumber for test automation.
  • Working knowledge of ETL architectures and data modeling techniques (e.g., 3NF, star schema).
  • Hands-on experience with AWS Services such as S3, Redshift, Glue, Lambda, etc.

Good to Have:

  • Experience in CI/CD pipelines for test automation.
  • Familiarity with data governance and data quality tools.
  • Understanding of DevOps practices in data environments.

Education:

  • Bachelor s or Master s degree in Computer Science, Information Technology, or related field.

About Trident

Trident Consulting is a premier IT staffing firm providing high-impact workforce solutions to Fortune 500 and mid-market clients. Since 2005, we've specialized in sourcing elite technology and engineering talent for contract, direct hire, and managed services roles. Our expertise spans cloud, AI/ML, cybersecurity, and data analytics, supported by a 3M+ candidate database and a 78% fill ratio. With a highly engaged leadership team and a reputation for delivering hard-to-fill, niche talent, we help organizations build agile, high-performing teams that drive innovation and business success.

 

Some of our recent awards include:

  • Trailblazer Women Award 2025 by Consulate General of India in San Francisco
  • Ranked as the #1 Women Owned Business Enterprise in the large category by IT-Serve.
  • Received the Tech-Serve Excellence award.
  • Consistently ranked in the Inc. 5000 list of fastest-growing private companies in America
  • Recognized in the SF Business Times as one of the Largest Bay Area BIPOC/Minority-Owned Businesses in 2022
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.