Data Test Engineer (ETL Testing)

Overview

On Site
Depends on Experience
Accepts corp to corp applications
Contract - W2
Contract - Independent
Contract - 12 Month(s)
No Travel Required

Skills

ETL Tester
Data Testing
Ab Initio
Amazon Kinesis
Amazon S3
Amazon Web Services
Apache Kafka
Attention To Detail
Automated Testing
Benchmarking
Business Intelligence
Cloud Computing
Collaboration
Continuous Delivery
Continuous Integration
Data Engineering
Data Governance
Data Integrity
Data Migration
Data Quality
Python
Quality Assurance
Real-time
Regression Testing
Regulatory Compliance
Informatica
Legacy Systems
Load Testing
Microsoft Power BI
Performance Testing
Data Validation
Data Warehouse
DevOps
ETL QA
Tableau
Test Cases
Extract
Transform
Load
Reporting
SQL
Scripting
Snow Flake Schema
Streaming
Test Methods
Test Plans
Testing
Workflow
Writing

Job Details

Position : Data Test Engineer (ETL)

Location : Alpharetta, GA (5 days a week onsite(100% Onsite))

Relevant Experience: 5+ Years

We are seeking a detail-oriented Data Test Engineer to join our data migration and cloud modernization team. The ideal candidate will have hands-on experience testing complex ETL pipelines, data migration workflows, and cloud data platforms like Snowflake, with exposure to legacy ETL tools such as Ab Initio or Informatica. Experience in automating data validation, performance testing, and supporting real-time ingestion using Kafka or similar technologies is essential.

Key Responsibilities:

  • Design, develop, and execute test plans for data migration projects moving data from legacy systems to Snowflake.
  • Validate data pipelines developed using ETL tools like Ab Initio and Informatica, ensuring data quality, accuracy, and integrity.
  • Develop automated test scripts and frameworks using Python for data validation, reconciliation, and regression testing.
  • Perform end-to-end data validation including schema validation, volume checks, transformation logic verification, and performance benchmarking.
  • Test real-time data ingestion workflows integrating Kafka, Snowpipe, and Snowflake COPY commands.
  • Collaborate closely with development, data engineering, and DevOps teams to identify defects, track issues, and ensure timely resolution.
  • Participate in designing reusable test automation frameworks tailored for cloud data platforms.
  • Ensure compliance with data governance, security, and regulatory requirements during testing.
  • Document test cases, results, and provide clear reporting to stakeholders.
  • Support CI/CD pipelines by integrating automated testing into the deployment workflow.

Required Skills and Experience:

  • 5+ years in data testing or quality assurance with strong experience in data validation and ETL testing.
  • Hands-on experience testing data migrations to Snowflake or other cloud data warehouses.
  • Familiarity with legacy ETL tools like Ab Initio or Informatica and their testing methodologies.
  • Proficient in scripting languages such as Python for test automation and data validation.
  • Knowledge of real-time data streaming platforms such as Kafka, Kinesis, or equivalents.
  • Strong SQL skills for writing complex queries to validate data integrity and transformations.
  • Experience with automated testing tools and frameworks for data quality checks.
  • Understanding of cloud environments, particularly AWS services (S3, Lambda, Glue).
  • Familiarity with CI/CD tools and practices to integrate automated testing.

Preferred Qualifications:

  • Experience with performance and load testing of data pipelines.
  • Knowledge of data governance and compliance frameworks.
  • Exposure to BI tools such as Tableau, Power BI for validating data consumption layers.
  • Certifications in data quality or cloud platforms (Snowflake, AWS) are a plus.

Alchemy: Transforming Your Professional Vision into Reality

Since our inception in 2013, Alchemy has been dedicated to reshaping organizational performance through innovative IT services. With a vision to empower businesses seeking a transformative edge, we ve positioned ourselves at the forefront of digitization and software modernization.

Our name reflects our mission: to transmute technology into gold-standard solutions for our esteemed clients. We proudly serve a diverse range of sectors, including IT and ITES, BFSI, Telecom and Media, Automotive, Manufacturing, Energy, Oil and Gas, Real Estate, Retail, Healthcare, and more.

With a global footprint spanning the USA, India, Europe, Canada, Singapore, Japan, and parts of Central and West Africa, we harness a unique blend of competencies, frameworks, and cutting-edge technologies. Together, we drive growth and innovation across industries, helping organizations turn their visions into reality.

Alchemy Connecting Talent with Opportunities (Diversity, Equity and Inclusion)

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.