Lead ETL Test Automation Engineer with strong expertise in AWS, SQL

Atlanta, GA, US • Posted 4 hours ago • Updated 4 hours ago
Contract Independent
Contract W2
On-site
$50 - $60/hr
Company Branding Image
Fitment

Dice Job Match Score™

👾 Reticulating splines...

Job Details

Skills

  • ETL/Data Warehouse Testing.
  • SQL
  • Informatica
  • AWS

Summary

We are seeking an experienced ETL Testing Automation Lead to drive quality assurance initiatives for data integration and warehousing projects. The ideal candidate will have strong expertise in ETL testing, automation frameworks, and data validation, along with leadership experience in managing QA teams and collaborating with cross-functional stakeholders.

Key Responsibilities:

  • Lead and manage end-to-end ETL testing activities for data warehouse and data migration projects.
  • Design, develop, and maintain automation frameworks for ETL/data validation.
  • Validate data across source and target systems to ensure accuracy, completeness, and consistency.
  • Work closely with data engineers, developers, and business analysts to understand data requirements and transformations.
  • Develop and execute test strategies, test plans, and test cases for ETL workflows.
  • Perform data reconciliation, data quality checks, and regression testing.
  • Identify, track, and resolve defects in collaboration with development teams.
  • Mentor and guide QA team members; provide technical leadership.
  • Ensure adherence to best practices in data testing and automation.
  • Participate in Agile ceremonies such as sprint planning, stand-ups, and retrospectives.

Required Skills & Experience:

  • 8+ years of experience in ETL/Data Warehouse Testing.
  • Strong experience in SQL for complex data validation and querying.
  • Hands-on experience with ETL tools like Informatica, Talend, SSIS, or DataStage.
  • Expertise in test automation tools (e.g., Selenium, Python-based frameworks, or custom ETL automation tools).
  • Experience with data validation tools such as QuerySurge or similar.
  • Strong knowledge of data warehousing concepts (Star/Snowflake schema, OLAP).
  • Experience working with cloud platforms (AWS, Azure, or Google Cloud Platform).
  • Familiarity with CI/CD pipelines and DevOps practices.
  • Experience with version control tools like Git.
  • Strong analytical and problem-solving skills.
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.
  • Dice Id: 91156937
  • Position Id: 8937632
  • Posted 4 hours ago

Company Info

About RITWIK Infotech Inc

RITWIK Infotech, Inc an ORACLE Cloud partner and ISO 9001:2008 certified company, is a IT consulting and software services company focusing on Enterprise Applications and Solutions in Oracle E-Business Suite, Oracle Fusion Cloud Applications, Netsuite Cloud ERP and Business Intelligence Technologies. 

Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Atlanta, Georgia

21d ago

Easy Apply

Contract, Third Party

Depends on Experience

Atlanta, Georgia

14d ago

Easy Apply

Contract, Third Party

Depends on Experience

Atlanta, Georgia

2d ago

Easy Apply

Contract

Atlanta, Georgia

14d ago

Easy Apply

Contract

$30 - $35

Search all similar jobs