Overview
Remote
Depends on Experience
Contract - W2
Contract - 18 Month(s)
Skills
ETL Tester
SQL
ETL
SSIS
SQL queries
stored procedures
Jira
SQL Server
ETL testing
ETL Functional Testing
Performance Testing
Defect Tracking
Job Details
- 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. & Need Strong exp in SQL, ETL & SSIS.
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.