ETL Data Test Engineer

Saransh Inc; Alpharetta (GA); On-site; USD 70,000 - 120,000; Full time

Job summary

A leading company in IT Services is looking for an ETL Data Test Engineer to join their data migration team in Alpharetta, GA. This role involves testing ETL pipelines and ensuring data integrity in cloud platforms like Snowflake. The ideal candidate should have extensive experience in data testing, automation, and a solid understanding of legacy ETL tools. This contract position offers competitive compensation in a dynamic IT environment.

Qualifications

• 5+ years in data testing or quality assurance with a focus on ETL.
• Experience with data migration to Snowflake or similar.
• Proficiency in Python for test automation is a must.

Responsibilities

• Design and execute test plans for data migrations to Snowflake.
• Validate ETL pipelines, ensuring data accuracy and integrity.
• Develop automated testing frameworks for data validation.

Skills

Data Validation

ETL Testing

Automation

Real-time Data Streaming

SQL

Education

Bachelor's degree in Computer Science or related field

Tools

Snowflake

Ab Initio

Informatica

Kafka

Python

Job description

Role: ETL Data Test Engineer

Location: Alpharetta, GA (Onsite from Day 1)

Job Type: Contract

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

Role: ETL Data Test Engineer

Location: Alpharetta, GA (Onsite from Day 1)

Job Type: Contract

Job Description

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

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Contract

Job function

• Job function

  Engineering and Information Technology

• Industries

  IT Services and IT Consulting

Referrals increase your chances of interviewing at Saransh Inc by 2x

Get notified about new Test Engineer jobs in Alpharetta, GA.

Atlanta, GA $70,000.00-$120,000.00 1 day ago

Software Engineer, Devices - United States

Atlanta, GA $114,750.00-$180,000.00 3 weeks ago

Atlanta, GA $106,000.00-$133,000.00 1 week ago

Atlanta, GA $90,000.00-$120,000.00 1 week ago

UI Developer - Front End Engineer - 100% REMOTE W2 Only

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.