Overview
Remote
$50 - $80
Contract - Independent
Contract - W2
Contract - 24 Month(s)
Skills
ETL
Job Details
HI All,
Adding the new role to our priorities - ETL Tester -Remote
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.