ETL Tester

StoneGate-Technologies LLC
Charlotte, United States of America
6 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English

Job location

Charlotte, United States of America

Tech stack

Artificial Intelligence
Amazon Web Services (AWS)
JIRA
Automation of Tests
Azure
Big Data
Cloud Computing
Databases
Data Integrity
ETL
Data Mart
Data Warehousing
Database Testing
Hadoop
Python
Machine Learning
Scrum
Standard Sql
SQL Stored Procedures
SQL Databases
SQL Server Integration Services
Talend
Scripting (Bash/Python/Go/Ruby)
Google Cloud Platform
Informatica Powercenter
Snowflake
Ab Initio
Backend
PySpark
Information Technology
Data Pipelines
Testrail
Databricks

Job description

We are looking for an experienced ETL Tester with strong expertise in Python and exposure to AI/ML technologies. The ideal candidate will be responsible for validating ETL processes, data pipelines, data quality, and automation testing in a fast-paced environment., Design, develop, and execute test cases for ETL/Data Warehouse projects. Validate source-to-target data mappings, transformations, and data integrity. Perform testing on databases, data marts, and large datasets. Develop automated test scripts using Python for ETL validation. Work with SQL queries for backend data testing and reconciliation. Validate data pipelines in cloud platforms like AWS / Azure / Google Cloud Platform. Collaborate with developers, business analysts, and data engineers. Perform regression, integration, system, and UAT testing. Use AI tools for test automation, anomaly detection, or intelligent reporting. Identify defects, track issues, and ensure timely resolution.

Requirements

Strong experience in ETL Testing and Data Warehouse testing. Hands-on experience with Python scripting. Strong knowledge of SQL, joins, stored procedures, and database testing. Experience with ETL tools such as Informatica, Talend, SSIS, Ab Initio, or similar. Knowledge of AI/ML concepts or experience using AI-based testing tools. Familiarity with cloud platforms (AWS, Azure, or Google Cloud Platform). Experience with test management tools like JIRA, ALM, TestRail. Understanding of Agile/Scrum methodologies.

Preferred Qualifications: Experience with PySpark, Hadoop, Snowflake, Databricks. Exposure to predictive analytics or NLP testing. ISTQB certification is a plus., Bachelor s degree in Computer Science, IT, or related field.

Apply for this position