Need ETL Tester // Remote // 24+ months contract

Summary: The role is for an ETL Tester with a focus on data validation, integrity, and performance testing, primarily working in a remote capacity. The position requires strong SQL skills and experience with SQL Server and SSIS, along with the ability to collaborate with data engineers and analysts. The contract duration is expected to exceed 24 months, with a preference for candidates located in New York or New Jersey. The role is classified as outside IR35.

Key Responsibilities:

• Ensure data is correctly extracted, transformed, and loaded into target systems.
• Develop and execute test cases for ETL processes.
• 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.
• Identify performance bottlenecks and help ETL developers in optimizing the ETL workflows.
• Log and resolve data discrepancies using JIRA.
• Implement automated testing frameworks for ETL validation.
• Work with data engineers, analysts, and ETL developers to ensure smooth data operations.

Key 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.

Salary (Rate): undetermined

City: undetermined

Country: USA

Working Arrangements: remote

IR35 Status: outside IR35

Seniority Level: undetermined

Industry: IT