Overview
Remote
Depends on Experience
Accepts corp to corp applications
Contract - W2
Contract - 18 Month(s)
No Travel Required
Skills
Extract
Transform
Test Plans
ETL QA
Extract
Transform
Load
Data Governance
Data Warehouse
Functional Testing
JSON
Microsoft SQL Server
Microsoft SSIS
Test Cases
System Testing
SQL
Shell Scripting
Automated Testing
Regulatory Compliance
Stored Procedures
Flat File
Python
Performance Testing
Job Details
ETL Tester DOE -Remote
Long Term Contract - Min 13+ Years Exp required
Responsibilities
- Data Validation & Integrity – Ensure data is correctly extracted, transformed, and loaded into target systems.
- Test Case Design – Develop and execute test cases for ETL processes.
- ETL Functional Testing – Write and run complex SQL queries and stored procedures to verify data correctness. Test the ETL packages for full load and incremental. Verify the data between SQL Server Source to Target; Flat files to SQL Server; JSON to SQL Server and vice versa.
- Performance Testing – Identify performance bottlenecks and help ETL developers in optimizing the ETL workflows.
- Defect Tracking & Resolution – Log and resolve data discrepancies using JIRA.
- Automation – Implement automated testing frameworks for ETL validation.
- Collaboration – Work with data engineers, analysts, and ETL developers to ensure smooth data operations.
Required Skills
- Strong SQL and database knowledge.
- Strong experience with SQL Server and SSIS.
- Familiarity with data warehousing concepts (star schema, snowflake schema).
- Knowledge of Power Shell scripting/.NET/Python/VB Scripting for creating automation frameworks for ETL testing.
- Understanding of data governance and compliance.
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.